PREVIEW / etf_1hour / 2001-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-02.parquet
  size:    11 KB
  rows:    228

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-08-02 09:00:00	SPY	ETF	123.23	123.25	122.1	122.81	1697800.0
2001-08-02 10:00:00	SPY	ETF	122.82	122.92	122.17	122.28	1453000.0
2001-08-02 11:00:00	SPY	ETF	122.28	122.55	122.15	122.48	1154100.0
2001-08-02 12:00:00	SPY	ETF	122.48	122.69	122.4	122.41	399000.0
2001-08-02 13:00:00	SPY	ETF	122.44	122.47	121.95	122.04	1299500.0
2001-08-02 14:00:00	SPY	ETF	122.02	122.32	121.89	122.23	1867000.0
2001-08-02 15:00:00	SPY	ETF	122.2	122.57	121.96	122.4	2037400.0
2001-08-02 16:00:00	SPY	ETF	122.38	122.96	122.25	122.61	807800.0
2001-08-02 17:00:00	SPY	ETF	122.12	122.68	122.12	122.63	11000.0
2001-08-02 18:00:00	SPY	ETF	122.59	122.59	122.59	122.59	100.0
2001-08-02 09:00:00	QQQ	ETF	43.79	44.0	43.66	43.75	8645900.0
2001-08-02 10:00:00	QQQ	ETF	43.75	43.84	43.26	43.3	10459200.0
2001-08-02 11:00:00	QQQ	ETF	43.29	43.49	43.1	43.33	4737500.0
2001-08-02 12:00:00	QQQ	ETF	43.34	43.58	43.26	43.34	2765400.0
2001-08-02 13:00:00	QQQ	ETF	43.4	43.42	42.82	42.92	5027200.0
2001-08-02 14:00:00	QQQ	ETF	42.94	43.27	42.86	43.11	4965200.0
2001-08-02 15:00:00	QQQ	ETF	43.11	43.75	42.93	43.68	10731700.0
2001-08-02 16:00:00	QQQ	ETF	43.65	44.05	43.3	43.92	3014400.0
2001-08-02 17:00:00	QQQ	ETF	43.92	43.95	43.89	43.9	83200.0
2001-08-02 18:00:00	QQQ	ETF	43.94	44.03	43.88	43.97	29600.0
2001-08-02 09:00:00	IWM	ETF	49.225	49.25	49.05	49.05	370800.0
2001-08-02 10:00:00	IWM	ETF	49.0	49.025	48.805	48.975	6000.0
2001-08-02 11:00:00	IWM	ETF	48.825	48.865	48.8	48.845	5400.0
2001-08-02 12:00:00	IWM	ETF	48.825	48.845	48.625	48.845	23600.0
2001-08-02 13:00:00	IWM	ETF	48.75	48.85	48.475	48.475	116400.0
2001-08-02 14:00:00	IWM	ETF	48.645	48.75	48.45	48.75	12400.0
2001-08-02 15:00:00	IWM	ETF	48.725	48.795	48.45	48.75	14200.0
2001-08-02 16:00:00	IWM	ETF	48.7	48.7	48.7	48.7	4000.0
2001-08-02 09:00:00	DIA	ETF	106.25	106.25	105.93	105.99	458100.0
2001-08-02 10:00:00	DIA	ETF	106.0	106.05	105.42	105.44	428900.0
2001-08-02 11:00:00	DIA	ETF	105.36	105.65	105.35	105.64	124500.0
2001-08-02 12:00:00	DIA	ETF	105.64	105.87	105.56	105.57	111200.0
2001-08-02 13:00:00	DIA	ETF	105.59	105.64	105.39	105.43	82000.0
2001-08-02 14:00:00	DIA	ETF	105.45	105.51	105.31	105.47	271800.0
2001-08-02 15:00:00	DIA	ETF	105.46	105.7	105.23	105.59	143100.0
2001-08-02 16:00:00	DIA	ETF	105.55	105.62	105.5	105.6	36500.0

> showing 36 of 228 rows — these rows as CSV

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