PREVIEW / etf_1hour / 2022-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-12.parquet
  size:    446 KB
  rows:    16,497

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-12 04:00:00	SPY	ETF	359.22	360.09	358.82	359.7	55912.0
2022-10-12 05:00:00	SPY	ETF	359.6	361.19	359.51	360.5	31517.0
2022-10-12 06:00:00	SPY	ETF	360.54	360.97	359.11	359.85	57786.0
2022-10-12 07:00:00	SPY	ETF	360.0	360.75	359.16	359.98	281795.0
2022-10-12 08:00:00	SPY	ETF	360.05	361.05	357.74	358.6	2044306.0
2022-10-12 09:00:00	SPY	ETF	358.58	359.8179	356.3	358.8279	9243818.0
2022-10-12 10:00:00	SPY	ETF	358.82	359.45	357.0	357.83	7689071.0
2022-10-12 11:00:00	SPY	ETF	357.88	359.45	357.76	359.19	6173387.0
2022-10-12 12:00:00	SPY	ETF	359.22	359.8	357.62	358.58	5132913.0
2022-10-12 13:00:00	SPY	ETF	358.58	358.82	357.32	357.6599	4295731.0
2022-10-12 14:00:00	SPY	ETF	357.61	359.4	357.11	357.69	8623312.0
2022-10-12 15:00:00	SPY	ETF	357.69	358.3	356.5	356.55	12115877.0
2022-10-12 16:00:00	SPY	ETF	356.54	359.81	356.52	357.07	3632807.0
2022-10-12 17:00:00	SPY	ETF	357.1	357.29	356.56	357.29	135983.0
2022-10-12 18:00:00	SPY	ETF	357.3	357.55	357.18	357.27	87047.0
2022-10-12 19:00:00	SPY	ETF	357.22	357.71	357.11	357.59	67692.0
2022-10-12 20:00:00	SPY	ETF	357.6	357.6	357.58	357.58	392.0
2022-10-12 04:00:00	QQQ	ETF	263.86	265.09	263.86	264.78	105690.0
2022-10-12 05:00:00	QQQ	ETF	264.75	266.02	264.6	265.5	31023.0
2022-10-12 06:00:00	QQQ	ETF	265.48	265.76	264.58	265.03	96484.0
2022-10-12 07:00:00	QQQ	ETF	265.03	265.63	264.87	265.2	293578.0
2022-10-12 08:00:00	QQQ	ETF	265.2	265.8995	262.75	263.95	1820714.0
2022-10-12 09:00:00	QQQ	ETF	263.94	265.36	261.95	264.01	7107616.0
2022-10-12 10:00:00	QQQ	ETF	264.09	264.44	262.0204	262.7	5937412.0
2022-10-12 11:00:00	QQQ	ETF	262.7384	264.77	262.61	264.55	4205224.0
2022-10-12 12:00:00	QQQ	ETF	264.57	264.849	262.86	263.815	3772494.0
2022-10-12 13:00:00	QQQ	ETF	263.83	264.13	262.745	263.0599	3224692.0
2022-10-12 14:00:00	QQQ	ETF	263.02	264.71	262.56	263.2	5370127.0
2022-10-12 15:00:00	QQQ	ETF	263.21	263.9099	262.68	262.73	6746081.0
2022-10-12 16:00:00	QQQ	ETF	262.69	263.11	262.64	263.1	1109488.0
2022-10-12 17:00:00	QQQ	ETF	263.12	263.22	262.66	263.08	438677.0
2022-10-12 18:00:00	QQQ	ETF	263.1	263.36	263.07	263.17	57923.0
2022-10-12 19:00:00	QQQ	ETF	263.12	263.5599	263.09	263.52	175101.0
2022-10-12 04:00:00	IWM	ETF	168.77	169.0	168.49	168.74	14045.0
2022-10-12 05:00:00	IWM	ETF	168.73	169.71	168.73	169.38	18328.0
2022-10-12 06:00:00	IWM	ETF	169.45	169.62	168.6	168.94	12915.0
2022-10-12 07:00:00	IWM	ETF	169.01	169.32	168.81	168.87	26301.0
2022-10-12 08:00:00	IWM	ETF	168.96	169.37	167.83	168.06	198742.0
2022-10-12 09:00:00	IWM	ETF	167.95	168.05	165.91	166.72	3216389.0
2022-10-12 10:00:00	IWM	ETF	166.74	167.25	165.48	165.97	3149277.0
2022-10-12 11:00:00	IWM	ETF	165.98	167.75	165.9	167.54	2453495.0
2022-10-12 12:00:00	IWM	ETF	167.57	167.8	166.89	167.45	1594771.0
2022-10-12 13:00:00	IWM	ETF	167.435	167.785	167.16	167.23	1589451.0
2022-10-12 14:00:00	IWM	ETF	167.25	168.46	167.12	167.71	2072927.0
2022-10-12 15:00:00	IWM	ETF	167.68	168.17	167.22	167.26	2840613.0
2022-10-12 16:00:00	IWM	ETF	167.26	167.81	167.26	167.77	1114940.0
2022-10-12 17:00:00	IWM	ETF	167.3	167.84	167.26	167.71	239405.0
2022-10-12 18:00:00	IWM	ETF	167.71	167.95	167.71	167.73	21622.0
2022-10-12 19:00:00	IWM	ETF	167.76	168.01	167.67	167.93	35379.0
2022-10-12 04:00:00	DIA	ETF	293.85	293.85	293.43	293.43	8195.0

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

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