PREVIEW / etf_1hour / 2004-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-11.parquet
  size:    26 KB
  rows:    728

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
2004-03-11 08:00:00	SPY	ETF	112.11	112.11	111.84	112.06	930900.0
2004-03-11 09:00:00	SPY	ETF	112.05	112.79	112.02	112.7	7092700.0
2004-03-11 10:00:00	SPY	ETF	112.66	112.95	112.39	112.55	5313200.0
2004-03-11 11:00:00	SPY	ETF	112.56	112.77	112.24	112.69	5039900.0
2004-03-11 12:00:00	SPY	ETF	112.69	113.24	112.62	113.23	6980800.0
2004-03-11 13:00:00	SPY	ETF	113.23	113.27	112.8	112.84	4366500.0
2004-03-11 14:00:00	SPY	ETF	112.84	113.18	112.3	112.42	9827300.0
2004-03-11 15:00:00	SPY	ETF	112.45	112.68	111.15	111.33	15892600.0
2004-03-11 16:00:00	SPY	ETF	111.35	111.41	111.04	111.25	5583000.0
2004-03-11 17:00:00	SPY	ETF	111.23	112.98	111.17	111.2	228000.0
2004-03-11 18:00:00	SPY	ETF	111.17	111.23	111.0	111.0	77900.0
2004-03-11 19:00:00	SPY	ETF	111.05	111.2	110.99	111.19	44600.0
2004-03-11 08:00:00	QQQ	ETF	35.0	35.0	34.89	34.97	529500.0
2004-03-11 09:00:00	QQQ	ETF	34.98	35.37	34.97	35.265	15932300.0
2004-03-11 10:00:00	QQQ	ETF	35.27	35.47	35.18	35.233	14293500.0
2004-03-11 11:00:00	QQQ	ETF	35.23	35.32	35.08	35.31	12319500.0
2004-03-11 12:00:00	QQQ	ETF	35.31	35.53	35.249	35.506	13423600.0
2004-03-11 13:00:00	QQQ	ETF	35.5	35.53	35.32	35.35	9581400.0
2004-03-11 14:00:00	QQQ	ETF	35.35	35.53	35.225	35.297	13943900.0
2004-03-11 15:00:00	QQQ	ETF	35.3	35.38	34.86	34.9	25178500.0
2004-03-11 16:00:00	QQQ	ETF	34.9	34.95	34.8	34.91	4919900.0
2004-03-11 17:00:00	QQQ	ETF	34.9	34.913	34.85	34.89	421900.0
2004-03-11 18:00:00	QQQ	ETF	34.88	34.89	34.82	34.82	165100.0
2004-03-11 19:00:00	QQQ	ETF	34.83	34.88	34.8	34.88	54800.0
2004-03-11 08:00:00	IWM	ETF	56.625	56.7	56.555	56.7	2600.0
2004-03-11 09:00:00	IWM	ETF	56.8	57.225	56.685	57.19	2727600.0
2004-03-11 10:00:00	IWM	ETF	57.165	57.475	56.955	57.225	1943000.0
2004-03-11 11:00:00	IWM	ETF	57.225	57.395	57.065	57.375	1451200.0
2004-03-11 12:00:00	IWM	ETF	57.35	57.91	57.325	57.9	1996600.0
2004-03-11 13:00:00	IWM	ETF	57.905	58.0	57.53	57.53	1935200.0
2004-03-11 14:00:00	IWM	ETF	57.54	57.775	57.25	57.37	1436800.0
2004-03-11 15:00:00	IWM	ETF	57.375	57.5	56.54	56.625	3386400.0
2004-03-11 16:00:00	IWM	ETF	56.645	56.675	56.505	56.505	238600.0
2004-03-11 17:00:00	IWM	ETF	56.63	56.63	56.63	56.63	1400.0
2004-03-11 18:00:00	IWM	ETF	56.95	56.95	56.95	56.95	200.0
2004-03-11 08:00:00	DIA	ETF	102.31	102.33	102.12	102.31	73200.0
2004-03-11 09:00:00	DIA	ETF	102.31	102.87	102.31	102.76	1050700.0
2004-03-11 10:00:00	DIA	ETF	102.75	103.02	102.53	102.83	988300.0
2004-03-11 11:00:00	DIA	ETF	102.83	103.04	102.55	102.93	1106200.0
2004-03-11 12:00:00	DIA	ETF	102.92	103.45	102.84	103.43	1121400.0
2004-03-11 13:00:00	DIA	ETF	103.43	103.47	102.95	102.98	1350900.0
2004-03-11 14:00:00	DIA	ETF	102.99	103.37	102.5	102.63	1555000.0
2004-03-11 15:00:00	DIA	ETF	102.67	102.87	101.4	101.52	2646400.0
2004-03-11 16:00:00	DIA	ETF	101.55	101.58	101.35	101.48	292400.0
2004-03-11 17:00:00	DIA	ETF	101.48	101.5	101.47	101.5	5900.0
2004-03-11 18:00:00	DIA	ETF	101.47	101.5	101.43	101.5	1500.0
2004-03-11 19:00:00	DIA	ETF	101.45	101.5	101.4	101.5	4000.0
2004-03-11 09:00:00	TLT	ETF	91.05	91.05	91.0	91.0	68900.0
2004-03-11 10:00:00	TLT	ETF	90.97	90.97	90.57	90.76	234700.0
2004-03-11 11:00:00	TLT	ETF	90.78	90.86	90.74	90.77	44700.0

> showing 50 of 728 rows — these rows as CSV

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