PREVIEW / etf_1hour / 2023-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-31.parquet
  size:    477 KB
  rows:    17,247

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-03-31 04:00:00	SPY	ETF	403.81	404.06	403.53	403.81	14074.0
2023-03-31 05:00:00	SPY	ETF	403.87	404.53	403.82	404.32	12318.0
2023-03-31 06:00:00	SPY	ETF	404.27	404.45	404.13	404.36	18146.0
2023-03-31 07:00:00	SPY	ETF	404.39	404.69	404.27	404.27	106963.0
2023-03-31 08:00:00	SPY	ETF	404.38	405.45	403.6796	404.77	879103.0
2023-03-31 09:00:00	SPY	ETF	404.79	405.77	404.55	405.46	8048554.0
2023-03-31 10:00:00	SPY	ETF	405.49	406.31	405.36	406.19	9737198.0
2023-03-31 11:00:00	SPY	ETF	406.19	407.16	406.0375	407.13	6796499.0
2023-03-31 12:00:00	SPY	ETF	407.12	407.69	407.05	407.2294	5880022.0
2023-03-31 13:00:00	SPY	ETF	407.23	407.36	406.68	407.13	5752273.0
2023-03-31 14:00:00	SPY	ETF	407.14	407.71	406.94	407.54	6891971.0
2023-03-31 15:00:00	SPY	ETF	407.53	409.7	407.5299	409.36	26276873.0
2023-03-31 16:00:00	SPY	ETF	409.37	409.75	409.18	409.52	6936629.0
2023-03-31 17:00:00	SPY	ETF	409.52	409.69	409.5	409.52	80601.0
2023-03-31 18:00:00	SPY	ETF	409.52	409.69	409.46	409.69	61503.0
2023-03-31 19:00:00	SPY	ETF	409.62	409.85	409.58	409.76	31736.0
2023-03-31 04:00:00	QQQ	ETF	315.97	316.01	315.53	315.65	25993.0
2023-03-31 05:00:00	QQQ	ETF	315.7	316.0	315.57	315.63	22764.0
2023-03-31 06:00:00	QQQ	ETF	315.54	315.58	315.38	315.47	8240.0
2023-03-31 07:00:00	QQQ	ETF	315.6	315.86	315.5	315.53	105809.0
2023-03-31 08:00:00	QQQ	ETF	315.51	316.78	315.1	316.03	1112465.0
2023-03-31 09:00:00	QQQ	ETF	316.0401	317.67	315.6	317.11	5266378.0
2023-03-31 10:00:00	QQQ	ETF	317.11	318.2499	316.81	317.9	6892601.0
2023-03-31 11:00:00	QQQ	ETF	317.91	318.8	317.69	318.7696	3859938.0
2023-03-31 12:00:00	QQQ	ETF	318.77	319.416	318.63	319.12	4353129.0
2023-03-31 13:00:00	QQQ	ETF	319.125	319.32	318.68	319.155	3585538.0
2023-03-31 14:00:00	QQQ	ETF	319.16	319.715	319.04	319.61	4029763.0
2023-03-31 15:00:00	QQQ	ETF	319.61	321.17	319.58	320.89	13606619.0
2023-03-31 16:00:00	QQQ	ETF	320.89	321.11	320.7	321.0713	2595886.0
2023-03-31 17:00:00	QQQ	ETF	321.11	321.25	320.89	321.0	329358.0
2023-03-31 18:00:00	QQQ	ETF	321.0	321.29	321.0	321.29	63103.0
2023-03-31 19:00:00	QQQ	ETF	321.25	321.44	321.21	321.35	24608.0
2023-03-31 04:00:00	IWM	ETF	175.0	175.44	174.92	175.4	6741.0
2023-03-31 05:00:00	IWM	ETF	175.23	175.71	175.23	175.69	5192.0
2023-03-31 06:00:00	IWM	ETF	175.74	175.77	175.68	175.75	12371.0
2023-03-31 07:00:00	IWM	ETF	175.75	175.91	175.72	175.73	62127.0
2023-03-31 08:00:00	IWM	ETF	175.73	176.46	175.6196	175.82	131460.0
2023-03-31 09:00:00	IWM	ETF	175.89	177.535	175.89	176.75	3137135.0
2023-03-31 10:00:00	IWM	ETF	176.75	177.89	176.73	177.87	2423703.0
2023-03-31 11:00:00	IWM	ETF	177.88	178.64	177.83	178.16	2442971.0
2023-03-31 12:00:00	IWM	ETF	178.15	178.46	177.685	177.98	3570060.0
2023-03-31 13:00:00	IWM	ETF	177.9812	178.01	177.37	177.62	1404736.0
2023-03-31 14:00:00	IWM	ETF	177.63	177.97	177.34	177.43	2212089.0
2023-03-31 15:00:00	IWM	ETF	177.45	178.56	177.38	178.41	8122065.0
2023-03-31 16:00:00	IWM	ETF	178.4	178.78	178.32	178.72	4643655.0
2023-03-31 17:00:00	IWM	ETF	178.72	178.99	178.72	178.95	293470.0
2023-03-31 18:00:00	IWM	ETF	178.97	179.12	178.9	179.04	61873.0
2023-03-31 19:00:00	IWM	ETF	178.97	179.06	178.92	179.06	18052.0
2023-03-31 04:00:00	DIA	ETF	328.31	328.71	328.26	328.71	380.0
2023-03-31 05:00:00	DIA	ETF	328.98	329.21	328.98	329.01	1400.0

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

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