PREVIEW / etf_1hour / 2020-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-17.parquet
  size:    352 KB
  rows:    12,149

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
2020-07-17 04:00:00	SPY	ETF	319.66	320.41	319.6	320.3	17727.0
2020-07-17 05:00:00	SPY	ETF	320.15	320.65	319.97	320.32	15991.0
2020-07-17 06:00:00	SPY	ETF	320.4	321.03	320.35	320.95	92662.0
2020-07-17 07:00:00	SPY	ETF	320.97	320.97	320.61	320.88	113493.0
2020-07-17 08:00:00	SPY	ETF	320.815	321.82	320.0	321.3	632948.0
2020-07-17 09:00:00	SPY	ETF	321.28	322.089	320.93	321.315	5529479.0
2020-07-17 10:00:00	SPY	ETF	321.31	321.5	319.735	321.01	11649225.0
2020-07-17 11:00:00	SPY	ETF	321.0	321.53	320.68	321.39	4618336.0
2020-07-17 12:00:00	SPY	ETF	321.38	321.675	321.09	321.21	4583409.0
2020-07-17 13:00:00	SPY	ETF	321.21	321.5799	320.91	321.24	3812408.0
2020-07-17 14:00:00	SPY	ETF	321.25	322.23	321.24	322.01	6034517.0
2020-07-17 15:00:00	SPY	ETF	322.005	322.57	321.55	321.67	16145542.0
2020-07-17 16:00:00	SPY	ETF	321.67	322.11	321.3	321.41	7784779.0
2020-07-17 17:00:00	SPY	ETF	321.41	321.84	321.39	321.8	868789.0
2020-07-17 18:00:00	SPY	ETF	321.82	321.9	321.72	321.9	63609.0
2020-07-17 19:00:00	SPY	ETF	321.83	321.98	321.83	321.9	52865.0
2020-07-17 04:00:00	QQQ	ETF	258.16	259.02	257.9	259.01	58508.0
2020-07-17 05:00:00	QQQ	ETF	258.79	259.2	258.7	258.84	18850.0
2020-07-17 06:00:00	QQQ	ETF	258.8	259.18	258.8	259.0	19153.0
2020-07-17 07:00:00	QQQ	ETF	259.01	259.08	258.52	258.91	195163.0
2020-07-17 08:00:00	QQQ	ETF	258.8601	259.34	258.07	259.07	282060.0
2020-07-17 09:00:00	QQQ	ETF	259.1	260.0	257.86	258.77	4559690.0
2020-07-17 10:00:00	QQQ	ETF	258.75	259.0	257.17	258.49	4322410.0
2020-07-17 11:00:00	QQQ	ETF	258.48	259.17	258.16	258.98	2637626.0
2020-07-17 12:00:00	QQQ	ETF	258.98	259.39	258.61	258.83	1886170.0
2020-07-17 13:00:00	QQQ	ETF	258.84	259.1899	258.38	258.76	2134914.0
2020-07-17 14:00:00	QQQ	ETF	258.77	260.14	258.77	259.85	2433439.0
2020-07-17 15:00:00	QQQ	ETF	259.84	260.31	259.18	259.38	4414472.0
2020-07-17 16:00:00	QQQ	ETF	259.37	259.71	259.1	259.25	939635.0
2020-07-17 17:00:00	QQQ	ETF	259.21	259.36	259.1	259.32	28506.0
2020-07-17 18:00:00	QQQ	ETF	259.27	259.42	259.2	259.35	21794.0
2020-07-17 19:00:00	QQQ	ETF	259.22	259.5	259.22	259.41	9159.0
2020-07-17 04:00:00	IWM	ETF	145.55	145.86	145.47	145.82	7946.0
2020-07-17 05:00:00	IWM	ETF	145.74	146.05	145.56	145.74	8723.0
2020-07-17 06:00:00	IWM	ETF	145.71	146.11	145.71	146.01	14100.0
2020-07-17 07:00:00	IWM	ETF	146.07	146.23	145.97	146.23	31510.0
2020-07-17 08:00:00	IWM	ETF	146.1201	146.98	145.62	146.46	91732.0
2020-07-17 09:00:00	IWM	ETF	146.44	147.18	145.905	146.54	2049394.0
2020-07-17 10:00:00	IWM	ETF	146.53	146.8	145.51	146.75	3002208.0
2020-07-17 11:00:00	IWM	ETF	146.73	147.27	146.69	147.24	2120788.0
2020-07-17 12:00:00	IWM	ETF	147.25	147.59	146.69	146.755	1942393.0
2020-07-17 13:00:00	IWM	ETF	146.75	147.07	146.49	146.7	1671853.0
2020-07-17 14:00:00	IWM	ETF	146.705	146.97	146.35	146.56	1743062.0
2020-07-17 15:00:00	IWM	ETF	146.55	146.92	146.28	146.57	3387464.0
2020-07-17 16:00:00	IWM	ETF	146.57	146.72	145.7375	146.4	813773.0
2020-07-17 17:00:00	IWM	ETF	146.34	146.5	146.34	146.41	900.0
2020-07-17 18:00:00	IWM	ETF	146.55	146.71	146.55	146.65	1199.0
2020-07-17 19:00:00	IWM	ETF	146.6	146.71	146.54	146.54	7398.0
2020-07-17 04:00:00	DIA	ETF	266.4	266.78	266.4	266.78	300.0
2020-07-17 05:00:00	DIA	ETF	266.99	267.15	266.99	267.08	700.0

> showing 50 of 12,149 rows — these rows as CSV

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