PREVIEW / etf_1hour / 2008-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-21.parquet
  size:    99 KB
  rows:    3,256

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
2008-02-21 04:00:00	SPY	ETF	136.04	136.05	136.04	136.05	200.0
2008-02-21 05:00:00	SPY	ETF	136.26	136.26	136.26	136.26	100.0
2008-02-21 06:00:00	SPY	ETF	136.45	136.75	136.45	136.7	77500.0
2008-02-21 07:00:00	SPY	ETF	136.83	136.95	136.62	136.67	1872200.0
2008-02-21 08:00:00	SPY	ETF	136.65	136.92	135.85	136.77	6751200.0
2008-02-21 09:00:00	SPY	ETF	136.74	137.01	136.46	136.67	22093216.0
2008-02-21 10:00:00	SPY	ETF	136.65	136.7	135.0	135.47	40711446.0
2008-02-21 11:00:00	SPY	ETF	135.47	136.16	135.43	136.05	22371233.0
2008-02-21 12:00:00	SPY	ETF	136.05	136.06	135.22	135.459	21010110.0
2008-02-21 13:00:00	SPY	ETF	135.46	135.51	134.65	134.96	19367820.0
2008-02-21 14:00:00	SPY	ETF	134.96	135.38	134.76	134.89	21615709.0
2008-02-21 15:00:00	SPY	ETF	134.89	134.9	134.07	134.48	37699451.0
2008-02-21 16:00:00	SPY	ETF	134.53	136.194	134.39	134.65	4572500.0
2008-02-21 17:00:00	SPY	ETF	134.63	134.64	134.46	134.56	149200.0
2008-02-21 18:00:00	SPY	ETF	134.56	134.56	134.45	134.55	37200.0
2008-02-21 19:00:00	SPY	ETF	134.52	134.6	134.47	134.47	20900.0
2008-02-21 06:00:00	QQQ	ETF	44.18	44.35	44.18	44.31	196800.0
2008-02-21 07:00:00	QQQ	ETF	44.3	44.44	44.29	44.4	1339628.0
2008-02-21 08:00:00	QQQ	ETF	44.4	44.47	44.35	44.41	6093236.0
2008-02-21 09:00:00	QQQ	ETF	44.4	44.47	44.25	44.35	20529434.0
2008-02-21 10:00:00	QQQ	ETF	44.35	44.4	43.86	43.87	21973979.0
2008-02-21 11:00:00	QQQ	ETF	43.86	44.02	43.82	43.9526	16707447.0
2008-02-21 12:00:00	QQQ	ETF	43.95	43.95	43.63	43.8	11283778.0
2008-02-21 13:00:00	QQQ	ETF	43.79	43.81	43.54	43.62	13903487.0
2008-02-21 14:00:00	QQQ	ETF	43.62	43.81	43.58	43.65	12242164.0
2008-02-21 15:00:00	QQQ	ETF	43.65	43.65	43.34	43.49	21316844.0
2008-02-21 16:00:00	QQQ	ETF	43.5	43.63	43.41	43.57	4130829.0
2008-02-21 17:00:00	QQQ	ETF	43.55	43.56	43.47	43.54	71838.0
2008-02-21 18:00:00	QQQ	ETF	43.54	43.54	43.51	43.53	54754.0
2008-02-21 19:00:00	QQQ	ETF	43.54	43.56	43.48	43.5	14056.0
2008-02-21 06:00:00	IWM	ETF	71.14	71.22	71.14	71.22	500.0
2008-02-21 07:00:00	IWM	ETF	71.27	71.38	71.23	71.27	231900.0
2008-02-21 08:00:00	IWM	ETF	71.23	71.42	71.18	71.35	1586000.0
2008-02-21 09:00:00	IWM	ETF	71.35	71.75	71.21	71.45	11121045.0
2008-02-21 10:00:00	IWM	ETF	71.44	71.56	70.57	70.57	10729977.0
2008-02-21 11:00:00	IWM	ETF	70.56	70.83	70.53	70.67	8053654.0
2008-02-21 12:00:00	IWM	ETF	70.66	70.66	70.08	70.27	12285137.0
2008-02-21 13:00:00	IWM	ETF	70.27	70.29	69.57	69.7	10587102.0
2008-02-21 14:00:00	IWM	ETF	69.71	70.01	69.62	69.71	10810587.0
2008-02-21 15:00:00	IWM	ETF	69.7	69.7	69.24	69.37	17806066.0
2008-02-21 16:00:00	IWM	ETF	69.37	70.26	69.35	69.41	2472400.0
2008-02-21 17:00:00	IWM	ETF	69.45	69.45	69.4	69.45	7400.0
2008-02-21 18:00:00	IWM	ETF	69.41	69.45	69.41	69.45	1600.0
2008-02-21 19:00:00	IWM	ETF	69.45	69.45	69.37	69.37	9300.0
2008-02-21 07:00:00	DIA	ETF	124.78	124.79	124.69	124.69	2200.0
2008-02-21 08:00:00	DIA	ETF	124.7	124.83	124.58	124.72	44400.0
2008-02-21 09:00:00	DIA	ETF	124.67	124.98	124.54	124.76	1106035.0
2008-02-21 10:00:00	DIA	ETF	124.76	124.76	123.71	123.72	2850432.0
2008-02-21 11:00:00	DIA	ETF	123.7	124.23	123.66	124.16	1484492.0
2008-02-21 12:00:00	DIA	ETF	124.16	124.16	123.29	123.51	1440437.0

> showing 50 of 3,256 rows — these rows as CSV

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