PREVIEW / etf_1hour / 2022-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-02.parquet
  size:    469 KB
  rows:    17,160

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-05-02 04:00:00	SPY	ETF	413.0	414.54	412.55	413.0	38092.0
2022-05-02 05:00:00	SPY	ETF	413.0	414.33	413.0	413.7	26251.0
2022-05-02 06:00:00	SPY	ETF	413.72	414.2	413.33	413.4	85216.0
2022-05-02 07:00:00	SPY	ETF	413.62	413.66	410.49	410.7	476519.0
2022-05-02 08:00:00	SPY	ETF	413.13	415.0	410.45	411.04	669053.0
2022-05-02 09:00:00	SPY	ETF	411.01	413.37	409.25	412.27	12254394.0
2022-05-02 10:00:00	SPY	ETF	412.27	415.92	410.35	412.41	16131096.0
2022-05-02 11:00:00	SPY	ETF	412.42	412.62	409.8	411.76	12658433.0
2022-05-02 12:00:00	SPY	ETF	411.71	412.56	408.68	408.99	8754315.0
2022-05-02 13:00:00	SPY	ETF	408.98	410.08	406.92	407.65	10724644.0
2022-05-02 14:00:00	SPY	ETF	407.58	408.82	405.02	406.46	16147282.0
2022-05-02 15:00:00	SPY	ETF	406.4	414.66	406.32	414.5	30701346.0
2022-05-02 16:00:00	SPY	ETF	414.54	415.01	413.71	414.07	4468852.0
2022-05-02 17:00:00	SPY	ETF	414.14	414.33	414.0	414.09	116557.0
2022-05-02 18:00:00	SPY	ETF	414.06	414.1	413.59	413.76	120278.0
2022-05-02 19:00:00	SPY	ETF	413.75	414.3	413.75	414.11	75807.0
2022-05-02 04:00:00	QQQ	ETF	314.06	315.69	313.25	313.96	147448.0
2022-05-02 05:00:00	QQQ	ETF	314.05	315.01	314.05	314.55	103697.0
2022-05-02 06:00:00	QQQ	ETF	314.52	315.23	314.25	314.46	132304.0
2022-05-02 07:00:00	QQQ	ETF	314.5	314.75	311.0	311.43	599829.0
2022-05-02 08:00:00	QQQ	ETF	314.6799	316.05	311.11	311.79	842622.0
2022-05-02 09:00:00	QQQ	ETF	311.75	316.1135	310.4414	314.92	10867383.0
2022-05-02 10:00:00	QQQ	ETF	314.91	317.76	312.1	314.455	13660380.0
2022-05-02 11:00:00	QQQ	ETF	314.44	315.17	312.39	314.42	9555864.0
2022-05-02 12:00:00	QQQ	ETF	314.4099	315.62	311.83	312.11	8632188.0
2022-05-02 13:00:00	QQQ	ETF	312.11	312.83	310.34	311.43	7860234.0
2022-05-02 14:00:00	QQQ	ETF	311.44	312.69	309.645	311.15	8891745.0
2022-05-02 15:00:00	QQQ	ETF	311.05	318.72	311.0	318.46	20590244.0
2022-05-02 16:00:00	QQQ	ETF	318.46	318.77	317.28	317.99	3036556.0
2022-05-02 17:00:00	QQQ	ETF	317.95	318.15	317.93	318.0	139604.0
2022-05-02 18:00:00	QQQ	ETF	318.0	318.08	317.42	317.61	111620.0
2022-05-02 19:00:00	QQQ	ETF	317.62	318.19	317.62	318.03	136436.0
2022-05-02 04:00:00	IWM	ETF	186.0	186.02	185.33	185.4	20001.0
2022-05-02 05:00:00	IWM	ETF	185.44	185.94	185.27	185.64	15155.0
2022-05-02 06:00:00	IWM	ETF	185.49	185.98	185.49	185.69	8618.0
2022-05-02 07:00:00	IWM	ETF	185.57	185.6	184.24	184.24	54773.0
2022-05-02 08:00:00	IWM	ETF	185.7	185.7	184.21	184.5	105569.0
2022-05-02 09:00:00	IWM	ETF	184.49	186.36	184.1	185.94	4100790.0
2022-05-02 10:00:00	IWM	ETF	185.98	187.82	185.11	186.18	4578471.0
2022-05-02 11:00:00	IWM	ETF	186.21	186.25	184.96	186.07	3305482.0
2022-05-02 12:00:00	IWM	ETF	186.07	186.42	184.19	184.3	2450562.0
2022-05-02 13:00:00	IWM	ETF	184.32	184.54	182.97	183.42	2510734.0
2022-05-02 14:00:00	IWM	ETF	183.39	184.0	182.38	183.14	2780169.0
2022-05-02 15:00:00	IWM	ETF	183.13	186.94	183.07	186.87	7254615.0
2022-05-02 16:00:00	IWM	ETF	186.89	187.22	186.56	186.62	1460362.0
2022-05-02 17:00:00	IWM	ETF	186.51	186.79	186.5	186.64	30529.0
2022-05-02 18:00:00	IWM	ETF	186.74	186.74	186.33	186.44	21447.0
2022-05-02 19:00:00	IWM	ETF	186.38	186.59	186.3	186.47	29757.0
2022-05-02 04:00:00	DIA	ETF	330.89	330.89	330.54	330.54	300.0
2022-05-02 07:00:00	DIA	ETF	330.96	331.15	329.45	329.45	2315.0

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

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