PREVIEW / etf_1hour / 2022-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-01.parquet
  size:    455 KB
  rows:    16,465

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-06-01 04:00:00	SPY	ETF	413.87	413.87	412.38	413.18	22347.0
2022-06-01 05:00:00	SPY	ETF	413.29	413.92	413.18	413.3	14854.0
2022-06-01 06:00:00	SPY	ETF	413.28	413.35	412.5	412.8	16991.0
2022-06-01 07:00:00	SPY	ETF	412.81	414.09	412.78	414.07	470189.0
2022-06-01 08:00:00	SPY	ETF	412.81	415.02	412.49	414.49	450219.0
2022-06-01 09:00:00	SPY	ETF	414.49	416.24	413.94	414.8999	6214070.0
2022-06-01 10:00:00	SPY	ETF	414.83	415.19	409.09	410.74	11245568.0
2022-06-01 11:00:00	SPY	ETF	410.7424	410.75	407.36	407.6459	8165688.0
2022-06-01 12:00:00	SPY	ETF	407.64	408.58	406.93	408.0	6253236.0
2022-06-01 13:00:00	SPY	ETF	407.99	410.44	407.79	409.82	7158829.0
2022-06-01 14:00:00	SPY	ETF	409.82	412.33	409.681	411.12	9118813.0
2022-06-01 15:00:00	SPY	ETF	411.12	412.54	409.53	409.62	13522606.0
2022-06-01 16:00:00	SPY	ETF	409.63	409.98	409.15	409.38	4074012.0
2022-06-01 17:00:00	SPY	ETF	409.45	409.56	409.27	409.39	90890.0
2022-06-01 18:00:00	SPY	ETF	409.45	409.65	408.75	408.79	173459.0
2022-06-01 19:00:00	SPY	ETF	408.8	409.08	408.35	408.46	118296.0
2022-06-01 04:00:00	QQQ	ETF	308.35	308.38	306.88	307.8	48068.0
2022-06-01 05:00:00	QQQ	ETF	307.9	308.51	307.79	308.07	24853.0
2022-06-01 06:00:00	QQQ	ETF	308.02	308.12	307.4	307.8	43029.0
2022-06-01 07:00:00	QQQ	ETF	307.7	309.25	307.7	309.22	392121.0
2022-06-01 08:00:00	QQQ	ETF	309.26	310.04	307.6296	309.41	672628.0
2022-06-01 09:00:00	QQQ	ETF	309.41	312.65	309.28	312.2101	7078011.0
2022-06-01 10:00:00	QQQ	ETF	312.24	312.572	306.2	308.3	10419349.0
2022-06-01 11:00:00	QQQ	ETF	308.25	308.27	304.8	305.02	6086294.0
2022-06-01 12:00:00	QQQ	ETF	305.02	305.4446	303.73	304.725	5022580.0
2022-06-01 13:00:00	QQQ	ETF	304.75	306.46	304.5441	305.9999	4257503.0
2022-06-01 14:00:00	QQQ	ETF	306.0	308.71	305.82	307.51	5354620.0
2022-06-01 15:00:00	QQQ	ETF	307.5	308.81	305.83	305.98	8661246.0
2022-06-01 16:00:00	QQQ	ETF	305.98	306.3	305.45	306.0	1593931.0
2022-06-01 17:00:00	QQQ	ETF	305.9	306.0	305.7	305.93	95047.0
2022-06-01 18:00:00	QQQ	ETF	305.93	306.06	305.3	305.46	194038.0
2022-06-01 19:00:00	QQQ	ETF	305.36	305.65	304.9	304.99	121920.0
2022-06-01 04:00:00	IWM	ETF	185.78	185.78	185.13	185.58	13961.0
2022-06-01 05:00:00	IWM	ETF	185.63	185.95	185.61	185.69	15119.0
2022-06-01 06:00:00	IWM	ETF	185.67	185.69	185.28	185.45	10552.0
2022-06-01 07:00:00	IWM	ETF	185.43	185.9	185.43	185.89	32861.0
2022-06-01 08:00:00	IWM	ETF	185.4499	186.31	185.43	185.99	102772.0
2022-06-01 09:00:00	IWM	ETF	185.97	186.94	184.97	185.189	2656943.0
2022-06-01 10:00:00	IWM	ETF	185.2	185.37	183.25	183.85	3353958.0
2022-06-01 11:00:00	IWM	ETF	183.83	183.8599	181.872	182.0	2585087.0
2022-06-01 12:00:00	IWM	ETF	182.0	183.08	181.77	182.89	2105278.0
2022-06-01 13:00:00	IWM	ETF	182.9074	184.71	182.83	184.32	2080199.0
2022-06-01 14:00:00	IWM	ETF	184.32	185.519	184.1199	185.06	2471142.0
2022-06-01 15:00:00	IWM	ETF	185.06	185.75	184.23	184.28	4334329.0
2022-06-01 16:00:00	IWM	ETF	184.28	184.49	184.0	184.15	1401055.0
2022-06-01 17:00:00	IWM	ETF	184.23	184.26	184.01	184.02	19676.0
2022-06-01 18:00:00	IWM	ETF	184.11	184.26	183.82	183.83	527422.0
2022-06-01 19:00:00	IWM	ETF	183.97	184.06	183.53	183.67	18332.0
2022-06-01 04:00:00	DIA	ETF	331.06	331.06	331.0	331.0	435.0
2022-06-01 05:00:00	DIA	ETF	331.54	331.54	331.54	331.54	100.0

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

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