PREVIEW / etf_1hour / 2001-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-06.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-04-06 09:00:00	SPY	ETF	113.99	114.25	113.2	113.8	2586800.0
2001-04-06 10:00:00	SPY	ETF	113.79	113.9	112.75	113.4	2323300.0
2001-04-06 11:00:00	SPY	ETF	113.49	114.09	113.19	114.0	1965900.0
2001-04-06 12:00:00	SPY	ETF	113.99	114.4	112.15	112.9	2843600.0
2001-04-06 13:00:00	SPY	ETF	112.98	113.92	112.5	113.52	1360200.0
2001-04-06 14:00:00	SPY	ETF	113.53	113.79	112.06	112.8	1230300.0
2001-04-06 15:00:00	SPY	ETF	112.69	113.19	112.15	113.05	1755900.0
2001-04-06 16:00:00	SPY	ETF	113.15	113.43	112.95	113.3	713500.0
2001-04-06 09:00:00	QQQ	ETF	36.9	36.95	36.22	36.42	11061600.0
2001-04-06 10:00:00	QQQ	ETF	36.42	36.6	35.8	36.35	15278300.0
2001-04-06 11:00:00	QQQ	ETF	36.35	36.65	36.07	36.65	9371300.0
2001-04-06 12:00:00	QQQ	ETF	36.6	36.91	35.83	36.57	15580800.0
2001-04-06 13:00:00	QQQ	ETF	36.57	37.1	36.35	36.78	9359900.0
2001-04-06 14:00:00	QQQ	ETF	36.77	36.91	35.68	35.9	10060600.0
2001-04-06 15:00:00	QQQ	ETF	35.88	36.18	35.5	36.11	11683300.0
2001-04-06 16:00:00	QQQ	ETF	36.15	36.31	35.68	36.27	1244700.0
2001-04-06 17:00:00	QQQ	ETF	36.25	36.33	36.1	36.3	31000.0
2001-04-06 18:00:00	QQQ	ETF	36.35	36.4	36.25	36.37	8000.0
2001-04-06 09:00:00	IWM	ETF	43.75	43.75	43.4	43.45	70600.0
2001-04-06 10:00:00	IWM	ETF	43.475	43.6	43.25	43.6	91200.0
2001-04-06 11:00:00	IWM	ETF	43.7	43.89	43.63	43.63	86400.0
2001-04-06 12:00:00	IWM	ETF	43.695	43.75	43.375	43.7	37200.0
2001-04-06 13:00:00	IWM	ETF	43.675	43.75	43.675	43.675	6200.0
2001-04-06 14:00:00	IWM	ETF	43.75	43.775	43.3	43.375	35200.0
2001-04-06 15:00:00	IWM	ETF	43.5	43.525	43.125	43.25	65600.0
2001-04-06 16:00:00	IWM	ETF	43.325	43.325	43.125	43.125	13000.0
2001-04-06 09:00:00	DIA	ETF	98.5	98.65	97.7	98.4	1247700.0
2001-04-06 10:00:00	DIA	ETF	98.39	98.4	97.29	97.8	978900.0
2001-04-06 11:00:00	DIA	ETF	97.82	98.64	97.7	98.64	739100.0
2001-04-06 12:00:00	DIA	ETF	98.6	98.8	97.05	97.88	720800.0
2001-04-06 13:00:00	DIA	ETF	97.9	98.55	97.36	98.01	466200.0
2001-04-06 14:00:00	DIA	ETF	98.08	98.3	97.12	97.7	456700.0
2001-04-06 15:00:00	DIA	ETF	97.77	98.0	97.25	97.9	987000.0
2001-04-06 16:00:00	DIA	ETF	97.8	98.2	97.8	98.2	86900.0

> showing 34 of 217 rows — these rows as CSV

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