PREVIEW / etf_1hour / 2019-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-11.parquet
  size:    313 KB
  rows:    10,425

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
2019-01-11 04:00:00	SPY	ETF	258.94	259.03	258.66	258.83	48342.0
2019-01-11 05:00:00	SPY	ETF	258.75	258.83	258.16	258.44	28536.0
2019-01-11 06:00:00	SPY	ETF	258.45	258.59	258.16	258.17	23695.0
2019-01-11 07:00:00	SPY	ETF	258.29	258.36	258.0	258.05	136291.0
2019-01-11 08:00:00	SPY	ETF	258.05	258.8	257.59	257.87	483952.0
2019-01-11 09:00:00	SPY	ETF	257.84	258.02	257.03	257.54	7821184.0
2019-01-11 10:00:00	SPY	ETF	257.54	258.17	257.07	258.14	13690104.0
2019-01-11 11:00:00	SPY	ETF	258.15	258.49	257.58	258.44	7884612.0
2019-01-11 12:00:00	SPY	ETF	258.43	258.91	258.24	258.74	5898845.0
2019-01-11 13:00:00	SPY	ETF	258.74	258.76	257.87	258.33	7510733.0
2019-01-11 14:00:00	SPY	ETF	258.33	259.0098	258.1215	258.265	6850478.0
2019-01-11 15:00:00	SPY	ETF	258.26	258.98	258.2	258.91	12682959.0
2019-01-11 16:00:00	SPY	ETF	258.91	258.99	258.75	258.88	8093080.0
2019-01-11 17:00:00	SPY	ETF	258.83	258.98	258.66	258.68	184827.0
2019-01-11 18:00:00	SPY	ETF	258.69	258.79	258.63	258.77	12665.0
2019-01-11 19:00:00	SPY	ETF	258.76	258.82	258.71	258.74	972485.0
2019-01-11 04:00:00	QQQ	ETF	161.15	161.22	160.94	161.04	22026.0
2019-01-11 05:00:00	QQQ	ETF	161.04	161.04	160.64	160.9	14969.0
2019-01-11 06:00:00	QQQ	ETF	160.8	160.92	160.57	160.57	21758.0
2019-01-11 07:00:00	QQQ	ETF	160.69	160.74	160.47	160.47	89493.0
2019-01-11 08:00:00	QQQ	ETF	160.46	161.05	160.21	160.43	432809.0
2019-01-11 09:00:00	QQQ	ETF	160.37	160.51	159.79	160.19	3821484.0
2019-01-11 10:00:00	QQQ	ETF	160.19	160.6199	159.8	160.51	3925306.0
2019-01-11 11:00:00	QQQ	ETF	160.51	160.6	159.99	160.465	2747639.0
2019-01-11 12:00:00	QQQ	ETF	160.46	160.84	160.37	160.69	2160667.0
2019-01-11 13:00:00	QQQ	ETF	160.69	160.72	160.04	160.2219	2435281.0
2019-01-11 14:00:00	QQQ	ETF	160.22	160.62	160.09	160.42	2154079.0
2019-01-11 15:00:00	QQQ	ETF	160.42	160.86	160.4	160.76	4401630.0
2019-01-11 16:00:00	QQQ	ETF	160.77	160.82	160.65	160.8	4333291.0
2019-01-11 17:00:00	QQQ	ETF	160.83	160.88	160.65	160.66	10726.0
2019-01-11 18:00:00	QQQ	ETF	160.69	160.7	160.48	160.68	14201.0
2019-01-11 19:00:00	QQQ	ETF	160.6	160.7	160.6	160.7	10682.0
2019-01-11 05:00:00	IWM	ETF	143.47	143.47	143.27	143.27	1100.0
2019-01-11 06:00:00	IWM	ETF	143.44	143.44	143.44	143.44	2117.0
2019-01-11 07:00:00	IWM	ETF	143.27	143.27	143.12	143.12	3155.0
2019-01-11 08:00:00	IWM	ETF	143.1801	143.64	142.88	143.0	147413.0
2019-01-11 09:00:00	IWM	ETF	143.04	143.27	142.74	143.07	2014069.0
2019-01-11 10:00:00	IWM	ETF	143.06	143.4764	142.7	143.275	2602453.0
2019-01-11 11:00:00	IWM	ETF	143.27	143.35	142.6775	143.225	2313923.0
2019-01-11 12:00:00	IWM	ETF	143.22	143.99	143.2	143.88	2106822.0
2019-01-11 13:00:00	IWM	ETF	143.88	143.93	143.51	143.7	1824306.0
2019-01-11 14:00:00	IWM	ETF	143.72	143.94	143.5	143.56	1454741.0
2019-01-11 15:00:00	IWM	ETF	143.55	143.94	143.5	143.71	4778625.0
2019-01-11 16:00:00	IWM	ETF	143.72	143.86	143.65	143.66	2926300.0
2019-01-11 17:00:00	IWM	ETF	143.7	143.77	143.6	143.6	1898.0
2019-01-11 18:00:00	IWM	ETF	143.6	143.6	143.6	143.6	1181.0
2019-01-11 19:00:00	IWM	ETF	143.6	143.7	143.6	143.7	1867.0
2019-01-11 07:00:00	DIA	ETF	239.35	239.56	239.34	239.45	2900.0
2019-01-11 08:00:00	DIA	ETF	239.4701	239.85	239.0	239.03	17661.0
2019-01-11 09:00:00	DIA	ETF	239.21	239.25	238.0301	238.48	322022.0

> showing 50 of 10,425 rows — these rows as CSV

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