PREVIEW / etf_1hour / 2001-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-14.parquet
  size:    12 KB
  rows:    229

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-06-14 09:00:00	SPY	ETF	124.18	124.3	123.71	124.15	2039200.0
2001-06-14 10:00:00	SPY	ETF	124.12	124.24	123.3	123.42	2252300.0
2001-06-14 11:00:00	SPY	ETF	123.43	123.49	122.96	123.48	1321000.0
2001-06-14 12:00:00	SPY	ETF	123.45	123.54	123.12	123.18	458500.0
2001-06-14 13:00:00	SPY	ETF	123.14	123.3	122.8	122.88	1521000.0
2001-06-14 14:00:00	SPY	ETF	122.88	123.2	122.55	122.96	1618900.0
2001-06-14 15:00:00	SPY	ETF	122.9	123.43	122.24	122.48	2598700.0
2001-06-14 16:00:00	SPY	ETF	122.4	123.17	121.75	121.9	497200.0
2001-06-14 17:00:00	SPY	ETF	122.12	122.12	121.84	121.84	500.0
2001-06-14 09:00:00	QQQ	ETF	44.02	44.4	43.59	44.24	13254800.0
2001-06-14 10:00:00	QQQ	ETF	44.2	44.3	43.27	43.43	18906100.0
2001-06-14 11:00:00	QQQ	ETF	43.43	43.7	43.1	43.68	10509800.0
2001-06-14 12:00:00	QQQ	ETF	43.68	43.79	43.3	43.31	6776100.0
2001-06-14 13:00:00	QQQ	ETF	43.31	43.48	43.0	43.01	6978500.0
2001-06-14 14:00:00	QQQ	ETF	43.01	43.2	42.7	42.95	13021200.0
2001-06-14 15:00:00	QQQ	ETF	42.96	43.45	42.61	42.67	15332200.0
2001-06-14 16:00:00	QQQ	ETF	42.65	42.75	42.0	42.38	3251400.0
2001-06-14 17:00:00	QQQ	ETF	42.25	42.5	42.25	42.3	141700.0
2001-06-14 18:00:00	QQQ	ETF	42.35	42.35	42.2	42.3	24600.0
2001-06-14 09:00:00	IWM	ETF	49.875	50.025	49.75	49.92	125600.0
2001-06-14 10:00:00	IWM	ETF	49.915	49.95	49.58	49.595	79000.0
2001-06-14 11:00:00	IWM	ETF	49.6	49.625	49.35	49.62	122000.0
2001-06-14 12:00:00	IWM	ETF	49.64	49.64	49.505	49.52	33800.0
2001-06-14 13:00:00	IWM	ETF	49.515	49.55	49.4	49.4	97600.0
2001-06-14 14:00:00	IWM	ETF	49.4	49.425	49.25	49.395	182800.0
2001-06-14 15:00:00	IWM	ETF	49.385	49.575	49.075	49.31	205000.0
2001-06-14 16:00:00	IWM	ETF	49.205	49.205	49.075	49.075	13200.0
2001-06-14 09:00:00	DIA	ETF	108.2	108.2	107.65	108.07	676900.0
2001-06-14 10:00:00	DIA	ETF	108.16	108.16	107.55	107.7	319100.0
2001-06-14 11:00:00	DIA	ETF	107.75	107.79	107.35	107.55	251800.0
2001-06-14 12:00:00	DIA	ETF	107.5	107.59	107.15	107.15	484600.0
2001-06-14 13:00:00	DIA	ETF	107.18	107.32	106.94	107.0	430400.0
2001-06-14 14:00:00	DIA	ETF	107.01	107.4	106.71	107.2	485100.0
2001-06-14 15:00:00	DIA	ETF	107.25	107.58	106.66	106.94	598200.0
2001-06-14 16:00:00	DIA	ETF	106.92	106.94	106.53	106.6	80500.0

> showing 35 of 229 rows — these rows as CSV

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