PREVIEW / etf_1hour / 2021-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-04.parquet
  size:    434 KB
  rows:    15,422

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-10-04 04:00:00	SPY	ETF	432.99	432.99	431.49	432.68	66744.0
2021-10-04 05:00:00	SPY	ETF	432.59	433.12	432.36	432.63	83738.0
2021-10-04 06:00:00	SPY	ETF	432.72	433.04	432.13	432.77	52023.0
2021-10-04 07:00:00	SPY	ETF	432.78	432.88	431.84	432.29	230384.0
2021-10-04 08:00:00	SPY	ETF	432.25	434.565	431.28	433.37	390687.0
2021-10-04 09:00:00	SPY	ETF	433.36	433.96	432.16	432.68	7842757.0
2021-10-04 10:00:00	SPY	ETF	432.67	433.17	427.07	428.03	18662179.0
2021-10-04 11:00:00	SPY	ETF	428.02	428.82	426.36	428.4	15975946.0
2021-10-04 12:00:00	SPY	ETF	428.39	428.59	426.65	427.24	8986034.0
2021-10-04 13:00:00	SPY	ETF	427.23	428.25	426.5	427.335	8668464.0
2021-10-04 14:00:00	SPY	ETF	427.3424	428.58	427.23	428.22	10533601.0
2021-10-04 15:00:00	SPY	ETF	428.23	429.22	427.32	428.69	23115833.0
2021-10-04 16:00:00	SPY	ETF	428.69	429.13	428.5	428.89	6818993.0
2021-10-04 17:00:00	SPY	ETF	428.81	428.98	428.64	428.93	1940811.0
2021-10-04 18:00:00	SPY	ETF	428.96	429.45	428.64	429.36	165416.0
2021-10-04 19:00:00	SPY	ETF	429.41	429.46	428.6	428.79	64850.0
2021-10-04 04:00:00	QQQ	ETF	358.88	358.88	357.46	358.21	82197.0
2021-10-04 05:00:00	QQQ	ETF	358.31	358.8	358.17	358.25	22742.0
2021-10-04 06:00:00	QQQ	ETF	358.5	358.8	357.94	358.46	51927.0
2021-10-04 07:00:00	QQQ	ETF	358.45	358.61	357.61	358.07	334285.0
2021-10-04 08:00:00	QQQ	ETF	357.7801	360.45	357.04	358.97	219367.0
2021-10-04 09:00:00	QQQ	ETF	358.95	358.95	355.17	355.84	5947231.0
2021-10-04 10:00:00	QQQ	ETF	355.84	356.19	351.06	352.08	13596818.0
2021-10-04 11:00:00	QQQ	ETF	352.09	352.985	350.68	352.2	9494446.0
2021-10-04 12:00:00	QQQ	ETF	352.18	352.2901	350.44	351.015	5774612.0
2021-10-04 13:00:00	QQQ	ETF	351.01	351.98	350.32	351.1068	4993666.0
2021-10-04 14:00:00	QQQ	ETF	351.13	352.72	351.08	352.34	7261901.0
2021-10-04 15:00:00	QQQ	ETF	352.38	353.455	351.01	352.7	12388866.0
2021-10-04 16:00:00	QQQ	ETF	352.7	360.296	352.55	353.2	2179488.0
2021-10-04 17:00:00	QQQ	ETF	353.11	353.29	352.61	353.1	535280.0
2021-10-04 18:00:00	QQQ	ETF	353.12	353.75	353.01	353.62	155755.0
2021-10-04 19:00:00	QQQ	ETF	353.66	353.67	352.85	353.09	63530.0
2021-10-04 04:00:00	IWM	ETF	221.4	221.75	221.0	221.75	37448.0
2021-10-04 05:00:00	IWM	ETF	221.8	222.11	221.8	222.01	10299.0
2021-10-04 06:00:00	IWM	ETF	222.02	222.18	221.66	222.1	20187.0
2021-10-04 07:00:00	IWM	ETF	222.06	222.1	221.39	221.58	34045.0
2021-10-04 08:00:00	IWM	ETF	221.9001	222.58	221.08	222.3	162244.0
2021-10-04 09:00:00	IWM	ETF	222.3	222.38	221.1	222.1	2862159.0
2021-10-04 10:00:00	IWM	ETF	222.08	222.32	218.93	219.86	6207229.0
2021-10-04 11:00:00	IWM	ETF	219.86	220.27	219.04	220.0	3751144.0
2021-10-04 12:00:00	IWM	ETF	219.99	220.3399	219.43	219.87	1893336.0
2021-10-04 13:00:00	IWM	ETF	219.87	220.4	219.28	219.94	2158605.0
2021-10-04 14:00:00	IWM	ETF	219.94	220.54	219.71	220.076	2327114.0
2021-10-04 15:00:00	IWM	ETF	220.1	220.5	219.49	220.23	5235937.0
2021-10-04 16:00:00	IWM	ETF	220.26	220.48	219.95	220.36	1296063.0
2021-10-04 17:00:00	IWM	ETF	220.28	220.44	220.12	220.21	217005.0
2021-10-04 18:00:00	IWM	ETF	220.26	220.63	220.26	220.54	40594.0
2021-10-04 19:00:00	IWM	ETF	220.57	220.64	220.08	220.26	25514.0
2021-10-04 04:00:00	DIA	ETF	342.0	342.0	341.25	341.52	2325.0
2021-10-04 05:00:00	DIA	ETF	342.34	342.37	341.92	341.92	2000.0

> showing 50 of 15,422 rows — these rows as CSV

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