PREVIEW / etf_1hour / 2023-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-10.parquet
  size:    460 KB
  rows:    16,951

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-10 04:00:00	SPY	ETF	410.32	410.59	409.71	410.54	37620.0
2023-05-10 05:00:00	SPY	ETF	410.51	410.68	410.25	410.55	54485.0
2023-05-10 06:00:00	SPY	ETF	410.55	410.56	410.28	410.38	69497.0
2023-05-10 07:00:00	SPY	ETF	410.42	410.75	410.33	410.54	178173.0
2023-05-10 08:00:00	SPY	ETF	410.3508	414.48	409.7704	414.25	2350855.0
2023-05-10 09:00:00	SPY	ETF	414.26	414.91	411.5001	412.491	9552414.0
2023-05-10 10:00:00	SPY	ETF	412.49	413.73	410.18	410.919	12452848.0
2023-05-10 11:00:00	SPY	ETF	410.91	412.42	410.86	411.675	7093765.0
2023-05-10 12:00:00	SPY	ETF	411.68	411.71	410.42	410.65	4495198.0
2023-05-10 13:00:00	SPY	ETF	410.66	410.74	408.87	410.1	7973910.0
2023-05-10 14:00:00	SPY	ETF	410.08	412.2	410.075	412.01	7921144.0
2023-05-10 15:00:00	SPY	ETF	412.01	413.79	411.82	412.8	18940158.0
2023-05-10 16:00:00	SPY	ETF	412.79	413.23	412.75	412.86	3073845.0
2023-05-10 17:00:00	SPY	ETF	412.91	412.95	412.6	412.79	105572.0
2023-05-10 18:00:00	SPY	ETF	412.78	413.09	412.74	413.07	83787.0
2023-05-10 19:00:00	SPY	ETF	413.04	413.47	412.95	413.32	59084.0
2023-05-10 04:00:00	QQQ	ETF	320.75	321.0	320.2	320.98	35263.0
2023-05-10 05:00:00	QQQ	ETF	320.84	321.19	320.69	320.98	10382.0
2023-05-10 06:00:00	QQQ	ETF	320.9	321.19	320.77	321.13	15396.0
2023-05-10 07:00:00	QQQ	ETF	321.17	321.69	321.09	321.57	138076.0
2023-05-10 08:00:00	QQQ	ETF	321.56	324.71	320.6996	324.5	2496071.0
2023-05-10 09:00:00	QQQ	ETF	324.54	325.34	323.04	324.36	8248404.0
2023-05-10 10:00:00	QQQ	ETF	324.37	325.72	322.46	323.0	10610728.0
2023-05-10 11:00:00	QQQ	ETF	323.01	324.73	322.99	324.13	4448863.0
2023-05-10 12:00:00	QQQ	ETF	324.11	324.22	323.06	323.29	3201700.0
2023-05-10 13:00:00	QQQ	ETF	323.3	323.56	321.6	322.76	5328336.0
2023-05-10 14:00:00	QQQ	ETF	322.75	324.79	322.73	324.77	5105575.0
2023-05-10 15:00:00	QQQ	ETF	324.77	326.01	324.54	325.15	8765992.0
2023-05-10 16:00:00	QQQ	ETF	325.14	325.44	324.99	325.1	1158081.0
2023-05-10 17:00:00	QQQ	ETF	325.12	325.14	325.03	325.1384	93600.0
2023-05-10 18:00:00	QQQ	ETF	325.03	325.26	324.98	325.18	34853.0
2023-05-10 19:00:00	QQQ	ETF	325.16	325.53	325.05	325.46	42991.0
2023-05-10 04:00:00	IWM	ETF	173.25	173.47	173.01	173.42	13624.0
2023-05-10 05:00:00	IWM	ETF	173.41	173.46	173.26	173.34	5271.0
2023-05-10 06:00:00	IWM	ETF	173.42	173.44	173.3	173.41	89588.0
2023-05-10 07:00:00	IWM	ETF	173.41	173.51	173.33	173.45	20364.0
2023-05-10 08:00:00	IWM	ETF	173.4	176.56	173.25	176.4	680780.0
2023-05-10 09:00:00	IWM	ETF	176.38	176.63	174.28	174.58	3324745.0
2023-05-10 10:00:00	IWM	ETF	174.58	175.11	173.18	173.82	4257001.0
2023-05-10 11:00:00	IWM	ETF	173.83	174.52	173.79	174.045	2241242.0
2023-05-10 12:00:00	IWM	ETF	174.05	174.3799	173.53	173.71	1693487.0
2023-05-10 13:00:00	IWM	ETF	173.71	173.71	172.72	173.43	2219696.0
2023-05-10 14:00:00	IWM	ETF	173.44	174.2	173.44	173.95	1913288.0
2023-05-10 15:00:00	IWM	ETF	173.94	174.92	173.89	174.42	4812986.0
2023-05-10 16:00:00	IWM	ETF	174.41	174.74	174.41	174.54	735957.0
2023-05-10 17:00:00	IWM	ETF	174.48	174.59	174.41	174.5	65783.0
2023-05-10 18:00:00	IWM	ETF	174.5	174.69	174.47	174.69	12360.0
2023-05-10 19:00:00	IWM	ETF	174.69	174.85	174.64	174.85	9139.0
2023-05-10 07:00:00	DIA	ETF	335.23	335.3	335.23	335.26	2067.0
2023-05-10 08:00:00	DIA	ETF	335.24	337.7099	335.24	337.4	32976.0

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

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