PREVIEW / etf_1hour / 2017-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-06.parquet
  size:    275 KB
  rows:    8,952

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-06 04:00:00	SPY	ETF	229.37	229.49	229.37	229.46	10032.0
2017-02-06 05:00:00	SPY	ETF	229.49	229.54	229.49	229.49	6550.0
2017-02-06 06:00:00	SPY	ETF	229.49	229.51	229.22	229.24	18250.0
2017-02-06 07:00:00	SPY	ETF	229.24	229.27	228.98	228.98	58178.0
2017-02-06 08:00:00	SPY	ETF	228.95	229.28	228.58	228.81	530737.0
2017-02-06 09:00:00	SPY	ETF	228.82	229.255	228.82	229.14	6797922.0
2017-02-06 10:00:00	SPY	ETF	229.14	229.326	228.915	228.93	6911791.0
2017-02-06 11:00:00	SPY	ETF	228.92	229.26	228.89	229.02	5153368.0
2017-02-06 12:00:00	SPY	ETF	229.01	229.0499	228.72	228.74	4660720.0
2017-02-06 13:00:00	SPY	ETF	228.74	228.83	228.54	228.8	6835973.0
2017-02-06 14:00:00	SPY	ETF	228.8	228.84	228.66	228.765	7335752.0
2017-02-06 15:00:00	SPY	ETF	228.77	228.97	228.75	228.97	10281870.0
2017-02-06 16:00:00	SPY	ETF	228.97	228.99	228.74	228.84	3343385.0
2017-02-06 17:00:00	SPY	ETF	228.81	228.93	228.76	228.77	1341170.0
2017-02-06 18:00:00	SPY	ETF	228.77	228.9	228.76	228.86	19477.0
2017-02-06 19:00:00	SPY	ETF	228.85	228.86	228.62	228.7	34410.0
2017-02-06 04:00:00	QQQ	ETF	125.59	125.59	125.59	125.59	4000.0
2017-02-06 05:00:00	QQQ	ETF	125.76	125.77	125.76	125.77	5114.0
2017-02-06 06:00:00	QQQ	ETF	125.74	125.76	125.65	125.65	11400.0
2017-02-06 07:00:00	QQQ	ETF	125.62	125.62	125.5	125.5	9006.0
2017-02-06 08:00:00	QQQ	ETF	125.47	125.47	125.3	125.4	62046.0
2017-02-06 09:00:00	QQQ	ETF	125.42	125.61	125.35	125.54	1781332.0
2017-02-06 10:00:00	QQQ	ETF	125.55	125.68	125.46	125.55	1317029.0
2017-02-06 11:00:00	QQQ	ETF	125.54	125.85	125.53	125.7361	1272963.0
2017-02-06 12:00:00	QQQ	ETF	125.73	125.7565	125.62	125.645	832466.0
2017-02-06 13:00:00	QQQ	ETF	125.6407	125.68	125.5	125.65	718927.0
2017-02-06 14:00:00	QQQ	ETF	125.659	125.69	125.59	125.66	845083.0
2017-02-06 15:00:00	QQQ	ETF	125.66	125.83	125.65	125.82	2695390.0
2017-02-06 16:00:00	QQQ	ETF	125.83	125.8517	125.67	125.74	873207.0
2017-02-06 17:00:00	QQQ	ETF	125.77	125.77	125.71	125.71	546.0
2017-02-06 18:00:00	QQQ	ETF	125.71	125.72	125.7	125.72	8409.0
2017-02-06 19:00:00	QQQ	ETF	125.74	125.74	125.63	125.65	7799.0
2017-02-06 04:00:00	IWM	ETF	137.03	137.03	137.03	137.03	329.0
2017-02-06 06:00:00	IWM	ETF	137.02	137.02	136.81	136.86	2924.0
2017-02-06 07:00:00	IWM	ETF	136.82	136.83	136.66	136.67	84971.0
2017-02-06 08:00:00	IWM	ETF	136.67	136.67	136.24	136.45	133700.0
2017-02-06 09:00:00	IWM	ETF	136.45	136.62	136.07	136.375	2430891.0
2017-02-06 10:00:00	IWM	ETF	136.38	136.7784	136.21	136.25	2224216.0
2017-02-06 11:00:00	IWM	ETF	136.24	136.445	136.18	136.24	1895393.0
2017-02-06 12:00:00	IWM	ETF	136.22	136.37	135.66	135.685	3264771.0
2017-02-06 13:00:00	IWM	ETF	135.685	135.83	135.43	135.725	2781812.0
2017-02-06 14:00:00	IWM	ETF	135.74	135.77	135.55	135.59	1849528.0
2017-02-06 15:00:00	IWM	ETF	135.59	135.82	135.555	135.82	3313388.0
2017-02-06 16:00:00	IWM	ETF	135.84	135.92	135.56	135.65	2622687.0
2017-02-06 17:00:00	IWM	ETF	135.62	135.64	135.62	135.64	1152.0
2017-02-06 18:00:00	IWM	ETF	135.65	135.65	135.65	135.65	4005.0
2017-02-06 19:00:00	IWM	ETF	135.65	135.73	135.62	135.7	15128.0
2017-02-06 08:00:00	DIA	ETF	200.25	200.25	199.93	199.99	956.0
2017-02-06 09:00:00	DIA	ETF	200.03	200.59	199.78	200.52	368094.0
2017-02-06 10:00:00	DIA	ETF	200.5	200.7	200.38	200.38	306938.0

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

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