PREVIEW / etf_1hour / 2001-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-22.parquet
  size:    11 KB
  rows:    233

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
2001-06-22 09:00:00	SPY	ETF	123.49	123.59	123.21	123.3	1902000.0
2001-06-22 10:00:00	SPY	ETF	123.28	123.58	122.93	123.22	1702800.0
2001-06-22 11:00:00	SPY	ETF	123.24	123.3	122.65	122.7	1682200.0
2001-06-22 12:00:00	SPY	ETF	122.73	122.95	122.5	122.75	922700.0
2001-06-22 13:00:00	SPY	ETF	122.77	123.04	122.68	122.85	976000.0
2001-06-22 14:00:00	SPY	ETF	122.84	123.38	122.81	123.2	1242600.0
2001-06-22 15:00:00	SPY	ETF	123.12	123.19	122.16	122.75	2787200.0
2001-06-22 16:00:00	SPY	ETF	122.69	123.34	122.65	122.85	461900.0
2001-06-22 17:00:00	SPY	ETF	122.95	123.34	122.95	123.34	30200.0
2001-06-22 09:00:00	QQQ	ETF	43.62	43.92	43.15	43.75	9396600.0
2001-06-22 10:00:00	QQQ	ETF	43.76	44.2	43.35	43.86	11164200.0
2001-06-22 11:00:00	QQQ	ETF	43.84	44.0	43.4	43.54	6094400.0
2001-06-22 12:00:00	QQQ	ETF	43.55	43.64	43.28	43.59	4377700.0
2001-06-22 13:00:00	QQQ	ETF	43.55	43.72	43.27	43.38	3898200.0
2001-06-22 14:00:00	QQQ	ETF	43.35	43.77	43.31	43.5	3582000.0
2001-06-22 15:00:00	QQQ	ETF	43.5	43.53	42.59	43.1	8637700.0
2001-06-22 16:00:00	QQQ	ETF	43.1	43.35	43.05	43.25	908700.0
2001-06-22 17:00:00	QQQ	ETF	43.25	43.3	43.02	43.09	53400.0
2001-06-22 18:00:00	QQQ	ETF	43.09	43.13	43.01	43.1	3700.0
2001-06-22 09:00:00	IWM	ETF	49.625	49.625	49.425	49.425	40400.0
2001-06-22 10:00:00	IWM	ETF	49.425	49.425	49.205	49.33	126600.0
2001-06-22 11:00:00	IWM	ETF	49.24	49.24	48.705	48.705	109600.0
2001-06-22 12:00:00	IWM	ETF	48.705	48.87	48.705	48.845	20200.0
2001-06-22 13:00:00	IWM	ETF	48.84	49.05	48.84	48.845	47600.0
2001-06-22 14:00:00	IWM	ETF	49.1	49.1	49.07	49.1	5400.0
2001-06-22 15:00:00	IWM	ETF	49.095	49.095	48.5	48.6	315600.0
2001-06-22 16:00:00	IWM	ETF	48.565	48.65	48.565	48.6	5800.0
2001-06-22 09:00:00	DIA	ETF	106.95	106.95	106.48	106.72	291500.0
2001-06-22 10:00:00	DIA	ETF	106.75	106.85	106.48	106.58	179400.0
2001-06-22 11:00:00	DIA	ETF	106.59	106.62	106.2	106.25	157300.0
2001-06-22 12:00:00	DIA	ETF	106.22	106.5	106.06	106.41	113700.0
2001-06-22 13:00:00	DIA	ETF	106.44	106.46	106.2	106.35	85900.0
2001-06-22 14:00:00	DIA	ETF	106.38	106.75	106.35	106.58	145100.0
2001-06-22 15:00:00	DIA	ETF	106.46	106.46	105.8	106.12	481100.0
2001-06-22 16:00:00	DIA	ETF	106.15	106.32	106.0	106.24	182800.0

> showing 35 of 233 rows — these rows as CSV

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