PREVIEW / etf_1hour / 2016-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-20.parquet
  size:    275 KB
  rows:    8,719

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
2016-01-20 04:00:00	SPY	ETF	184.05	184.82	183.48	184.5	113853.0
2016-01-20 05:00:00	SPY	ETF	184.55	184.65	184.08	184.18	36433.0
2016-01-20 06:00:00	SPY	ETF	184.25	184.8	184.2	184.5	288904.0
2016-01-20 07:00:00	SPY	ETF	184.55	184.7	184.09	184.5	767983.0
2016-01-20 08:00:00	SPY	ETF	184.05	185.29	184.05	185.03	2458860.0
2016-01-20 09:00:00	SPY	ETF	185.04	185.81	184.0	184.149	26318371.0
2016-01-20 10:00:00	SPY	ETF	184.14	184.45	182.3	182.34	41278210.0
2016-01-20 11:00:00	SPY	ETF	182.35	183.58	182.24	182.468	28618476.0
2016-01-20 12:00:00	SPY	ETF	182.47	182.8	181.02	182.6401	35584651.0
2016-01-20 13:00:00	SPY	ETF	182.65	184.515	181.77	184.11	39552818.0
2016-01-20 14:00:00	SPY	ETF	184.11	184.93	183.46	184.48	33114056.0
2016-01-20 15:00:00	SPY	ETF	184.48	187.495	184.24	185.79	61583758.0
2016-01-20 16:00:00	SPY	ETF	185.78	186.23	184.0749	185.77	11743896.0
2016-01-20 17:00:00	SPY	ETF	185.8	186.07	185.69	186.07	528350.0
2016-01-20 18:00:00	SPY	ETF	186.07	187.0	185.82	186.6	709967.0
2016-01-20 19:00:00	SPY	ETF	186.6	187.25	185.81	187.12	255799.0
2016-01-20 20:00:00	SPY	ETF	185.7708	185.7708	185.7708	185.7708	550000.0
2016-01-20 04:00:00	QQQ	ETF	99.01	99.3	98.6	99.17	36938.0
2016-01-20 05:00:00	QQQ	ETF	99.0	99.06	98.92	98.92	6800.0
2016-01-20 06:00:00	QQQ	ETF	99.02	99.3	98.98	99.17	7632.0
2016-01-20 07:00:00	QQQ	ETF	99.18	99.28	98.98	99.17	97134.0
2016-01-20 08:00:00	QQQ	ETF	99.17	101.06	99.0699	99.53	215198.0
2016-01-20 09:00:00	QQQ	ETF	99.54	99.86	98.61	98.74	9733891.0
2016-01-20 10:00:00	QQQ	ETF	98.73	99.02	97.73	97.79	14924409.0
2016-01-20 11:00:00	QQQ	ETF	97.79	98.82	97.78	98.1501	8666458.0
2016-01-20 12:00:00	QQQ	ETF	98.15	98.45	97.25	98.4	9398876.0
2016-01-20 13:00:00	QQQ	ETF	98.4	99.97	97.9	99.8048	10527584.0
2016-01-20 14:00:00	QQQ	ETF	99.79	100.19	99.21	99.85	8651358.0
2016-01-20 15:00:00	QQQ	ETF	99.84	101.83	99.68	100.77	16423310.0
2016-01-20 16:00:00	QQQ	ETF	100.78	101.0	100.56	100.77	875902.0
2016-01-20 17:00:00	QQQ	ETF	100.75	100.93	100.7	100.86	15263.0
2016-01-20 18:00:00	QQQ	ETF	100.9	101.42	100.9	101.24	67801.0
2016-01-20 19:00:00	QQQ	ETF	101.24	101.62	101.24	101.54	40024.0
2016-01-20 04:00:00	IWM	ETF	96.83	96.9	96.48	96.9	23960.0
2016-01-20 05:00:00	IWM	ETF	96.97	97.05	96.79	96.79	25830.0
2016-01-20 06:00:00	IWM	ETF	96.93	97.12	96.84	96.91	7825.0
2016-01-20 07:00:00	IWM	ETF	97.09	97.12	96.82	96.95	52346.0
2016-01-20 08:00:00	IWM	ETF	97.0	97.49	96.92	97.44	354777.0
2016-01-20 09:00:00	IWM	ETF	97.39	97.64	96.32	96.49	8683487.0
2016-01-20 10:00:00	IWM	ETF	96.48	96.6	95.38	95.38	15354742.0
2016-01-20 11:00:00	IWM	ETF	95.39	96.66	95.39	95.8302	7977448.0
2016-01-20 12:00:00	IWM	ETF	95.84	96.4	95.06	96.38	8285292.0
2016-01-20 13:00:00	IWM	ETF	96.39	98.1	96.01	97.82	11094335.0
2016-01-20 14:00:00	IWM	ETF	97.79	98.78	97.25	98.4702	9662864.0
2016-01-20 15:00:00	IWM	ETF	98.46	100.325	98.32	99.18	19139359.0
2016-01-20 16:00:00	IWM	ETF	99.17	99.61	96.48	99.09	6923921.0
2016-01-20 17:00:00	IWM	ETF	99.14	99.35	99.14	99.2	34194.0
2016-01-20 18:00:00	IWM	ETF	99.2	99.45	99.2	99.32	11380.0
2016-01-20 19:00:00	IWM	ETF	99.75	99.79	99.75	99.7899	700.0
2016-01-20 04:00:00	DIA	ETF	156.53	156.65	156.37	156.37	509.0

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

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