PREVIEW / etf_1hour / 2021-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-14.parquet
  size:    414 KB
  rows:    14,494

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
2021-06-14 04:00:00	SPY	ETF	424.65	424.75	424.48	424.75	3186.0
2021-06-14 05:00:00	SPY	ETF	424.72	424.79	424.5	424.79	22840.0
2021-06-14 06:00:00	SPY	ETF	424.79	424.81	424.59	424.74	28279.0
2021-06-14 07:00:00	SPY	ETF	424.61	424.83	424.26	424.34	46605.0
2021-06-14 08:00:00	SPY	ETF	424.7999	424.88	424.0	424.26	227135.0
2021-06-14 09:00:00	SPY	ETF	424.24	424.45	423.6899	423.925	3061214.0
2021-06-14 10:00:00	SPY	ETF	423.93	424.01	423.23	423.74	4282402.0
2021-06-14 11:00:00	SPY	ETF	423.74	423.99	423.22	423.4182	3077043.0
2021-06-14 12:00:00	SPY	ETF	423.4181	423.6	423.11	423.165	2530958.0
2021-06-14 13:00:00	SPY	ETF	423.17	423.52	423.1	423.325	2004545.0
2021-06-14 14:00:00	SPY	ETF	423.33	423.5993	423.16	423.54	2840921.0
2021-06-14 15:00:00	SPY	ETF	423.54	425.29	423.42	425.29	10065746.0
2021-06-14 16:00:00	SPY	ETF	425.28	425.47	425.09	425.23	4438599.0
2021-06-14 17:00:00	SPY	ETF	425.21	425.34	425.17	425.28	140892.0
2021-06-14 18:00:00	SPY	ETF	425.28	425.28	424.97	425.07	136922.0
2021-06-14 19:00:00	SPY	ETF	425.09	425.29	425.07	425.1	31674.0
2021-06-14 04:00:00	QQQ	ETF	341.48	342.05	341.3	342.05	20471.0
2021-06-14 05:00:00	QQQ	ETF	341.99	342.13	341.95	342.08	7333.0
2021-06-14 06:00:00	QQQ	ETF	342.1	342.44	342.0	342.34	42651.0
2021-06-14 07:00:00	QQQ	ETF	342.36	342.57	342.08	342.24	109843.0
2021-06-14 08:00:00	QQQ	ETF	342.3604	342.5499	341.62	341.78	155919.0
2021-06-14 09:00:00	QQQ	ETF	341.78	342.44	340.46	342.0488	3960960.0
2021-06-14 10:00:00	QQQ	ETF	342.08	342.14	341.06	341.83	3116965.0
2021-06-14 11:00:00	QQQ	ETF	341.87	342.4	341.7	342.32	2268608.0
2021-06-14 12:00:00	QQQ	ETF	342.33	342.83	342.235	342.5	2009307.0
2021-06-14 13:00:00	QQQ	ETF	342.5101	343.09	342.43	342.9682	1699876.0
2021-06-14 14:00:00	QQQ	ETF	342.97	343.11	342.7	342.89	1742535.0
2021-06-14 15:00:00	QQQ	ETF	342.88	344.5	342.62	344.49	5208458.0
2021-06-14 16:00:00	QQQ	ETF	344.47	344.53	343.9	344.15	909407.0
2021-06-14 17:00:00	QQQ	ETF	344.15	344.2	343.97	344.12	52685.0
2021-06-14 18:00:00	QQQ	ETF	344.18	344.28	344.0	344.16	54768.0
2021-06-14 19:00:00	QQQ	ETF	344.17	344.29	344.07	344.1	53476.0
2021-06-14 04:00:00	IWM	ETF	232.07	232.07	231.57	231.71	6355.0
2021-06-14 05:00:00	IWM	ETF	231.71	231.71	231.56	231.69	6808.0
2021-06-14 06:00:00	IWM	ETF	231.85	231.91	231.8	231.81	4348.0
2021-06-14 07:00:00	IWM	ETF	231.73	231.86	231.32	231.49	12348.0
2021-06-14 08:00:00	IWM	ETF	231.84	233.12	231.47	232.06	49319.0
2021-06-14 09:00:00	IWM	ETF	231.99	233.35	231.74	232.22	2606105.0
2021-06-14 10:00:00	IWM	ETF	232.23	232.345	230.89	231.66	2378637.0
2021-06-14 11:00:00	IWM	ETF	231.66	231.875	230.905	231.3894	1246731.0
2021-06-14 12:00:00	IWM	ETF	231.38	231.71	231.145	231.2	1249524.0
2021-06-14 13:00:00	IWM	ETF	231.2	231.28	230.55	230.65	1293478.0
2021-06-14 14:00:00	IWM	ETF	230.66	230.86	230.23	230.5499	1853891.0
2021-06-14 15:00:00	IWM	ETF	230.54	231.06	230.14	231.03	3158189.0
2021-06-14 16:00:00	IWM	ETF	231.02	231.07	230.77	230.92	2389503.0
2021-06-14 17:00:00	IWM	ETF	231.1	231.1	230.76	230.88	265568.0
2021-06-14 18:00:00	IWM	ETF	230.88	230.99	230.83	230.9	17124.0
2021-06-14 19:00:00	IWM	ETF	231.01	231.09	230.91	230.91	19872.0
2021-06-14 04:00:00	DIA	ETF	345.22	345.22	345.15	345.15	2100.0
2021-06-14 05:00:00	DIA	ETF	345.17	345.17	345.17	345.17	600.0

> showing 50 of 14,494 rows — these rows as CSV

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