PREVIEW / etf_1hour / 2001-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-19.parquet
  size:    11 KB
  rows:    225

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-19 09:00:00	SPY	ETF	122.18	122.88	122.05	122.82	1596800.0
2001-07-19 10:00:00	SPY	ETF	122.86	122.98	122.26	122.64	1715600.0
2001-07-19 11:00:00	SPY	ETF	122.64	122.93	122.03	122.16	920900.0
2001-07-19 12:00:00	SPY	ETF	122.16	122.16	121.63	121.95	1051200.0
2001-07-19 13:00:00	SPY	ETF	121.95	122.39	121.83	122.0	494300.0
2001-07-19 14:00:00	SPY	ETF	122.04	122.1	121.2	121.37	1033200.0
2001-07-19 15:00:00	SPY	ETF	121.33	121.84	120.76	121.83	1871800.0
2001-07-19 16:00:00	SPY	ETF	121.87	122.13	121.32	121.37	987900.0
2001-07-19 17:00:00	SPY	ETF	121.36	121.5	121.15	121.15	60000.0
2001-07-19 18:00:00	SPY	ETF	121.0	121.0	121.0	121.0	100.0
2001-07-19 09:00:00	QQQ	ETF	42.46	43.17	42.4	43.1	10418200.0
2001-07-19 10:00:00	QQQ	ETF	43.1	43.22	42.75	43.1	11679600.0
2001-07-19 11:00:00	QQQ	ETF	43.08	43.35	42.85	42.89	9171700.0
2001-07-19 12:00:00	QQQ	ETF	42.89	42.92	42.54	42.73	8108700.0
2001-07-19 13:00:00	QQQ	ETF	42.7	42.94	42.4	42.49	7134100.0
2001-07-19 14:00:00	QQQ	ETF	42.49	42.49	42.0	42.07	8907700.0
2001-07-19 15:00:00	QQQ	ETF	42.1	42.27	41.75	42.25	13273800.0
2001-07-19 16:00:00	QQQ	ETF	42.25	42.75	41.7	41.8	4078800.0
2001-07-19 17:00:00	QQQ	ETF	41.83	41.83	41.43	41.6	1137800.0
2001-07-19 18:00:00	QQQ	ETF	41.63	41.8	41.49	41.58	93600.0
2001-07-19 09:00:00	IWM	ETF	48.6	48.9	48.6	48.86	11200.0
2001-07-19 10:00:00	IWM	ETF	48.85	48.87	48.7	48.845	11600.0
2001-07-19 11:00:00	IWM	ETF	48.845	49.085	48.755	48.805	25400.0
2001-07-19 12:00:00	IWM	ETF	48.785	48.82	48.64	48.64	17400.0
2001-07-19 13:00:00	IWM	ETF	48.72	48.75	48.625	48.625	23600.0
2001-07-19 14:00:00	IWM	ETF	48.6	48.6	48.4	48.425	26200.0
2001-07-19 15:00:00	IWM	ETF	48.35	48.65	48.25	48.56	207600.0
2001-07-19 16:00:00	IWM	ETF	48.62	48.675	48.5	48.5	93000.0
2001-07-19 09:00:00	DIA	ETF	106.78	106.99	106.53	106.83	179800.0
2001-07-19 10:00:00	DIA	ETF	106.86	106.99	106.62	106.82	230900.0
2001-07-19 11:00:00	DIA	ETF	106.8	107.0	106.4	106.48	209100.0
2001-07-19 12:00:00	DIA	ETF	106.42	106.48	106.01	106.3	159100.0
2001-07-19 13:00:00	DIA	ETF	106.33	106.69	106.3	106.39	90000.0
2001-07-19 14:00:00	DIA	ETF	106.24	106.48	105.81	105.89	259200.0
2001-07-19 15:00:00	DIA	ETF	105.83	106.21	105.4	106.21	426000.0
2001-07-19 16:00:00	DIA	ETF	106.24	106.45	106.15	106.45	62700.0

> showing 36 of 225 rows — these rows as CSV

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