PREVIEW / etf_1hour / 2022-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-03.parquet
  size:    448 KB
  rows:    16,140

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
2022-08-03 04:00:00	SPY	ETF	408.64	409.23	408.09	408.95	23583.0
2022-08-03 05:00:00	SPY	ETF	409.2	410.13	409.2	409.71	32297.0
2022-08-03 06:00:00	SPY	ETF	409.67	409.93	409.4	409.66	47546.0
2022-08-03 07:00:00	SPY	ETF	409.66	410.27	409.58	410.03	73430.0
2022-08-03 08:00:00	SPY	ETF	409.67	411.0	408.4896	410.67	339014.0
2022-08-03 09:00:00	SPY	ETF	410.71	411.725	410.0	411.5288	4927341.0
2022-08-03 10:00:00	SPY	ETF	411.48	412.45	410.18	411.58	7147390.0
2022-08-03 11:00:00	SPY	ETF	411.59	413.4697	411.41	413.36	6400769.0
2022-08-03 12:00:00	SPY	ETF	413.3799	414.64	412.6701	414.33	4694495.0
2022-08-03 13:00:00	SPY	ETF	414.32	414.81	413.95	414.555	3726610.0
2022-08-03 14:00:00	SPY	ETF	414.56	415.22	414.24	414.815	4704260.0
2022-08-03 15:00:00	SPY	ETF	414.81	415.68	414.19	414.41	13582598.0
2022-08-03 16:00:00	SPY	ETF	414.41	414.45	413.75	413.96	3327904.0
2022-08-03 17:00:00	SPY	ETF	414.05	414.12	413.89	414.04	102074.0
2022-08-03 18:00:00	SPY	ETF	414.0	414.06	413.7	414.05	63436.0
2022-08-03 19:00:00	SPY	ETF	414.0	414.03	413.76	413.76	54406.0
2022-08-03 04:00:00	QQQ	ETF	313.99	314.82	313.66	314.59	50061.0
2022-08-03 05:00:00	QQQ	ETF	314.49	316.06	314.48	315.58	68266.0
2022-08-03 06:00:00	QQQ	ETF	315.52	315.63	315.15	315.32	101079.0
2022-08-03 07:00:00	QQQ	ETF	315.38	316.12	315.26	315.83	161024.0
2022-08-03 08:00:00	QQQ	ETF	315.6	316.61	313.6796	316.22	534838.0
2022-08-03 09:00:00	QQQ	ETF	316.281	319.32	315.96	319.069	6004278.0
2022-08-03 10:00:00	QQQ	ETF	319.03	320.42	317.695	319.63	8616403.0
2022-08-03 11:00:00	QQQ	ETF	319.6334	321.63	319.38	321.58	5514639.0
2022-08-03 12:00:00	QQQ	ETF	321.56	322.9199	320.7416	322.47	4280462.0
2022-08-03 13:00:00	QQQ	ETF	322.48	322.97	322.19	322.7099	3683025.0
2022-08-03 14:00:00	QQQ	ETF	322.74	323.3799	322.375	322.985	3762995.0
2022-08-03 15:00:00	QQQ	ETF	322.97	323.7291	322.61	322.83	8691900.0
2022-08-03 16:00:00	QQQ	ETF	322.83	323.1542	322.12	322.3	1878907.0
2022-08-03 17:00:00	QQQ	ETF	322.34	322.89	322.3	322.44	49747.0
2022-08-03 18:00:00	QQQ	ETF	322.39	322.39	321.8	322.24	169739.0
2022-08-03 19:00:00	QQQ	ETF	322.11	322.11	321.9	321.97	64159.0
2022-08-03 04:00:00	IWM	ETF	187.61	187.93	187.34	187.93	9769.0
2022-08-03 05:00:00	IWM	ETF	187.86	188.26	187.86	188.14	31262.0
2022-08-03 06:00:00	IWM	ETF	188.1	188.26	187.98	188.05	10322.0
2022-08-03 07:00:00	IWM	ETF	188.02	188.47	188.02	188.23	41365.0
2022-08-03 08:00:00	IWM	ETF	188.3199	188.74	188.12	188.56	129869.0
2022-08-03 09:00:00	IWM	ETF	188.55	188.95	188.06	188.56	1988053.0
2022-08-03 10:00:00	IWM	ETF	188.55	188.93	187.64	188.15	2079185.0
2022-08-03 11:00:00	IWM	ETF	188.15	189.19	187.97	189.18	1741739.0
2022-08-03 12:00:00	IWM	ETF	189.16	189.68	188.77	189.63	926106.0
2022-08-03 13:00:00	IWM	ETF	189.66	190.05	189.41	189.89	2106189.0
2022-08-03 14:00:00	IWM	ETF	189.9	190.07	189.555	189.74	992375.0
2022-08-03 15:00:00	IWM	ETF	189.73	190.15	189.61	189.74	2984676.0
2022-08-03 16:00:00	IWM	ETF	189.75	189.8966	189.43	189.58	1296754.0
2022-08-03 17:00:00	IWM	ETF	189.66	189.75	189.44	189.63	86771.0
2022-08-03 18:00:00	IWM	ETF	189.63	189.75	189.49	189.67	17900.0
2022-08-03 19:00:00	IWM	ETF	189.7	189.73	189.56	189.56	30322.0
2022-08-03 04:00:00	DIA	ETF	324.7	325.11	324.54	325.11	3200.0
2022-08-03 05:00:00	DIA	ETF	325.36	325.41	325.36	325.41	2800.0

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

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