PREVIEW / etf_1hour / 2015-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-22.parquet
  size:    243 KB
  rows:    7,799

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
2015-06-22 04:00:00	SPY	ETF	211.65	212.21	211.65	212.17	38402.0
2015-06-22 05:00:00	SPY	ETF	212.1	212.17	211.94	211.94	23346.0
2015-06-22 06:00:00	SPY	ETF	211.93	212.09	210.6	211.57	163366.0
2015-06-22 07:00:00	SPY	ETF	211.57	211.93	211.56	211.83	504028.0
2015-06-22 08:00:00	SPY	ETF	211.83	211.89	211.47	211.57	1015301.0
2015-06-22 09:00:00	SPY	ETF	211.57	212.18	211.54	212.09	10990647.0
2015-06-22 10:00:00	SPY	ETF	212.08	212.46	211.97	212.3445	12021863.0
2015-06-22 11:00:00	SPY	ETF	212.35	212.59	212.14	212.18	8236493.0
2015-06-22 12:00:00	SPY	ETF	212.17	212.21	211.64	211.9862	7152345.0
2015-06-22 13:00:00	SPY	ETF	211.98	212.5	211.68	211.95	4989018.0
2015-06-22 14:00:00	SPY	ETF	211.955	212.15	211.81	212.07	5863936.0
2015-06-22 15:00:00	SPY	ETF	212.06	212.09	211.74	211.9	13340768.0
2015-06-22 16:00:00	SPY	ETF	211.92	211.94	211.55	211.88	5417852.0
2015-06-22 17:00:00	SPY	ETF	211.9	211.98	211.86	211.9	184439.0
2015-06-22 18:00:00	SPY	ETF	211.9	212.0	211.86	212.0	89877.0
2015-06-22 19:00:00	SPY	ETF	212.0	212.13	212.0	212.05	46916.0
2015-06-22 04:00:00	QQQ	ETF	110.62	110.91	110.62	110.76	19719.0
2015-06-22 05:00:00	QQQ	ETF	110.89	110.89	110.89	110.89	1800.0
2015-06-22 06:00:00	QQQ	ETF	110.9	110.9	110.62	110.62	16100.0
2015-06-22 07:00:00	QQQ	ETF	110.65	110.8	110.65	110.73	50990.0
2015-06-22 08:00:00	QQQ	ETF	110.68	110.76	110.36	110.57	210236.0
2015-06-22 09:00:00	QQQ	ETF	110.58	110.89	110.541	110.75	3358353.0
2015-06-22 10:00:00	QQQ	ETF	110.76	110.9	110.6601	110.78	2643956.0
2015-06-22 11:00:00	QQQ	ETF	110.78	111.03	110.7	110.8599	2511051.0
2015-06-22 12:00:00	QQQ	ETF	110.86	110.875	110.5	110.699	2285219.0
2015-06-22 13:00:00	QQQ	ETF	110.6935	110.7	110.45	110.68	1050321.0
2015-06-22 14:00:00	QQQ	ETF	110.67	110.81	110.57	110.78	1629902.0
2015-06-22 15:00:00	QQQ	ETF	110.78	110.8156	110.575	110.68	1757903.0
2015-06-22 16:00:00	QQQ	ETF	110.68	110.7	110.5	110.66	1682992.0
2015-06-22 17:00:00	QQQ	ETF	110.7	110.72	110.65	110.72	310070.0
2015-06-22 18:00:00	QQQ	ETF	110.68	110.74	110.68	110.74	14214.0
2015-06-22 19:00:00	QQQ	ETF	110.74	110.77	110.71	110.71	49100.0
2015-06-22 04:00:00	IWM	ETF	128.4	128.4	128.32	128.32	888.0
2015-06-22 06:00:00	IWM	ETF	128.57	128.69	128.32	128.32	10214.0
2015-06-22 07:00:00	IWM	ETF	128.3	128.4	128.29	128.35	16499.0
2015-06-22 08:00:00	IWM	ETF	128.6	128.6	128.23	128.29	234432.0
2015-06-22 09:00:00	IWM	ETF	128.3	128.71	128.15	128.6862	3561121.0
2015-06-22 10:00:00	IWM	ETF	128.685	128.84	128.38	128.44	3666798.0
2015-06-22 11:00:00	IWM	ETF	128.45	128.82	128.33	128.51	2739780.0
2015-06-22 12:00:00	IWM	ETF	128.51	128.62	128.32	128.569	1493332.0
2015-06-22 13:00:00	IWM	ETF	128.565	128.62	128.4	128.51	1078735.0
2015-06-22 14:00:00	IWM	ETF	128.52	128.79	128.505	128.74	1613563.0
2015-06-22 15:00:00	IWM	ETF	128.75	128.775	128.51	128.72	3306273.0
2015-06-22 16:00:00	IWM	ETF	128.72	128.8	128.57	128.77	1919090.0
2015-06-22 17:00:00	IWM	ETF	128.78	128.81	128.74	128.79	808938.0
2015-06-22 18:00:00	IWM	ETF	128.74	128.79	128.74	128.79	1400.0
2015-06-22 19:00:00	IWM	ETF	128.8	128.8	128.75	128.75	600.0
2015-06-22 07:00:00	DIA	ETF	180.97	181.01	180.97	181.01	4450.0
2015-06-22 08:00:00	DIA	ETF	180.8	180.98	180.67	180.7	7238.0
2015-06-22 09:00:00	DIA	ETF	180.8	181.17	180.69	181.08	1588676.0

> showing 50 of 7,799 rows — these rows as CSV

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