PREVIEW / etf_1hour / 2021-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-15.parquet
  size:    403 KB
  rows:    14,116

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-15 04:00:00	SPY	ETF	425.97	425.99	425.66	425.9	15321.0
2021-06-15 05:00:00	SPY	ETF	425.83	425.86	425.48	425.48	17764.0
2021-06-15 06:00:00	SPY	ETF	425.43	425.59	425.27	425.58	68706.0
2021-06-15 07:00:00	SPY	ETF	425.68	425.84	425.56	425.72	52647.0
2021-06-15 08:00:00	SPY	ETF	425.68	425.84	425.2117	425.36	147453.0
2021-06-15 09:00:00	SPY	ETF	425.36	425.5899	424.56	424.695	3477081.0
2021-06-15 10:00:00	SPY	ETF	424.7	424.79	424.01	424.0501	4520010.0
2021-06-15 11:00:00	SPY	ETF	424.04	424.35	423.54	423.93	3697476.0
2021-06-15 12:00:00	SPY	ETF	423.93	424.49	423.92	424.22	2712583.0
2021-06-15 13:00:00	SPY	ETF	424.23	424.74	423.9301	424.65	2700048.0
2021-06-15 14:00:00	SPY	ETF	424.645	425.01	424.42	424.76	3761324.0
2021-06-15 15:00:00	SPY	ETF	424.76	424.98	424.03	424.5	11795763.0
2021-06-15 16:00:00	SPY	ETF	424.5	424.8476	424.35	424.51	3940122.0
2021-06-15 17:00:00	SPY	ETF	424.42	424.57	424.38	424.48	31796.0
2021-06-15 18:00:00	SPY	ETF	424.53	424.71	424.45	424.46	32862.0
2021-06-15 19:00:00	SPY	ETF	424.41	424.55	424.28	424.44	33472.0
2021-06-15 04:00:00	QQQ	ETF	344.9	345.01	344.76	344.9	38749.0
2021-06-15 05:00:00	QQQ	ETF	344.85	344.89	344.61	344.65	23548.0
2021-06-15 06:00:00	QQQ	ETF	344.53	344.9	344.45	344.9	13059.0
2021-06-15 07:00:00	QQQ	ETF	344.9	345.0	344.7	344.88	186898.0
2021-06-15 08:00:00	QQQ	ETF	344.85	345.04	344.17	344.2699	294318.0
2021-06-15 09:00:00	QQQ	ETF	344.239	344.47	343.03	343.88	4413775.0
2021-06-15 10:00:00	QQQ	ETF	343.89	344.03	342.73	342.95	4634193.0
2021-06-15 11:00:00	QQQ	ETF	342.94	343.35	342.19	342.87	2777426.0
2021-06-15 12:00:00	QQQ	ETF	342.88	343.09	342.27	342.435	2191879.0
2021-06-15 13:00:00	QQQ	ETF	342.47	342.58	342.07	342.5	2118032.0
2021-06-15 14:00:00	QQQ	ETF	342.5	342.68	341.74	342.09	2471534.0
2021-06-15 15:00:00	QQQ	ETF	342.09	342.63	341.52	342.19	7595461.0
2021-06-15 16:00:00	QQQ	ETF	342.24	342.52	342.03	342.43	848089.0
2021-06-15 17:00:00	QQQ	ETF	342.4	342.43	342.26	342.4	44031.0
2021-06-15 18:00:00	QQQ	ETF	342.4	342.53	342.3	342.35	46408.0
2021-06-15 19:00:00	QQQ	ETF	342.33	342.42	342.17	342.26	63440.0
2021-06-15 04:00:00	IWM	ETF	231.08	231.23	230.97	231.23	4725.0
2021-06-15 05:00:00	IWM	ETF	231.07	231.08	231.03	231.03	5000.0
2021-06-15 06:00:00	IWM	ETF	230.97	230.97	230.97	230.97	600.0
2021-06-15 07:00:00	IWM	ETF	230.97	231.42	230.97	231.39	22273.0
2021-06-15 08:00:00	IWM	ETF	231.1	231.37	230.98	231.26	36961.0
2021-06-15 09:00:00	IWM	ETF	231.26	231.47	230.405	230.74	1953844.0
2021-06-15 10:00:00	IWM	ETF	230.74	231.06	229.03	229.61	2540506.0
2021-06-15 11:00:00	IWM	ETF	229.62	229.73	228.475	228.8	1361799.0
2021-06-15 12:00:00	IWM	ETF	228.79	229.87	228.785	229.83	1357238.0
2021-06-15 13:00:00	IWM	ETF	229.84	230.57	229.7	230.46	1107670.0
2021-06-15 14:00:00	IWM	ETF	230.46	230.82	229.525	230.54	1055741.0
2021-06-15 15:00:00	IWM	ETF	230.54	230.62	229.705	230.4	2455656.0
2021-06-15 16:00:00	IWM	ETF	230.36	230.55	230.31	230.31	1896834.0
2021-06-15 17:00:00	IWM	ETF	230.35	230.36	230.35	230.36	20268.0
2021-06-15 18:00:00	IWM	ETF	230.46	230.52	230.33	230.33	24700.0
2021-06-15 19:00:00	IWM	ETF	230.36	230.4	230.26	230.29	30900.0
2021-06-15 04:00:00	DIA	ETF	344.62	344.65	344.38	344.38	2000.0
2021-06-15 05:00:00	DIA	ETF	344.43	344.43	344.43	344.43	388.0

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

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