PREVIEW / etf_1hour / 2001-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-27.parquet
  size:    11 KB
  rows:    217

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-27 09:00:00	SPY	ETF	120.83	120.99	120.17	120.3	1349900.0
2001-07-27 10:00:00	SPY	ETF	120.31	120.67	119.91	120.21	1226100.0
2001-07-27 11:00:00	SPY	ETF	120.17	121.07	120.06	120.79	1705200.0
2001-07-27 12:00:00	SPY	ETF	120.79	121.18	120.61	120.95	686400.0
2001-07-27 13:00:00	SPY	ETF	120.95	121.35	120.95	121.04	717700.0
2001-07-27 14:00:00	SPY	ETF	121.0	121.16	120.66	120.91	766500.0
2001-07-27 15:00:00	SPY	ETF	120.99	121.06	120.66	121.04	785400.0
2001-07-27 16:00:00	SPY	ETF	121.0	121.15	120.81	120.85	262800.0
2001-07-27 09:00:00	QQQ	ETF	41.64	42.02	41.4	41.56	9532700.0
2001-07-27 10:00:00	QQQ	ETF	41.56	41.95	41.35	41.56	8268500.0
2001-07-27 11:00:00	QQQ	ETF	41.67	42.06	41.52	41.76	6825000.0
2001-07-27 12:00:00	QQQ	ETF	41.77	42.1	41.65	41.9	3892700.0
2001-07-27 13:00:00	QQQ	ETF	41.9	42.26	41.88	42.0	5695000.0
2001-07-27 14:00:00	QQQ	ETF	41.96	42.08	41.68	41.99	5113300.0
2001-07-27 15:00:00	QQQ	ETF	41.97	42.08	41.75	41.93	5358500.0
2001-07-27 16:00:00	QQQ	ETF	41.94	42.01	41.85	41.95	956600.0
2001-07-27 17:00:00	QQQ	ETF	41.92	41.93	41.88	41.9	24100.0
2001-07-27 18:00:00	QQQ	ETF	41.9	41.93	41.9	41.91	1300.0
2001-07-27 09:00:00	IWM	ETF	48.325	48.5	48.125	48.3	249000.0
2001-07-27 10:00:00	IWM	ETF	48.35	48.35	48.085	48.245	8400.0
2001-07-27 11:00:00	IWM	ETF	48.105	48.44	48.105	48.3	89600.0
2001-07-27 12:00:00	IWM	ETF	48.37	48.49	48.21	48.49	35000.0
2001-07-27 13:00:00	IWM	ETF	48.49	48.495	48.425	48.49	76400.0
2001-07-27 14:00:00	IWM	ETF	48.525	48.525	48.26	48.35	57600.0
2001-07-27 15:00:00	IWM	ETF	48.44	48.44	48.35	48.35	13800.0
2001-07-27 09:00:00	DIA	ETF	104.55	104.7	104.01	104.13	199300.0
2001-07-27 10:00:00	DIA	ETF	104.16	104.35	103.81	104.05	205600.0
2001-07-27 11:00:00	DIA	ETF	104.05	104.6	103.92	104.32	145800.0
2001-07-27 12:00:00	DIA	ETF	104.26	104.59	104.18	104.4	66000.0
2001-07-27 13:00:00	DIA	ETF	104.43	104.66	104.25	104.32	121700.0
2001-07-27 14:00:00	DIA	ETF	104.28	104.44	104.1	104.21	432500.0
2001-07-27 15:00:00	DIA	ETF	104.29	104.3	104.0	104.25	144200.0
2001-07-27 16:00:00	DIA	ETF	104.35	104.35	104.31	104.33	71100.0

> showing 33 of 217 rows — these rows as CSV

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