PREVIEW / etf_1hour / 2008-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-26.parquet
  size:    101 KB
  rows:    3,340

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-26 04:00:00	SPY	ETF	137.33	137.33	137.33	137.33	200.0
2008-02-26 05:00:00	SPY	ETF	137.52	137.52	137.52	137.52	200.0
2008-02-26 06:00:00	SPY	ETF	137.4	137.43	137.29	137.34	15700.0
2008-02-26 07:00:00	SPY	ETF	137.3	137.52	137.18	137.19	224000.0
2008-02-26 08:00:00	SPY	ETF	137.25	137.4	136.63	136.95	6987100.0
2008-02-26 09:00:00	SPY	ETF	136.95	137.27	136.63	136.89	19591244.0
2008-02-26 10:00:00	SPY	ETF	136.87	137.5	136.5	137.19	33790616.0
2008-02-26 11:00:00	SPY	ETF	137.19	138.1	137.13	138.09	26052250.0
2008-02-26 12:00:00	SPY	ETF	138.07	138.81	137.98	138.708	29035441.0
2008-02-26 13:00:00	SPY	ETF	138.69	138.95	138.19	138.24	17869366.0
2008-02-26 14:00:00	SPY	ETF	138.25	138.84	138.14	138.72	14064782.0
2008-02-26 15:00:00	SPY	ETF	138.71	138.9	137.65	138.35	38984204.0
2008-02-26 16:00:00	SPY	ETF	138.31	138.82	137.38	138.36	19403695.0
2008-02-26 17:00:00	SPY	ETF	138.37	138.52	138.33	138.42	384100.0
2008-02-26 18:00:00	SPY	ETF	138.4	138.4	138.25	138.25	100000.0
2008-02-26 19:00:00	SPY	ETF	138.29	138.42	138.28	138.38	14200.0
2008-02-26 05:00:00	QQQ	ETF	44.06	44.07	44.06	44.07	200.0
2008-02-26 06:00:00	QQQ	ETF	44.0	44.03	44.0	44.03	200.0
2008-02-26 07:00:00	QQQ	ETF	44.02	44.05	43.98	43.99	267268.0
2008-02-26 08:00:00	QQQ	ETF	43.99	44.0	43.64	43.7	2331309.0
2008-02-26 09:00:00	QQQ	ETF	43.7	43.8501	43.6	43.6	13519871.0
2008-02-26 10:00:00	QQQ	ETF	43.61	43.85	43.37	43.68	37177141.0
2008-02-26 11:00:00	QQQ	ETF	43.69	44.07	43.65	44.06	22315914.0
2008-02-26 12:00:00	QQQ	ETF	44.07	44.34	43.95	44.28	20276098.0
2008-02-26 13:00:00	QQQ	ETF	44.29	44.48	44.17	44.2	14953387.0
2008-02-26 14:00:00	QQQ	ETF	44.21	44.42	44.16	44.38	8671557.0
2008-02-26 15:00:00	QQQ	ETF	44.38	44.38	43.87	44.09	25796133.0
2008-02-26 16:00:00	QQQ	ETF	44.08	44.143	43.926	44.12	2714763.0
2008-02-26 17:00:00	QQQ	ETF	44.11	44.15	44.08	44.14	286834.0
2008-02-26 18:00:00	QQQ	ETF	44.14	44.14	44.08	44.08	31119.0
2008-02-26 19:00:00	QQQ	ETF	44.1	44.14	44.09	44.13	32830.0
2008-02-26 07:00:00	IWM	ETF	70.8	70.82	70.7	70.75	22800.0
2008-02-26 08:00:00	IWM	ETF	70.73	70.73	70.3	70.48	492400.0
2008-02-26 09:00:00	IWM	ETF	70.42	71.14	70.27	70.85	14480417.0
2008-02-26 10:00:00	IWM	ETF	70.84	71.28	70.58	71.03	15581748.0
2008-02-26 11:00:00	IWM	ETF	71.04	71.85	71.0	71.8	13825855.0
2008-02-26 12:00:00	IWM	ETF	71.79	72.08	71.3	72.05	15027371.0
2008-02-26 13:00:00	IWM	ETF	72.05	72.2	71.71	71.74	7990412.0
2008-02-26 14:00:00	IWM	ETF	71.76	72.08	71.61	71.95	7868708.0
2008-02-26 15:00:00	IWM	ETF	71.95	71.95	71.26	71.44	13113746.0
2008-02-26 16:00:00	IWM	ETF	71.44	72.0	70.8	71.35	5519100.0
2008-02-26 17:00:00	IWM	ETF	71.41	71.63	71.41	71.53	10300.0
2008-02-26 18:00:00	IWM	ETF	71.4	71.4	71.4	71.4	100.0
2008-02-26 07:00:00	DIA	ETF	125.68	125.68	125.68	125.68	500.0
2008-02-26 08:00:00	DIA	ETF	125.6	125.82	125.06	125.27	131100.0
2008-02-26 09:00:00	DIA	ETF	125.28	125.61	125.08	125.36	977560.0
2008-02-26 10:00:00	DIA	ETF	125.36	126.03	125.11	125.83	3136191.0
2008-02-26 11:00:00	DIA	ETF	125.83	126.65	125.78	126.61	1812471.0
2008-02-26 12:00:00	DIA	ETF	126.62	127.17	126.54	127.14	2303930.0
2008-02-26 13:00:00	DIA	ETF	127.13	127.33	126.69	126.76	1315899.0

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

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