PREVIEW / etf_1hour / 2021-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-09.parquet
  size:    417 KB
  rows:    14,433

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-08-09 04:00:00	SPY	ETF	441.67	441.89	441.4	441.88	23135.0
2021-08-09 05:00:00	SPY	ETF	441.8	441.88	441.64	441.85	11640.0
2021-08-09 06:00:00	SPY	ETF	442.06	442.09	441.68	441.77	24433.0
2021-08-09 07:00:00	SPY	ETF	441.72	442.01	441.61	441.93	190855.0
2021-08-09 08:00:00	SPY	ETF	441.93	442.1699	441.63	442.09	183161.0
2021-08-09 09:00:00	SPY	ETF	442.1	442.795	441.31	441.75	5010855.0
2021-08-09 10:00:00	SPY	ETF	441.75	442.28	441.4532	441.83	5016073.0
2021-08-09 11:00:00	SPY	ETF	441.83	442.36	441.72	442.35	2875960.0
2021-08-09 12:00:00	SPY	ETF	442.349	442.36	442.03	442.18	2021406.0
2021-08-09 13:00:00	SPY	ETF	442.18	442.33	442.063	442.24	1838217.0
2021-08-09 14:00:00	SPY	ETF	442.2469	442.77	442.24	442.49	2397947.0
2021-08-09 15:00:00	SPY	ETF	442.48	442.65	441.98	442.14	5489265.0
2021-08-09 16:00:00	SPY	ETF	442.15	442.49	442.13	442.34	1874577.0
2021-08-09 17:00:00	SPY	ETF	442.39	442.7	442.31	442.39	175930.0
2021-08-09 18:00:00	SPY	ETF	442.37	442.43	442.11	442.13	60397.0
2021-08-09 19:00:00	SPY	ETF	442.13	442.15	441.84	442.1	274833.0
2021-08-09 04:00:00	QQQ	ETF	367.71	368.27	367.61	368.16	33304.0
2021-08-09 05:00:00	QQQ	ETF	368.2	368.29	368.05	368.16	27385.0
2021-08-09 06:00:00	QQQ	ETF	368.22	368.56	368.22	368.44	62269.0
2021-08-09 07:00:00	QQQ	ETF	368.42	368.77	368.25	368.52	189125.0
2021-08-09 08:00:00	QQQ	ETF	368.6401	368.74	366.93	368.34	109425.0
2021-08-09 09:00:00	QQQ	ETF	368.34	369.0801	367.39	368.4	2819071.0
2021-08-09 10:00:00	QQQ	ETF	368.4	369.09	367.8376	368.36	3202280.0
2021-08-09 11:00:00	QQQ	ETF	368.36	368.7199	367.92	368.655	2407314.0
2021-08-09 12:00:00	QQQ	ETF	368.65	368.815	368.25	368.53	1569789.0
2021-08-09 13:00:00	QQQ	ETF	368.52	368.745	368.31	368.71	1027112.0
2021-08-09 14:00:00	QQQ	ETF	368.7	369.27	368.65	368.94	1255459.0
2021-08-09 15:00:00	QQQ	ETF	368.93	369.0461	368.41	368.7	2841255.0
2021-08-09 16:00:00	QQQ	ETF	368.71	368.97	368.61	368.79	3336022.0
2021-08-09 17:00:00	QQQ	ETF	368.65	368.86	368.65	368.7	19012.0
2021-08-09 18:00:00	QQQ	ETF	368.79	368.86	368.4	368.64	59758.0
2021-08-09 19:00:00	QQQ	ETF	368.62	368.66	368.53	368.62	15786.0
2021-08-09 04:00:00	IWM	ETF	222.1	222.11	221.66	222.08	14395.0
2021-08-09 05:00:00	IWM	ETF	222.0	222.03	221.91	222.03	6100.0
2021-08-09 06:00:00	IWM	ETF	222.18	222.39	222.01	222.02	34093.0
2021-08-09 07:00:00	IWM	ETF	222.02	222.58	222.0	222.43	109238.0
2021-08-09 08:00:00	IWM	ETF	222.2199	223.11	222.0796	223.11	58133.0
2021-08-09 09:00:00	IWM	ETF	223.15	223.23	221.21	222.275	3810865.0
2021-08-09 10:00:00	IWM	ETF	222.28	222.68	221.57	222.54	2918808.0
2021-08-09 11:00:00	IWM	ETF	222.55	223.18	222.36	223.15	1868455.0
2021-08-09 12:00:00	IWM	ETF	223.13	223.19	222.86	223.05	1207162.0
2021-08-09 13:00:00	IWM	ETF	223.04	223.14	222.71	223.14	1164869.0
2021-08-09 14:00:00	IWM	ETF	223.14	223.14	222.64	222.795	1353378.0
2021-08-09 15:00:00	IWM	ETF	222.795	222.88	222.0	222.15	2566144.0
2021-08-09 16:00:00	IWM	ETF	222.16	222.44	222.16	222.41	225387.0
2021-08-09 17:00:00	IWM	ETF	222.45	222.45	222.23	222.26	1066.0
2021-08-09 18:00:00	IWM	ETF	222.4	222.5	222.2	222.2	34311.0
2021-08-09 19:00:00	IWM	ETF	222.25	222.26	222.03	222.12	37898.0
2021-08-09 04:00:00	DIA	ETF	351.29	351.29	351.0	351.2	2112.0
2021-08-09 05:00:00	DIA	ETF	351.07	351.07	350.9	350.9	1001.0

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

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