PREVIEW / etf_1hour / 2001-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-27.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-04-27 09:00:00	SPY	ETF	124.92	125.0	124.2	124.55	1244400.0
2001-04-27 10:00:00	SPY	ETF	124.49	125.17	124.46	124.7	1676300.0
2001-04-27 11:00:00	SPY	ETF	124.6	125.04	124.21	124.72	710300.0
2001-04-27 12:00:00	SPY	ETF	124.82	124.94	124.54	124.76	417100.0
2001-04-27 13:00:00	SPY	ETF	124.78	125.15	124.69	125.06	623300.0
2001-04-27 14:00:00	SPY	ETF	124.95	125.07	124.42	124.68	791700.0
2001-04-27 15:00:00	SPY	ETF	124.59	125.68	124.41	125.55	1471300.0
2001-04-27 16:00:00	SPY	ETF	125.68	126.39	125.5	126.39	860000.0
2001-04-27 17:00:00	SPY	ETF	126.33	126.39	126.33	126.39	500.0
2001-04-27 09:00:00	QQQ	ETF	45.15	45.35	44.5	44.97	10230300.0
2001-04-27 10:00:00	QQQ	ETF	44.95	45.47	44.64	44.64	11817000.0
2001-04-27 11:00:00	QQQ	ETF	44.68	45.1	44.45	44.93	5743600.0
2001-04-27 12:00:00	QQQ	ETF	44.94	45.04	44.52	44.77	5381900.0
2001-04-27 13:00:00	QQQ	ETF	44.82	45.2	44.72	45.1	3652600.0
2001-04-27 14:00:00	QQQ	ETF	45.05	45.1	44.33	44.46	5873900.0
2001-04-27 15:00:00	QQQ	ETF	44.49	45.15	44.24	45.11	9338400.0
2001-04-27 16:00:00	QQQ	ETF	45.12	45.3	44.52	45.2	1214800.0
2001-04-27 17:00:00	QQQ	ETF	45.24	45.37	45.22	45.27	30100.0
2001-04-27 18:00:00	QQQ	ETF	45.27	45.35	45.22	45.32	10800.0
2001-04-27 09:00:00	IWM	ETF	48.125	48.22	47.95	48.0	27600.0
2001-04-27 10:00:00	IWM	ETF	48.1	48.15	47.95	48.1	434200.0
2001-04-27 11:00:00	IWM	ETF	48.125	48.15	47.97	48.15	309400.0
2001-04-27 12:00:00	IWM	ETF	48.25	48.275	48.105	48.25	205600.0
2001-04-27 13:00:00	IWM	ETF	48.245	48.245	48.05	48.195	320000.0
2001-04-27 14:00:00	IWM	ETF	48.05	48.2	47.975	48.0	138600.0
2001-04-27 15:00:00	IWM	ETF	48.195	48.45	48.075	48.375	156800.0
2001-04-27 16:00:00	IWM	ETF	48.45	48.45	48.45	48.45	100000.0
2001-04-27 09:00:00	DIA	ETF	107.65	107.95	107.3	107.5	922300.0
2001-04-27 10:00:00	DIA	ETF	107.5	108.07	107.45	107.63	573800.0
2001-04-27 11:00:00	DIA	ETF	107.58	107.82	107.33	107.55	545900.0
2001-04-27 12:00:00	DIA	ETF	107.6	107.74	107.45	107.45	223700.0
2001-04-27 13:00:00	DIA	ETF	107.5	107.98	107.5	107.8	111900.0
2001-04-27 14:00:00	DIA	ETF	107.84	107.84	107.1	107.45	160100.0
2001-04-27 15:00:00	DIA	ETF	107.37	108.2	107.27	108.14	309800.0
2001-04-27 16:00:00	DIA	ETF	108.1	108.4	107.92	108.4	73100.0
2001-04-27 17:00:00	DIA	ETF	108.4	108.4	108.4	108.4	400.0

> showing 36 of 222 rows — these rows as CSV

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