PREVIEW / etf_1hour / 2001-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-06.parquet
  size:    11 KB
  rows:    222

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-03-06 09:00:00	SPY	ETF	126.35	126.5	126.05	126.39	1300600.0
2001-03-06 10:00:00	SPY	ETF	126.4	127.3	126.26	127.0	1054700.0
2001-03-06 11:00:00	SPY	ETF	127.0	127.09	126.59	126.74	709400.0
2001-03-06 12:00:00	SPY	ETF	126.71	126.84	125.86	126.27	1203800.0
2001-03-06 13:00:00	SPY	ETF	126.39	126.84	126.14	126.54	444100.0
2001-03-06 14:00:00	SPY	ETF	126.51	126.65	125.75	126.09	717800.0
2001-03-06 15:00:00	SPY	ETF	126.16	126.42	125.6	125.87	981300.0
2001-03-06 16:00:00	SPY	ETF	125.74	126.12	125.74	126.0	325600.0
2001-03-06 17:00:00	SPY	ETF	126.0	126.0	125.93	125.93	800.0
2001-03-06 09:00:00	QQQ	ETF	49.3	50.02	49.25	49.72	9246900.0
2001-03-06 10:00:00	QQQ	ETF	49.77	50.6	49.7	50.26	12222900.0
2001-03-06 11:00:00	QQQ	ETF	50.27	50.39	49.98	50.25	7158900.0
2001-03-06 12:00:00	QQQ	ETF	50.3	50.37	49.74	50.05	4987300.0
2001-03-06 13:00:00	QQQ	ETF	50.05	50.66	49.9	50.45	6362000.0
2001-03-06 14:00:00	QQQ	ETF	50.46	50.55	49.54	49.94	6865900.0
2001-03-06 15:00:00	QQQ	ETF	49.9	50.1	49.1	49.27	10611500.0
2001-03-06 16:00:00	QQQ	ETF	49.32	49.65	48.65	49.5	1151000.0
2001-03-06 17:00:00	QQQ	ETF	49.51	49.75	49.0	49.03	212900.0
2001-03-06 18:00:00	QQQ	ETF	49.15	49.2	49.0	49.1	12600.0
2001-03-06 09:00:00	IWM	ETF	48.0	48.1	47.9	48.0	63600.0
2001-03-06 10:00:00	IWM	ETF	48.175	48.175	48.0	48.15	158400.0
2001-03-06 11:00:00	IWM	ETF	48.19	48.195	47.975	48.095	118800.0
2001-03-06 12:00:00	IWM	ETF	48.08	48.095	47.815	47.815	49800.0
2001-03-06 13:00:00	IWM	ETF	48.125	48.175	48.1	48.175	7000.0
2001-03-06 14:00:00	IWM	ETF	48.0	48.175	47.825	48.0	67800.0
2001-03-06 15:00:00	IWM	ETF	48.025	48.075	47.95	48.0	23000.0
2001-03-06 16:00:00	IWM	ETF	48.075	48.075	48.05	48.05	6200.0
2001-03-06 09:00:00	DIA	ETF	106.5	106.8	106.45	106.65	456700.0
2001-03-06 10:00:00	DIA	ETF	106.55	107.14	106.51	106.82	294400.0
2001-03-06 11:00:00	DIA	ETF	106.75	106.92	106.47	106.66	277900.0
2001-03-06 12:00:00	DIA	ETF	106.65	106.65	106.06	106.27	142600.0
2001-03-06 13:00:00	DIA	ETF	106.3	106.6	106.2	106.4	133800.0
2001-03-06 14:00:00	DIA	ETF	106.4	106.48	105.95	106.15	175500.0
2001-03-06 15:00:00	DIA	ETF	106.22	106.45	105.81	106.0	257600.0
2001-03-06 16:00:00	DIA	ETF	106.08	106.21	106.05	106.15	32800.0

> showing 35 of 222 rows — these rows as CSV

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