PREVIEW / etf_1hour / 2022-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-10.parquet
  size:    448 KB
  rows:    16,714

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-10-10 04:00:00	SPY	ETF	361.44	361.6	360.1	360.76	75724.0
2022-10-10 05:00:00	SPY	ETF	360.76	362.52	360.76	362.42	54955.0
2022-10-10 06:00:00	SPY	ETF	362.56	362.69	361.5	361.68	60606.0
2022-10-10 07:00:00	SPY	ETF	361.68	362.74	361.68	362.27	190748.0
2022-10-10 08:00:00	SPY	ETF	362.13	364.2	361.25	364.121	461193.0
2022-10-10 09:00:00	SPY	ETF	364.2	364.43	361.54	361.65	6316382.0
2022-10-10 10:00:00	SPY	ETF	361.64	363.0	359.66	360.21	9757654.0
2022-10-10 11:00:00	SPY	ETF	360.2	361.47	359.3	360.79	6386007.0
2022-10-10 12:00:00	SPY	ETF	360.8	360.99	358.35	358.37	5720859.0
2022-10-10 13:00:00	SPY	ETF	358.35	362.37	357.67	361.498	9587015.0
2022-10-10 14:00:00	SPY	ETF	361.48	361.76	359.94	360.5401	6207257.0
2022-10-10 15:00:00	SPY	ETF	360.555	361.975	360.03	360.07	10626114.0
2022-10-10 16:00:00	SPY	ETF	360.08	360.57	360.02	360.45	2804153.0
2022-10-10 17:00:00	SPY	ETF	360.37	360.57	360.17	360.22	113396.0
2022-10-10 18:00:00	SPY	ETF	360.25	360.8	360.13	360.7	139832.0
2022-10-10 19:00:00	SPY	ETF	360.7	361.25	360.68	360.9	68398.0
2022-10-10 04:00:00	QQQ	ETF	267.75	268.0	266.6	267.19	167570.0
2022-10-10 05:00:00	QQQ	ETF	267.25	268.61	267.25	268.47	88634.0
2022-10-10 06:00:00	QQQ	ETF	268.54	268.65	267.56	267.7	69207.0
2022-10-10 07:00:00	QQQ	ETF	267.72	268.7	267.71	268.37	242429.0
2022-10-10 08:00:00	QQQ	ETF	268.1	269.75	267.38	269.73	627220.0
2022-10-10 09:00:00	QQQ	ETF	269.74	269.9	266.71	266.98	6058807.0
2022-10-10 10:00:00	QQQ	ETF	267.0	268.3	265.0504	265.48	7999316.0
2022-10-10 11:00:00	QQQ	ETF	265.47	267.11	264.89	266.37	5041674.0
2022-10-10 12:00:00	QQQ	ETF	266.37	266.37	264.38	264.39	4940989.0
2022-10-10 13:00:00	QQQ	ETF	264.375	268.27	263.64	267.5	8661655.0
2022-10-10 14:00:00	QQQ	ETF	267.49	267.7	265.96	266.7	4710911.0
2022-10-10 15:00:00	QQQ	ETF	266.7199	267.84	266.07	266.17	6826489.0
2022-10-10 16:00:00	QQQ	ETF	266.16	266.69	266.16	266.52	1212045.0
2022-10-10 17:00:00	QQQ	ETF	266.48	266.51	266.2	266.34	82376.0
2022-10-10 18:00:00	QQQ	ETF	266.39	266.88	266.27	266.87	65496.0
2022-10-10 19:00:00	QQQ	ETF	266.83	267.37	266.83	266.98	330095.0
2022-10-10 04:00:00	IWM	ETF	167.98	168.02	167.33	167.79	12852.0
2022-10-10 05:00:00	IWM	ETF	167.87	168.78	167.87	168.78	11164.0
2022-10-10 06:00:00	IWM	ETF	168.79	168.79	168.2	168.25	25829.0
2022-10-10 07:00:00	IWM	ETF	168.35	168.74	168.35	168.6	72875.0
2022-10-10 08:00:00	IWM	ETF	168.48	169.55	168.09	169.52	67564.0
2022-10-10 09:00:00	IWM	ETF	169.53	169.58	168.0	168.15	2227150.0
2022-10-10 10:00:00	IWM	ETF	168.14	169.13	167.33	167.6	2663173.0
2022-10-10 11:00:00	IWM	ETF	167.55	168.66	167.18	168.23	1857162.0
2022-10-10 12:00:00	IWM	ETF	168.21	168.28	166.95	166.98	2162170.0
2022-10-10 13:00:00	IWM	ETF	166.9789	169.3	166.59	168.77	2453799.0
2022-10-10 14:00:00	IWM	ETF	168.76	168.82	167.75	168.0	1907560.0
2022-10-10 15:00:00	IWM	ETF	168.0	168.61	167.61	167.66	2891076.0
2022-10-10 16:00:00	IWM	ETF	167.65	167.87	167.65	167.76	779366.0
2022-10-10 17:00:00	IWM	ETF	167.71	167.74	167.61	167.7	188855.0
2022-10-10 18:00:00	IWM	ETF	167.75	168.04	167.6	168.04	32467.0
2022-10-10 19:00:00	IWM	ETF	167.99	168.34	167.95	168.17	26668.0
2022-10-10 04:00:00	DIA	ETF	292.0	292.04	291.28	291.82	6118.0
2022-10-10 05:00:00	DIA	ETF	292.0	292.9	292.0	292.89	4175.0

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

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