PREVIEW / etf_1hour / 2001-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-02-27.parquet
  size:    11 KB
  rows:    219

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-02-27 09:00:00	SPY	ETF	126.8	127.25	126.75	127.17	1414800.0
2001-02-27 10:00:00	SPY	ETF	127.05	127.6	126.0	126.61	2486200.0
2001-02-27 11:00:00	SPY	ETF	126.6	127.84	126.41	127.55	2325900.0
2001-02-27 12:00:00	SPY	ETF	127.66	127.73	126.89	127.18	847700.0
2001-02-27 13:00:00	SPY	ETF	127.15	127.21	126.27	126.38	932000.0
2001-02-27 14:00:00	SPY	ETF	126.35	126.55	125.8	126.4	1139900.0
2001-02-27 15:00:00	SPY	ETF	126.32	126.55	125.51	126.35	1410300.0
2001-02-27 16:00:00	SPY	ETF	126.32	126.55	126.25	126.4	536300.0
2001-02-27 18:00:00	SPY	ETF	126.5	126.5	126.5	126.5	200.0
2001-02-27 09:00:00	QQQ	ETF	51.54	51.72	51.19	51.49	6697700.0
2001-02-27 10:00:00	QQQ	ETF	51.54	52.05	50.13	50.45	15217400.0
2001-02-27 11:00:00	QQQ	ETF	50.5	51.37	50.37	51.25	6618000.0
2001-02-27 12:00:00	QQQ	ETF	51.21	51.36	50.63	50.67	3317000.0
2001-02-27 13:00:00	QQQ	ETF	50.69	50.8	49.95	50.03	6524100.0
2001-02-27 14:00:00	QQQ	ETF	50.05	50.15	49.55	49.99	9978600.0
2001-02-27 15:00:00	QQQ	ETF	49.94	50.0	48.9	49.15	14005000.0
2001-02-27 16:00:00	QQQ	ETF	49.15	49.24	48.6	48.7	1860000.0
2001-02-27 17:00:00	QQQ	ETF	48.75	49.2	48.6	48.74	237900.0
2001-02-27 18:00:00	QQQ	ETF	48.85	48.85	48.66	48.78	17400.0
2001-02-27 09:00:00	IWM	ETF	48.65	48.65	48.375	48.375	7600.0
2001-02-27 10:00:00	IWM	ETF	48.5	48.5	48.175	48.185	133800.0
2001-02-27 11:00:00	IWM	ETF	48.125	48.5	48.125	48.425	4800.0
2001-02-27 12:00:00	IWM	ETF	48.525	48.525	48.35	48.36	27000.0
2001-02-27 13:00:00	IWM	ETF	48.225	48.325	48.105	48.125	31000.0
2001-02-27 14:00:00	IWM	ETF	48.1	48.2	47.875	48.05	171000.0
2001-02-27 15:00:00	IWM	ETF	47.85	47.93	47.625	47.73	42600.0
2001-02-27 16:00:00	IWM	ETF	47.71	47.775	47.635	47.775	10400.0
2001-02-27 09:00:00	DIA	ETF	106.28	106.77	106.2	106.77	174000.0
2001-02-27 10:00:00	DIA	ETF	106.77	107.0	105.6	106.2	539000.0
2001-02-27 11:00:00	DIA	ETF	106.2	107.2	106.2	107.07	441400.0
2001-02-27 12:00:00	DIA	ETF	107.08	107.1	106.5	106.7	176200.0
2001-02-27 13:00:00	DIA	ETF	106.6	106.72	106.2	106.38	180000.0
2001-02-27 14:00:00	DIA	ETF	106.31	106.6	106.0	106.38	129200.0
2001-02-27 15:00:00	DIA	ETF	106.42	106.68	106.03	106.5	245300.0
2001-02-27 16:00:00	DIA	ETF	106.5	106.79	106.5	106.6	8500.0

> showing 35 of 219 rows — these rows as CSV

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