PREVIEW / etf_1hour / 2018-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-24.parquet
  size:    232 KB
  rows:    7,308

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
2018-12-24 04:00:00	SPY	ETF	241.7	241.86	241.17	241.6	66110.0
2018-12-24 05:00:00	SPY	ETF	241.52	241.78	241.4	241.71	42948.0
2018-12-24 06:00:00	SPY	ETF	241.72	241.85	241.15	241.15	50814.0
2018-12-24 07:00:00	SPY	ETF	241.06	241.06	238.44	238.44	822515.0
2018-12-24 08:00:00	SPY	ETF	240.63	242.45	238.25	238.95	2593309.0
2018-12-24 09:00:00	SPY	ETF	238.96	240.0	236.57	237.3785	22906404.0
2018-12-24 10:00:00	SPY	ETF	237.37	240.8355	235.9	238.6175	35631514.0
2018-12-24 11:00:00	SPY	ETF	238.63	239.16	236.02	236.36	27385518.0
2018-12-24 12:00:00	SPY	ETF	236.36	240.8355	234.31	234.33	38363239.0
2018-12-24 13:00:00	SPY	ETF	234.41	240.8355	233.15	233.2	8451086.0
2018-12-24 14:00:00	SPY	ETF	233.2	234.34	232.61	233.1	523850.0
2018-12-24 15:00:00	SPY	ETF	233.14	233.24	233.0	233.07	106842.0
2018-12-24 16:00:00	SPY	ETF	233.09	233.24	233.0	233.08	46095.0
2018-12-24 04:00:00	QQQ	ETF	148.0	148.32	147.85	148.19	18675.0
2018-12-24 05:00:00	QQQ	ETF	148.16	148.29	148.0	148.13	11100.0
2018-12-24 06:00:00	QQQ	ETF	148.18	148.47	147.84	147.84	27745.0
2018-12-24 07:00:00	QQQ	ETF	147.82	147.84	145.65	145.65	234665.0
2018-12-24 08:00:00	QQQ	ETF	147.56	148.5	145.59	146.0	419955.0
2018-12-24 09:00:00	QQQ	ETF	146.01	147.2	144.21	144.97	9765859.0
2018-12-24 10:00:00	QQQ	ETF	144.9688	147.98	144.25	146.99	12036097.0
2018-12-24 11:00:00	QQQ	ETF	147.0	147.37	144.92	145.16	7229408.0
2018-12-24 12:00:00	QQQ	ETF	145.16	145.7	143.52	143.53	12707463.0
2018-12-24 13:00:00	QQQ	ETF	143.54	144.0858	142.81	142.85	2717987.0
2018-12-24 14:00:00	QQQ	ETF	142.85	143.5	142.52	142.79	117683.0
2018-12-24 15:00:00	QQQ	ETF	142.9	142.95	142.65	142.71	23599.0
2018-12-24 16:00:00	QQQ	ETF	142.72	142.92	142.56	142.72	11659.0
2018-12-24 04:00:00	IWM	ETF	128.97	128.97	128.97	128.97	100.0
2018-12-24 05:00:00	IWM	ETF	128.97	129.0	128.97	128.97	5900.0
2018-12-24 06:00:00	IWM	ETF	129.05	129.15	128.94	128.94	1300.0
2018-12-24 07:00:00	IWM	ETF	128.72	128.72	127.45	127.45	32560.0
2018-12-24 08:00:00	IWM	ETF	127.81	129.15	127.32	127.77	108554.0
2018-12-24 09:00:00	IWM	ETF	127.9	128.07	126.41	126.76	4772316.0
2018-12-24 10:00:00	IWM	ETF	126.78	128.32	126.25	127.97	6674571.0
2018-12-24 11:00:00	IWM	ETF	127.97	128.47	126.95	127.17	5792051.0
2018-12-24 12:00:00	IWM	ETF	127.205	127.55	125.84	125.91	6723415.0
2018-12-24 13:00:00	IWM	ETF	125.93	126.21	125.21	125.4	2023281.0
2018-12-24 14:00:00	IWM	ETF	125.4654	125.88	125.11	125.88	72410.0
2018-12-24 15:00:00	IWM	ETF	125.45	125.45	125.3	125.36	14400.0
2018-12-24 16:00:00	IWM	ETF	125.35	125.35	125.35	125.35	220.0
2018-12-24 04:00:00	DIA	ETF	224.9	224.9	224.9	224.9	100.0
2018-12-24 05:00:00	DIA	ETF	224.72	224.84	224.72	224.72	1650.0
2018-12-24 06:00:00	DIA	ETF	224.86	224.98	224.65	224.67	12600.0
2018-12-24 07:00:00	DIA	ETF	224.62	224.62	222.08	222.08	79971.0
2018-12-24 08:00:00	DIA	ETF	222.96	225.16	222.02	222.77	71900.0
2018-12-24 09:00:00	DIA	ETF	222.74	223.31	220.433	221.14	1201617.0
2018-12-24 10:00:00	DIA	ETF	221.1	223.29	219.82	221.98	1529800.0
2018-12-24 11:00:00	DIA	ETF	222.01	222.5121	219.57	219.91	894411.0
2018-12-24 12:00:00	DIA	ETF	220.07	220.62	217.9	217.94	1693938.0
2018-12-24 13:00:00	DIA	ETF	217.97	218.1	216.85	217.55	127269.0
2018-12-24 14:00:00	DIA	ETF	217.5	217.5	217.1	217.5	2905.0

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

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