PREVIEW / etf_1hour / 2022-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-24.parquet
  size:    453 KB
  rows:    16,473

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
2022-05-24 04:00:00	SPY	ETF	392.38	392.38	390.81	390.91	56282.0
2022-05-24 05:00:00	SPY	ETF	391.03	392.4	390.99	392.22	37719.0
2022-05-24 06:00:00	SPY	ETF	392.2	392.95	391.98	392.45	62748.0
2022-05-24 07:00:00	SPY	ETF	392.48	393.55	392.4	392.58	279657.0
2022-05-24 08:00:00	SPY	ETF	392.85	393.95	391.08	393.08	723898.0
2022-05-24 09:00:00	SPY	ETF	393.08	393.6	390.66	390.77	6777489.0
2022-05-24 10:00:00	SPY	ETF	390.8	390.92	386.96	388.1	11398266.0
2022-05-24 11:00:00	SPY	ETF	388.11	391.08	387.34	390.265	8483626.0
2022-05-24 12:00:00	SPY	ETF	390.25	392.63	389.17	390.2299	7721013.0
2022-05-24 13:00:00	SPY	ETF	390.22	392.01	388.76	391.4701	6103217.0
2022-05-24 14:00:00	SPY	ETF	391.53	393.29	390.03	390.85	8057698.0
2022-05-24 15:00:00	SPY	ETF	390.82	395.15	390.67	394.0	17372450.0
2022-05-24 16:00:00	SPY	ETF	393.99	394.8796	393.6526	394.745	3750722.0
2022-05-24 17:00:00	SPY	ETF	394.72	394.86	394.61	394.79	56583.0
2022-05-24 18:00:00	SPY	ETF	394.79	395.9	394.79	395.62	99912.0
2022-05-24 19:00:00	SPY	ETF	395.62	396.05	395.39	395.57	71014.0
2022-05-24 04:00:00	QQQ	ETF	287.69	288.36	287.08	287.38	137866.0
2022-05-24 05:00:00	QQQ	ETF	287.31	288.52	287.31	288.39	176941.0
2022-05-24 06:00:00	QQQ	ETF	288.34	288.8	288.08	288.37	101780.0
2022-05-24 07:00:00	QQQ	ETF	288.5	289.49	288.3	288.5	350973.0
2022-05-24 08:00:00	QQQ	ETF	288.4701	293.7	287.4	288.62	601689.0
2022-05-24 09:00:00	QQQ	ETF	288.72	288.9	284.67	284.75	7321967.0
2022-05-24 10:00:00	QQQ	ETF	284.76	284.78	282.25	283.5	10644063.0
2022-05-24 11:00:00	QQQ	ETF	283.507	286.18	283.15	285.46	6733377.0
2022-05-24 12:00:00	QQQ	ETF	285.46	287.89	284.43	285.2852	6318601.0
2022-05-24 13:00:00	QQQ	ETF	285.26	286.8391	283.9	286.195	5172108.0
2022-05-24 14:00:00	QQQ	ETF	286.29	287.685	284.09	284.77	5968019.0
2022-05-24 15:00:00	QQQ	ETF	284.75	288.47	284.63	287.25	11457865.0
2022-05-24 16:00:00	QQQ	ETF	287.26	288.14	287.12	287.98	3518522.0
2022-05-24 17:00:00	QQQ	ETF	287.95	288.21	287.68	288.0	65473.0
2022-05-24 18:00:00	QQQ	ETF	287.94	289.02	287.94	288.8601	198785.0
2022-05-24 19:00:00	QQQ	ETF	288.88	289.36	288.78	289.06	218852.0
2022-05-24 04:00:00	IWM	ETF	176.41	176.58	175.88	176.02	30396.0
2022-05-24 05:00:00	IWM	ETF	176.09	176.62	175.96	176.55	19513.0
2022-05-24 06:00:00	IWM	ETF	176.4	176.8	176.34	176.65	63527.0
2022-05-24 07:00:00	IWM	ETF	176.78	177.18	176.63	176.73	25806.0
2022-05-24 08:00:00	IWM	ETF	176.76	177.09	176.47	176.87	66063.0
2022-05-24 09:00:00	IWM	ETF	176.88	176.98	174.45	174.54	2787648.0
2022-05-24 10:00:00	IWM	ETF	174.54	174.64	172.58	173.14	3770382.0
2022-05-24 11:00:00	IWM	ETF	173.13	174.33	172.33	173.8	2435738.0
2022-05-24 12:00:00	IWM	ETF	173.79	175.15	173.44	174.0199	2297872.0
2022-05-24 13:00:00	IWM	ETF	173.98	174.62	173.23	174.38	1562006.0
2022-05-24 14:00:00	IWM	ETF	174.39	175.35	173.74	174.1	2022048.0
2022-05-24 15:00:00	IWM	ETF	174.09	176.03	174.02	175.5599	5452050.0
2022-05-24 16:00:00	IWM	ETF	175.57	175.97	175.34	175.97	1283127.0
2022-05-24 17:00:00	IWM	ETF	176.06	176.2	175.73	176.04	27871.0
2022-05-24 18:00:00	IWM	ETF	175.93	176.44	175.93	176.22	33903.0
2022-05-24 19:00:00	IWM	ETF	176.25	176.52	176.08	176.08	18713.0
2022-05-24 04:00:00	DIA	ETF	316.01	316.2	315.38	315.4	3600.0
2022-05-24 05:00:00	DIA	ETF	315.6	316.43	315.55	316.43	2600.0

> showing 50 of 16,473 rows — these rows as CSV

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