PREVIEW / etf_1hour / 2023-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-03.parquet
  size:    482 KB
  rows:    17,711

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-04-03 04:00:00	SPY	ETF	409.0	409.32	408.36	408.67	78906.0
2023-04-03 05:00:00	SPY	ETF	408.72	409.0	408.72	408.84	19592.0
2023-04-03 06:00:00	SPY	ETF	408.98	409.35	408.95	409.24	69218.0
2023-04-03 07:00:00	SPY	ETF	409.24	409.36	408.76	409.01	194429.0
2023-04-03 08:00:00	SPY	ETF	409.05	409.3296	408.1	409.0	325825.0
2023-04-03 09:00:00	SPY	ETF	409.0	410.7	408.78	410.11	6482357.0
2023-04-03 10:00:00	SPY	ETF	410.15	411.37	408.96	408.995	9591919.0
2023-04-03 11:00:00	SPY	ETF	409.0	409.5	408.44	409.49	6941765.0
2023-04-03 12:00:00	SPY	ETF	409.49	409.89	409.22	409.28	4420804.0
2023-04-03 13:00:00	SPY	ETF	409.285	409.77	408.9	409.2214	4956624.0
2023-04-03 14:00:00	SPY	ETF	409.23	410.46	409.1	410.375	5547985.0
2023-04-03 15:00:00	SPY	ETF	410.38	411.19	410.306	410.93	11613096.0
2023-04-03 16:00:00	SPY	ETF	410.92	411.09	410.79	410.9	2885772.0
2023-04-03 17:00:00	SPY	ETF	410.9	410.95	410.67	410.75	352368.0
2023-04-03 18:00:00	SPY	ETF	410.75	410.76	410.4	410.47	184830.0
2023-04-03 19:00:00	SPY	ETF	410.46	410.7	410.46	410.58	93392.0
2023-04-03 04:00:00	QQQ	ETF	319.92	319.92	318.6	318.77	99846.0
2023-04-03 05:00:00	QQQ	ETF	318.81	319.05	318.72	318.92	39396.0
2023-04-03 06:00:00	QQQ	ETF	318.96	319.27	318.96	319.02	172399.0
2023-04-03 07:00:00	QQQ	ETF	319.05	319.23	318.62	318.81	343454.0
2023-04-03 08:00:00	QQQ	ETF	318.99	321.17	318.08	318.84	593993.0
2023-04-03 09:00:00	QQQ	ETF	318.83	320.01	318.49	319.15	5801117.0
2023-04-03 10:00:00	QQQ	ETF	319.16	320.17	318.0	318.025	7100483.0
2023-04-03 11:00:00	QQQ	ETF	318.04	318.415	317.4201	318.22	4247226.0
2023-04-03 12:00:00	QQQ	ETF	318.23	318.765	317.85	317.88	2794337.0
2023-04-03 13:00:00	QQQ	ETF	317.87	318.13	317.525	317.93	3025942.0
2023-04-03 14:00:00	QQQ	ETF	317.94	319.19	317.56	319.14	3224944.0
2023-04-03 15:00:00	QQQ	ETF	319.15	320.42	319.06	320.16	7425971.0
2023-04-03 16:00:00	QQQ	ETF	320.17	320.2	319.86	320.04	1077443.0
2023-04-03 17:00:00	QQQ	ETF	320.03	320.06	319.79	319.86	48036.0
2023-04-03 18:00:00	QQQ	ETF	319.91	319.98	319.64	319.64	41305.0
2023-04-03 19:00:00	QQQ	ETF	319.68	319.85	319.64	319.65	46224.0
2023-04-03 04:00:00	IWM	ETF	178.28	178.29	177.75	178.05	51677.0
2023-04-03 05:00:00	IWM	ETF	178.0	178.26	177.98	178.03	17776.0
2023-04-03 06:00:00	IWM	ETF	178.25	178.29	178.12	178.28	55219.0
2023-04-03 07:00:00	IWM	ETF	178.29	178.4	178.09	178.38	160398.0
2023-04-03 08:00:00	IWM	ETF	178.3	178.9	178.01	178.88	135667.0
2023-04-03 09:00:00	IWM	ETF	178.91	179.57	178.87	179.16	2483362.0
2023-04-03 10:00:00	IWM	ETF	179.18	179.78	177.14	177.2	4021971.0
2023-04-03 11:00:00	IWM	ETF	177.21	177.77	176.49	177.74	2899125.0
2023-04-03 12:00:00	IWM	ETF	177.75	177.89	177.375	177.58	1796707.0
2023-04-03 13:00:00	IWM	ETF	177.59	177.92	177.24	177.495	1202151.0
2023-04-03 14:00:00	IWM	ETF	177.5	177.94	177.25	177.81	1565500.0
2023-04-03 15:00:00	IWM	ETF	177.81	178.65	177.7999	178.49	4349523.0
2023-04-03 16:00:00	IWM	ETF	178.48	178.63	178.38	178.46	1395585.0
2023-04-03 17:00:00	IWM	ETF	178.35	178.54	178.35	178.47	8847.0
2023-04-03 18:00:00	IWM	ETF	178.44	178.44	178.23	178.3	23103.0
2023-04-03 19:00:00	IWM	ETF	178.25	178.39	178.24	178.24	28269.0
2023-04-03 04:00:00	DIA	ETF	333.77	333.83	333.5	333.6	3799.0
2023-04-03 05:00:00	DIA	ETF	333.77	333.81	333.76	333.76	2123.0

> showing 50 of 17,711 rows — these rows as CSV

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