PREVIEW / etf_1hour / 2015-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-23.parquet
  size:    250 KB
  rows:    7,989

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-10-23 04:00:00	SPY	ETF	206.21	206.21	206.1	206.15	10907.0
2015-10-23 05:00:00	SPY	ETF	206.17	206.71	206.14	206.71	27460.0
2015-10-23 06:00:00	SPY	ETF	206.73	206.94	206.68	206.72	43451.0
2015-10-23 07:00:00	SPY	ETF	206.72	208.02	206.68	207.63	1642863.0
2015-10-23 08:00:00	SPY	ETF	207.63	207.97	206.33	207.6	1685034.0
2015-10-23 09:00:00	SPY	ETF	207.61	207.76	206.86	207.68	20994352.0
2015-10-23 10:00:00	SPY	ETF	207.69	207.76	206.74	206.98	22019198.0
2015-10-23 11:00:00	SPY	ETF	206.99	207.28	206.3	206.4975	17456300.0
2015-10-23 12:00:00	SPY	ETF	206.51	207.04	206.36	207.0	10426005.0
2015-10-23 13:00:00	SPY	ETF	206.99	207.48	206.68	207.32	12657305.0
2015-10-23 14:00:00	SPY	ETF	207.321	207.95	207.17	207.69	16769064.0
2015-10-23 15:00:00	SPY	ETF	207.69	207.87	207.21	207.51	25898236.0
2015-10-23 16:00:00	SPY	ETF	207.49	207.5986	207.1	207.51	11999787.0
2015-10-23 17:00:00	SPY	ETF	207.13	207.35	207.09	207.27	148465.0
2015-10-23 18:00:00	SPY	ETF	207.31	207.32	207.25	207.29	22797.0
2015-10-23 19:00:00	SPY	ETF	207.29	207.3	207.26	207.29	14727.0
2015-10-23 04:00:00	QQQ	ETF	111.49	111.69	111.49	111.69	31458.0
2015-10-23 05:00:00	QQQ	ETF	111.71	111.9	111.71	111.9	21220.0
2015-10-23 06:00:00	QQQ	ETF	111.95	112.09	111.94	111.95	54401.0
2015-10-23 07:00:00	QQQ	ETF	111.99	112.98	111.95	112.92	644295.0
2015-10-23 08:00:00	QQQ	ETF	112.92	112.94	111.98	112.67	427508.0
2015-10-23 09:00:00	QQQ	ETF	112.7	112.84	112.1049	112.76	10707684.0
2015-10-23 10:00:00	QQQ	ETF	112.756	112.8	112.08	112.28	8185856.0
2015-10-23 11:00:00	QQQ	ETF	112.27	112.45	112.12	112.17	4459368.0
2015-10-23 12:00:00	QQQ	ETF	112.17	112.62	112.07	112.56	3526726.0
2015-10-23 13:00:00	QQQ	ETF	112.56	112.98	112.39	112.89	3501355.0
2015-10-23 14:00:00	QQQ	ETF	112.89	113.24	112.8	113.06	4198805.0
2015-10-23 15:00:00	QQQ	ETF	113.0599	113.18	112.656	112.77	7378508.0
2015-10-23 16:00:00	QQQ	ETF	112.77	112.8	112.6	112.6	1505128.0
2015-10-23 17:00:00	QQQ	ETF	112.6	112.75	112.59	112.75	7548.0
2015-10-23 18:00:00	QQQ	ETF	112.65	112.65	112.65	112.65	250.0
2015-10-23 19:00:00	QQQ	ETF	112.66	112.76	112.65	112.67	3247.0
2015-10-23 04:00:00	IWM	ETF	115.37	115.37	115.35	115.35	400.0
2015-10-23 06:00:00	IWM	ETF	115.58	115.58	115.52	115.52	900.0
2015-10-23 07:00:00	IWM	ETF	115.52	116.14	115.45	116.14	51213.0
2015-10-23 08:00:00	IWM	ETF	116.1	116.2	115.93	115.95	171191.0
2015-10-23 09:00:00	IWM	ETF	115.96	115.96	114.83	115.83	6068139.0
2015-10-23 10:00:00	IWM	ETF	115.84	116.05	115.38	115.56	7060531.0
2015-10-23 11:00:00	IWM	ETF	115.555	115.77	114.73	114.839	4581968.0
2015-10-23 12:00:00	IWM	ETF	114.84	115.3	114.73	115.1433	3533050.0
2015-10-23 13:00:00	IWM	ETF	115.14	115.3125	114.88	115.16	2437076.0
2015-10-23 14:00:00	IWM	ETF	115.17	115.96	115.05	115.82	4603293.0
2015-10-23 15:00:00	IWM	ETF	115.82	115.91	115.37	115.85	6430653.0
2015-10-23 16:00:00	IWM	ETF	115.85	115.88	115.1915	115.73	1045549.0
2015-10-23 17:00:00	IWM	ETF	115.72	115.74	115.68	115.74	1200.0
2015-10-23 18:00:00	IWM	ETF	115.68	115.68	115.68	115.68	475.0
2015-10-23 05:00:00	DIA	ETF	175.3	175.4	175.3	175.4	800.0
2015-10-23 06:00:00	DIA	ETF	175.7	175.7	175.5	175.5	2000.0
2015-10-23 07:00:00	DIA	ETF	175.65	176.32	175.65	176.24	16721.0
2015-10-23 08:00:00	DIA	ETF	176.31	176.43	176.23	176.33	10526.0

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

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