PREVIEW / etf_1hour / 2023-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-01.parquet
  size:    483 KB
  rows:    17,327

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-06-01 04:00:00	SPY	ETF	418.5	419.08	418.2	419.0	22134.0
2023-06-01 05:00:00	SPY	ETF	418.94	418.98	418.64	418.97	99808.0
2023-06-01 06:00:00	SPY	ETF	418.97	419.34	418.81	418.85	54148.0
2023-06-01 07:00:00	SPY	ETF	418.84	419.24	418.6	418.68	213129.0
2023-06-01 08:00:00	SPY	ETF	418.8805	419.22	417.6	418.05	725056.0
2023-06-01 09:00:00	SPY	ETF	418.04	418.3582	416.79	417.2	6643705.0
2023-06-01 10:00:00	SPY	ETF	417.27	419.75	417.21	419.37	11627493.0
2023-06-01 11:00:00	SPY	ETF	419.38	421.0942	419.18	421.055	9522920.0
2023-06-01 12:00:00	SPY	ETF	421.06	421.845	421.06	421.662	8272282.0
2023-06-01 13:00:00	SPY	ETF	421.67	422.08	421.27	422.08	4712219.0
2023-06-01 14:00:00	SPY	ETF	422.08	422.5	421.73	422.43	5188576.0
2023-06-01 15:00:00	SPY	ETF	422.432	422.92	420.87	421.81	19144041.0
2023-06-01 16:00:00	SPY	ETF	421.81	422.2	421.59	422.13	3831638.0
2023-06-01 17:00:00	SPY	ETF	422.11	422.5	421.82	422.21	122251.0
2023-06-01 18:00:00	SPY	ETF	422.18	422.22	422.05	422.19	65190.0
2023-06-01 19:00:00	SPY	ETF	422.18	422.18	421.95	422.0	74514.0
2023-06-01 04:00:00	QQQ	ETF	347.75	348.12	347.3	348.08	33192.0
2023-06-01 05:00:00	QQQ	ETF	348.05	348.05	347.65	347.93	15128.0
2023-06-01 06:00:00	QQQ	ETF	347.87	348.53	347.79	348.25	41692.0
2023-06-01 07:00:00	QQQ	ETF	348.18	348.68	347.94	348.02	142178.0
2023-06-01 08:00:00	QQQ	ETF	348.2988	348.6	347.1	347.71	586696.0
2023-06-01 09:00:00	QQQ	ETF	347.63	348.37	346.66	348.06	5485834.0
2023-06-01 10:00:00	QQQ	ETF	348.07	349.84	347.17	349.22	6795633.0
2023-06-01 11:00:00	QQQ	ETF	349.23	350.82	348.92	350.81	4239588.0
2023-06-01 12:00:00	QQQ	ETF	350.805	351.85	350.805	351.76	3946419.0
2023-06-01 13:00:00	QQQ	ETF	351.77	352.355	351.34	352.35	3219238.0
2023-06-01 14:00:00	QQQ	ETF	352.35	352.95	352.0699	352.78	4222304.0
2023-06-01 15:00:00	QQQ	ETF	352.7799	353.36	351.06	352.05	8197533.0
2023-06-01 16:00:00	QQQ	ETF	352.04	352.67	348.1785	352.6	1789346.0
2023-06-01 17:00:00	QQQ	ETF	352.6	353.0	352.01	352.52	477614.0
2023-06-01 18:00:00	QQQ	ETF	352.52	352.58	352.4	352.49	56998.0
2023-06-01 19:00:00	QQQ	ETF	352.43	352.44	352.2	352.3	38894.0
2023-06-01 04:00:00	IWM	ETF	174.15	174.36	173.96	174.3	7815.0
2023-06-01 05:00:00	IWM	ETF	174.29	174.41	174.12	174.41	65080.0
2023-06-01 06:00:00	IWM	ETF	174.46	174.63	174.17	174.17	66976.0
2023-06-01 07:00:00	IWM	ETF	174.26	174.4	174.19	174.22	65302.0
2023-06-01 08:00:00	IWM	ETF	174.25	174.5	173.75	173.89	287220.0
2023-06-01 09:00:00	IWM	ETF	173.85	174.1	172.9317	173.12	3107869.0
2023-06-01 10:00:00	IWM	ETF	173.15	175.2	173.07	174.94	4756027.0
2023-06-01 11:00:00	IWM	ETF	174.95	176.24	174.82	175.969	3472008.0
2023-06-01 12:00:00	IWM	ETF	175.97	176.2	175.72	175.9	2036549.0
2023-06-01 13:00:00	IWM	ETF	175.9	176.09	175.62	176.07	1569180.0
2023-06-01 14:00:00	IWM	ETF	176.07	176.18	175.8405	176.02	1923147.0
2023-06-01 15:00:00	IWM	ETF	176.03	176.19	175.38	175.64	4132311.0
2023-06-01 16:00:00	IWM	ETF	175.64	175.87	175.55	175.8	592905.0
2023-06-01 17:00:00	IWM	ETF	175.82	176.0	175.65	175.9	502049.0
2023-06-01 18:00:00	IWM	ETF	175.88	175.89	175.8	175.88	11686.0
2023-06-01 19:00:00	IWM	ETF	175.83	175.83	175.7104	175.72	14780.0
2023-06-01 04:00:00	DIA	ETF	329.7	330.02	329.48	330.02	1650.0
2023-06-01 06:00:00	DIA	ETF	329.98	330.13	329.98	330.0	3750.0

> showing 50 of 17,327 rows — these rows as CSV

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