PREVIEW / etf_1hour / 2023-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-02.parquet
  size:    469 KB
  rows:    17,256

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-02 04:00:00	SPY	ETF	415.16	415.28	414.96	415.05	23615.0
2023-05-02 05:00:00	SPY	ETF	415.06	415.4	414.89	415.2	87512.0
2023-05-02 06:00:00	SPY	ETF	415.08	415.19	414.7	415.13	113341.0
2023-05-02 07:00:00	SPY	ETF	415.13	415.37	414.91	415.06	118067.0
2023-05-02 08:00:00	SPY	ETF	415.1	416.1	414.57	414.76	312122.0
2023-05-02 09:00:00	SPY	ETF	414.72	414.88	413.65	413.8401	5421384.0
2023-05-02 10:00:00	SPY	ETF	413.89	414.11	408.975	409.0865	18822203.0
2023-05-02 11:00:00	SPY	ETF	409.07	409.425	407.82	408.71	14240170.0
2023-05-02 12:00:00	SPY	ETF	408.69	409.85	408.425	409.67	6513945.0
2023-05-02 13:00:00	SPY	ETF	409.66	411.29	409.48	410.82	7371369.0
2023-05-02 14:00:00	SPY	ETF	410.83	411.18	409.79	411.08	7840339.0
2023-05-02 15:00:00	SPY	ETF	411.08	411.58	410.46	410.87	16736647.0
2023-05-02 16:00:00	SPY	ETF	410.87	411.08	410.51	410.51	3721147.0
2023-05-02 17:00:00	SPY	ETF	410.64	410.64	410.38	410.4	74568.0
2023-05-02 18:00:00	SPY	ETF	410.5	410.69	410.47	410.56	40405.0
2023-05-02 19:00:00	SPY	ETF	410.51	411.0	410.49	411.0	159247.0
2023-05-02 04:00:00	QQQ	ETF	322.33	322.61	322.19	322.25	26731.0
2023-05-02 05:00:00	QQQ	ETF	322.14	322.7	322.13	322.5	17611.0
2023-05-02 06:00:00	QQQ	ETF	322.32	322.48	322.11	322.31	60800.0
2023-05-02 07:00:00	QQQ	ETF	322.33	322.54	322.04	322.13	133979.0
2023-05-02 08:00:00	QQQ	ETF	322.3	322.7296	321.7399	322.06	250799.0
2023-05-02 09:00:00	QQQ	ETF	322.07	322.45	321.3	321.84	4094182.0
2023-05-02 10:00:00	QQQ	ETF	321.87	322.17	318.21	318.35	10286117.0
2023-05-02 11:00:00	QQQ	ETF	318.33	318.81	317.61	317.92	8108585.0
2023-05-02 12:00:00	QQQ	ETF	317.91	319.23	317.7	319.09	3758151.0
2023-05-02 13:00:00	QQQ	ETF	319.09	320.2707	318.9399	319.85	3978152.0
2023-05-02 14:00:00	QQQ	ETF	319.86	319.93	318.9701	319.9	3517195.0
2023-05-02 15:00:00	QQQ	ETF	319.88	320.26	319.04	319.36	7028825.0
2023-05-02 16:00:00	QQQ	ETF	319.36	319.5739	318.9	318.98	1986160.0
2023-05-02 17:00:00	QQQ	ETF	318.96	319.03	318.68	318.71	99699.0
2023-05-02 18:00:00	QQQ	ETF	318.73	319.0	318.71	318.85	80868.0
2023-05-02 19:00:00	QQQ	ETF	318.83	319.3	318.78	319.3	96166.0
2023-05-02 04:00:00	IWM	ETF	174.76	174.76	174.41	174.6	3912.0
2023-05-02 05:00:00	IWM	ETF	174.55	174.71	174.39	174.51	6991.0
2023-05-02 06:00:00	IWM	ETF	174.3	174.53	174.27	174.5	34565.0
2023-05-02 07:00:00	IWM	ETF	174.59	174.72	174.5	174.65	51859.0
2023-05-02 08:00:00	IWM	ETF	174.55	174.7	174.35	174.53	326578.0
2023-05-02 09:00:00	IWM	ETF	174.5	174.54	172.89	173.09	3866933.0
2023-05-02 10:00:00	IWM	ETF	173.13	173.27	170.39	170.47	6115386.0
2023-05-02 11:00:00	IWM	ETF	170.46	171.025	169.92	170.59	5174977.0
2023-05-02 12:00:00	IWM	ETF	170.59	171.17	170.22	171.11	2826781.0
2023-05-02 13:00:00	IWM	ETF	171.11	172.0	170.95	171.675	2301799.0
2023-05-02 14:00:00	IWM	ETF	171.69	171.885	171.12	171.74	1825847.0
2023-05-02 15:00:00	IWM	ETF	171.73	172.05	171.45	171.68	4323916.0
2023-05-02 16:00:00	IWM	ETF	171.7	171.8	171.5667	171.62	1783428.0
2023-05-02 17:00:00	IWM	ETF	171.57	171.68	171.43	171.6	12301.0
2023-05-02 18:00:00	IWM	ETF	171.58	171.61	171.46	171.52	12706.0
2023-05-02 19:00:00	IWM	ETF	171.51	171.8299	171.51	171.78	15640.0
2023-05-02 05:00:00	DIA	ETF	339.81	339.81	339.81	339.81	100.0
2023-05-02 07:00:00	DIA	ETF	339.93	340.02	339.9	339.9	2705.0

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

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