PREVIEW / etf_1hour / 2023-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-12.parquet
  size:    451 KB
  rows:    16,477

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
2023-05-12 04:00:00	SPY	ETF	413.21	414.0	413.04	414.0	34417.0
2023-05-12 05:00:00	SPY	ETF	414.1	414.27	413.71	413.71	48413.0
2023-05-12 06:00:00	SPY	ETF	413.8	414.04	413.54	413.84	44485.0
2023-05-12 07:00:00	SPY	ETF	413.83	413.98	413.4	413.53	100457.0
2023-05-12 08:00:00	SPY	ETF	413.85	413.96	412.91	413.44	400004.0
2023-05-12 09:00:00	SPY	ETF	413.43	413.64	412.52	412.73	5055751.0
2023-05-12 10:00:00	SPY	ETF	412.73	412.95	411.22	411.5057	8495864.0
2023-05-12 11:00:00	SPY	ETF	411.53	412.015	410.67	411.47	5703350.0
2023-05-12 12:00:00	SPY	ETF	411.48	411.58	409.45	409.57	5880205.0
2023-05-12 13:00:00	SPY	ETF	409.57	410.715	409.19	409.3101	5826803.0
2023-05-12 14:00:00	SPY	ETF	409.32	410.01	409.07	409.9	5989628.0
2023-05-12 15:00:00	SPY	ETF	409.91	411.67	409.65	411.61	12224900.0
2023-05-12 16:00:00	SPY	ETF	411.62	411.64	411.04	411.09	4558881.0
2023-05-12 17:00:00	SPY	ETF	411.1	411.22	410.8	410.8	91242.0
2023-05-12 18:00:00	SPY	ETF	410.88	410.94	410.81	410.94	15824.0
2023-05-12 19:00:00	SPY	ETF	410.94	410.97	410.73	410.77	16343.0
2023-05-12 04:00:00	QQQ	ETF	326.73	327.15	326.59	326.98	27791.0
2023-05-12 05:00:00	QQQ	ETF	327.13	327.3	326.87	326.87	12020.0
2023-05-12 06:00:00	QQQ	ETF	326.91	327.06	326.8	326.94	24086.0
2023-05-12 07:00:00	QQQ	ETF	326.93	327.08	326.581	326.66	185361.0
2023-05-12 08:00:00	QQQ	ETF	326.87	327.16	326.4	326.62	287557.0
2023-05-12 09:00:00	QQQ	ETF	326.63	327.17	326.03	326.15	3773789.0
2023-05-12 10:00:00	QQQ	ETF	326.15	326.4291	324.65	325.04	5495789.0
2023-05-12 11:00:00	QQQ	ETF	325.05	325.71	324.3	325.21	3842762.0
2023-05-12 12:00:00	QQQ	ETF	325.2	325.25	323.13	323.345	4345847.0
2023-05-12 13:00:00	QQQ	ETF	323.34	324.4	323.04	323.175	4237784.0
2023-05-12 14:00:00	QQQ	ETF	323.175	323.82	322.94	323.72	3770487.0
2023-05-12 15:00:00	QQQ	ETF	323.73	325.135	323.585	325.03	5970430.0
2023-05-12 16:00:00	QQQ	ETF	325.05	325.05	324.41	324.41	5309353.0
2023-05-12 17:00:00	QQQ	ETF	324.39	324.5	324.34	324.37	44793.0
2023-05-12 18:00:00	QQQ	ETF	324.41	324.49	324.3225	324.4001	19306.0
2023-05-12 19:00:00	QQQ	ETF	324.4	324.5	324.3	324.3	15806.0
2023-05-12 04:00:00	IWM	ETF	173.74	174.2	173.65	174.18	12377.0
2023-05-12 05:00:00	IWM	ETF	174.36	174.4	174.0	174.0	4504.0
2023-05-12 06:00:00	IWM	ETF	174.03	174.26	173.88	174.17	8286.0
2023-05-12 07:00:00	IWM	ETF	174.11	174.2	173.79	173.84	52330.0
2023-05-12 08:00:00	IWM	ETF	173.8	174.13	173.66	173.72	54192.0
2023-05-12 09:00:00	IWM	ETF	173.59	174.205	173.47	173.74	1843990.0
2023-05-12 10:00:00	IWM	ETF	173.66	173.68	172.26	172.65	2646021.0
2023-05-12 11:00:00	IWM	ETF	172.66	173.005	172.25	172.67	1462482.0
2023-05-12 12:00:00	IWM	ETF	172.68	172.74	171.65	171.79	1817470.0
2023-05-12 13:00:00	IWM	ETF	171.78	172.38	171.67	171.73	1637808.0
2023-05-12 14:00:00	IWM	ETF	171.72	172.125	171.66	172.02	1953251.0
2023-05-12 15:00:00	IWM	ETF	172.02	172.78	171.89	172.72	3784893.0
2023-05-12 16:00:00	IWM	ETF	172.72	172.73	172.44	172.48	653904.0
2023-05-12 17:00:00	IWM	ETF	172.49	172.62	172.3101	172.45	7565.0
2023-05-12 18:00:00	IWM	ETF	172.45	172.54	172.45	172.54	2131.0
2023-05-12 19:00:00	IWM	ETF	172.54	172.59	172.4	172.4	4549.0
2023-05-12 05:00:00	DIA	ETF	335.07	335.07	335.07	335.07	300.0
2023-05-12 06:00:00	DIA	ETF	334.82	334.89	334.82	334.89	1700.0

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

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