PREVIEW / etf_1hour / 2017-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-09.parquet
  size:    273 KB
  rows:    8,859

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2017-02-09 04:00:00	SPY	ETF	229.2	229.27	229.2	229.26	1800.0
2017-02-09 05:00:00	SPY	ETF	229.24	229.35	229.23	229.23	4130.0
2017-02-09 06:00:00	SPY	ETF	229.39	229.8	229.39	229.73	117720.0
2017-02-09 07:00:00	SPY	ETF	229.7	229.73	229.5	229.62	124553.0
2017-02-09 08:00:00	SPY	ETF	229.68	229.68	229.37	229.45	318874.0
2017-02-09 09:00:00	SPY	ETF	229.45	229.81	229.43	229.7601	5780404.0
2017-02-09 10:00:00	SPY	ETF	229.77	230.53	229.73	230.49	11821491.0
2017-02-09 11:00:00	SPY	ETF	230.49	230.79	230.4	230.645	7272227.0
2017-02-09 12:00:00	SPY	ETF	230.65	230.78	230.4399	230.555	5911265.0
2017-02-09 13:00:00	SPY	ETF	230.56	230.74	230.51	230.74	4492750.0
2017-02-09 14:00:00	SPY	ETF	230.74	230.95	230.7	230.87	8803371.0
2017-02-09 15:00:00	SPY	ETF	230.88	230.94	230.54	230.57	12241570.0
2017-02-09 16:00:00	SPY	ETF	230.57	230.65	230.5	230.59	6047470.0
2017-02-09 17:00:00	SPY	ETF	230.6	230.64	230.38	230.59	508005.0
2017-02-09 18:00:00	SPY	ETF	230.6	230.63	230.51	230.6	102171.0
2017-02-09 19:00:00	SPY	ETF	230.58	230.6	230.53	230.6	26881.0
2017-02-09 05:00:00	QQQ	ETF	126.63	126.65	126.63	126.65	15000.0
2017-02-09 06:00:00	QQQ	ETF	126.65	126.78	126.65	126.78	12750.0
2017-02-09 07:00:00	QQQ	ETF	126.75	126.75	126.63	126.66	5999.0
2017-02-09 08:00:00	QQQ	ETF	126.66	126.66	126.5	126.58	38836.0
2017-02-09 09:00:00	QQQ	ETF	126.64	126.83	126.56	126.719	1840930.0
2017-02-09 10:00:00	QQQ	ETF	126.71	126.94	126.66	126.9	2505279.0
2017-02-09 11:00:00	QQQ	ETF	126.91	127.219	126.87	127.14	1931568.0
2017-02-09 12:00:00	QQQ	ETF	127.14	127.165	126.93	127.021	1344595.0
2017-02-09 13:00:00	QQQ	ETF	127.02	127.14	126.995	127.14	1491549.0
2017-02-09 14:00:00	QQQ	ETF	127.135	127.24	127.11	127.18	1124459.0
2017-02-09 15:00:00	QQQ	ETF	127.19	127.23	126.94	126.97	2369226.0
2017-02-09 16:00:00	QQQ	ETF	126.98	127.12	126.94	127.03	2451541.0
2017-02-09 17:00:00	QQQ	ETF	127.05	127.05	126.98	127.03	9468.0
2017-02-09 18:00:00	QQQ	ETF	127.04	127.08	127.0	127.05	7748.0
2017-02-09 19:00:00	QQQ	ETF	127.07	127.09	127.04	127.08	2875.0
2017-02-09 04:00:00	IWM	ETF	135.03	135.03	135.01	135.01	300.0
2017-02-09 06:00:00	IWM	ETF	135.23	135.45	135.23	135.42	6300.0
2017-02-09 07:00:00	IWM	ETF	135.38	135.43	135.21	135.23	40539.0
2017-02-09 08:00:00	IWM	ETF	135.19	135.22	135.0	135.08	215958.0
2017-02-09 09:00:00	IWM	ETF	135.08	136.0	135.08	135.92	2643082.0
2017-02-09 10:00:00	IWM	ETF	135.92	136.75	135.92	136.67	5660362.0
2017-02-09 11:00:00	IWM	ETF	136.66	137.25	136.625	136.98	4494811.0
2017-02-09 12:00:00	IWM	ETF	136.975	137.14	136.8	136.9	2433058.0
2017-02-09 13:00:00	IWM	ETF	136.89	137.03	136.83	137.0263	1365754.0
2017-02-09 14:00:00	IWM	ETF	137.03	137.0899	136.85	137.02	1599811.0
2017-02-09 15:00:00	IWM	ETF	137.03	137.08	136.78	136.92	4950195.0
2017-02-09 16:00:00	IWM	ETF	136.9	136.9928	136.8	136.88	2199366.0
2017-02-09 17:00:00	IWM	ETF	136.9	136.95	136.87	136.92	3847.0
2017-02-09 19:00:00	IWM	ETF	136.93	136.94	136.91	136.93	3700.0
2017-02-09 06:00:00	DIA	ETF	200.67	200.67	200.67	200.67	100.0
2017-02-09 07:00:00	DIA	ETF	200.87	200.87	200.87	200.87	422.0
2017-02-09 08:00:00	DIA	ETF	200.85	200.85	200.85	200.85	800.0
2017-02-09 09:00:00	DIA	ETF	200.76	200.99	200.76	200.96	232811.0
2017-02-09 10:00:00	DIA	ETF	200.97	201.62	200.95	201.57	761941.0

> showing 50 of 8,859 rows — these rows as CSV

> unlock the full archive -- $79 one-time