PREVIEW / etf_1hour / 2001-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-03-27.parquet
  size:    11 KB
  rows:    226

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-27 09:00:00	SPY	ETF	115.62	116.0	115.28	115.93	1529500.0
2001-03-27 10:00:00	SPY	ETF	115.88	117.5	115.52	117.16	3413100.0
2001-03-27 11:00:00	SPY	ETF	117.16	117.38	116.85	117.12	1264500.0
2001-03-27 12:00:00	SPY	ETF	117.05	117.93	117.05	117.71	1409200.0
2001-03-27 13:00:00	SPY	ETF	117.72	117.84	117.32	117.4	795600.0
2001-03-27 14:00:00	SPY	ETF	117.48	117.99	117.29	117.48	1226900.0
2001-03-27 15:00:00	SPY	ETF	117.4	118.65	117.37	118.37	2136200.0
2001-03-27 16:00:00	SPY	ETF	118.54	118.54	117.06	117.75	592500.0
2001-03-27 17:00:00	SPY	ETF	117.75	117.79	117.42	117.54	10700.0
2001-03-27 18:00:00	SPY	ETF	117.43	117.54	117.43	117.47	800.0
2001-03-27 09:00:00	QQQ	ETF	41.8	42.1	41.42	41.9	6911600.0
2001-03-27 10:00:00	QQQ	ETF	41.9	43.69	41.8	43.4	16844800.0
2001-03-27 11:00:00	QQQ	ETF	43.39	43.6	42.98	43.31	10894300.0
2001-03-27 12:00:00	QQQ	ETF	43.3	43.71	43.0	43.39	5740800.0
2001-03-27 13:00:00	QQQ	ETF	43.4	43.45	42.85	42.9	5364500.0
2001-03-27 14:00:00	QQQ	ETF	42.9	43.4	42.69	42.72	6866400.0
2001-03-27 15:00:00	QQQ	ETF	42.7	43.33	42.57	43.25	11373200.0
2001-03-27 16:00:00	QQQ	ETF	43.2	43.3	42.6	42.65	3107400.0
2001-03-27 17:00:00	QQQ	ETF	42.65	43.25	42.2	42.53	742400.0
2001-03-27 18:00:00	QQQ	ETF	42.5	42.59	42.44	42.59	36400.0
2001-03-27 09:00:00	IWM	ETF	44.8	44.8	44.25	44.375	62000.0
2001-03-27 10:00:00	IWM	ETF	44.35	44.95	44.05	44.925	307400.0
2001-03-27 11:00:00	IWM	ETF	44.8	44.85	44.675	44.7	32800.0
2001-03-27 12:00:00	IWM	ETF	44.65	44.925	44.65	44.8	85600.0
2001-03-27 13:00:00	IWM	ETF	44.625	44.845	44.625	44.625	25200.0
2001-03-27 14:00:00	IWM	ETF	44.92	44.92	44.725	44.75	57200.0
2001-03-27 15:00:00	IWM	ETF	44.925	45.3	44.705	45.085	62200.0
2001-03-27 09:00:00	DIA	ETF	96.7	97.15	96.4	96.98	738500.0
2001-03-27 10:00:00	DIA	ETF	97.0	98.28	96.6	98.06	1561200.0
2001-03-27 11:00:00	DIA	ETF	98.06	98.25	97.81	98.1	620100.0
2001-03-27 12:00:00	DIA	ETF	98.1	98.96	98.08	98.79	651000.0
2001-03-27 13:00:00	DIA	ETF	98.77	98.93	98.44	98.63	604200.0
2001-03-27 14:00:00	DIA	ETF	98.57	99.04	98.4	98.72	597600.0
2001-03-27 15:00:00	DIA	ETF	98.7	99.6	98.55	99.4	1782700.0
2001-03-27 16:00:00	DIA	ETF	99.31	99.38	98.37	99.02	253200.0
2001-03-27 17:00:00	DIA	ETF	99.19	99.19	98.81	99.14	7200.0
2001-03-27 18:00:00	DIA	ETF	99.0	99.0	98.45	98.93	4100.0

> showing 37 of 226 rows — these rows as CSV

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