PREVIEW / etf_1hour / 2001-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-31.parquet
  size:    12 KB
  rows:    238

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-07-31 09:00:00	SPY	ETF	121.0	121.25	120.88	121.25	763600.0
2001-07-31 10:00:00	SPY	ETF	121.21	122.26	120.86	122.24	2543900.0
2001-07-31 11:00:00	SPY	ETF	122.24	122.55	122.1	122.29	1479600.0
2001-07-31 12:00:00	SPY	ETF	122.27	122.55	122.23	122.4	537700.0
2001-07-31 13:00:00	SPY	ETF	122.39	122.67	122.23	122.65	540700.0
2001-07-31 14:00:00	SPY	ETF	122.68	122.68	122.1	122.17	1177200.0
2001-07-31 15:00:00	SPY	ETF	122.17	122.37	121.4	121.46	1051800.0
2001-07-31 16:00:00	SPY	ETF	121.44	121.47	121.2	121.35	867000.0
2001-07-31 17:00:00	SPY	ETF	121.18	121.18	121.18	121.18	1500.0
2001-07-31 18:00:00	SPY	ETF	121.01	121.01	121.01	121.01	500.0
2001-07-31 09:00:00	QQQ	ETF	41.84	42.01	41.52	41.83	4284100.0
2001-07-31 10:00:00	QQQ	ETF	41.88	42.48	41.5	42.4	11516800.0
2001-07-31 11:00:00	QQQ	ETF	42.38	42.73	42.32	42.46	7305400.0
2001-07-31 12:00:00	QQQ	ETF	42.46	42.78	42.4	42.62	3744700.0
2001-07-31 13:00:00	QQQ	ETF	42.62	42.78	42.5	42.72	3368400.0
2001-07-31 14:00:00	QQQ	ETF	42.74	42.74	42.21	42.35	5435600.0
2001-07-31 15:00:00	QQQ	ETF	42.39	42.48	41.9	41.95	9370400.0
2001-07-31 16:00:00	QQQ	ETF	41.93	42.08	41.73	41.82	2799300.0
2001-07-31 17:00:00	QQQ	ETF	41.89	41.92	41.73	41.75	207900.0
2001-07-31 18:00:00	QQQ	ETF	41.75	41.97	41.72	41.75	32600.0
2001-07-31 09:00:00	IWM	ETF	48.295	48.3	48.295	48.3	3400.0
2001-07-31 10:00:00	IWM	ETF	48.38	48.665	48.295	48.645	44800.0
2001-07-31 11:00:00	IWM	ETF	48.685	48.835	48.6	48.775	167600.0
2001-07-31 12:00:00	IWM	ETF	48.745	48.805	48.63	48.68	22600.0
2001-07-31 13:00:00	IWM	ETF	48.75	48.825	48.66	48.825	7800.0
2001-07-31 14:00:00	IWM	ETF	48.8	48.8	48.31	48.35	136800.0
2001-07-31 15:00:00	IWM	ETF	48.38	48.52	48.06	48.06	214800.0
2001-07-31 16:00:00	IWM	ETF	48.12	48.12	48.075	48.115	19000.0
2001-07-31 09:00:00	DIA	ETF	104.25	104.57	104.16	104.57	322100.0
2001-07-31 10:00:00	DIA	ETF	104.55	105.64	104.36	105.53	357300.0
2001-07-31 11:00:00	DIA	ETF	105.53	105.88	105.53	105.69	302200.0
2001-07-31 12:00:00	DIA	ETF	105.67	105.78	105.58	105.58	129900.0
2001-07-31 13:00:00	DIA	ETF	105.62	106.0	105.53	106.0	175300.0
2001-07-31 14:00:00	DIA	ETF	106.0	106.05	105.6	105.6	249400.0
2001-07-31 15:00:00	DIA	ETF	105.6	105.74	105.2	105.2	153700.0
2001-07-31 16:00:00	DIA	ETF	105.27	105.27	105.03	105.1	15600.0

> showing 36 of 238 rows — these rows as CSV

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