PREVIEW / etf_1hour / 2008-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-26.parquet
  size:    100 KB
  rows:    3,405

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-03-26 04:00:00	SPY	ETF	134.1	134.22	134.1	134.22	1100.0
2008-03-26 05:00:00	SPY	ETF	134.52	134.52	134.35	134.35	7600.0
2008-03-26 06:00:00	SPY	ETF	134.45	134.7	134.23	134.29	108100.0
2008-03-26 07:00:00	SPY	ETF	134.33	134.58	134.12	134.17	803900.0
2008-03-26 08:00:00	SPY	ETF	134.17	134.6	134.1	134.36	6083500.0
2008-03-26 09:00:00	SPY	ETF	134.34	134.47	133.84	134.14	23707715.0
2008-03-26 10:00:00	SPY	ETF	134.14	134.54	133.45	133.78	41486647.0
2008-03-26 11:00:00	SPY	ETF	133.78	134.19	133.6	133.99	17923342.0
2008-03-26 12:00:00	SPY	ETF	133.99	135.0884	133.6	133.72	14667225.0
2008-03-26 13:00:00	SPY	ETF	133.72	133.91	133.5	133.66	15373469.0
2008-03-26 14:00:00	SPY	ETF	133.66	134.58	133.5	134.56	20856291.0
2008-03-26 15:00:00	SPY	ETF	134.56	134.59	133.6	133.83	40286623.0
2008-03-26 16:00:00	SPY	ETF	133.82	134.56	133.11	133.25	7747600.0
2008-03-26 17:00:00	SPY	ETF	133.26	133.34	133.15	133.15	174500.0
2008-03-26 18:00:00	SPY	ETF	133.19	133.19	132.92	133.05	233100.0
2008-03-26 19:00:00	SPY	ETF	133.09	133.25	133.03	133.25	23200.0
2008-03-26 06:00:00	QQQ	ETF	44.68	44.68	44.68	44.68	100.0
2008-03-26 07:00:00	QQQ	ETF	44.65	44.7	44.56	44.6	294444.0
2008-03-26 08:00:00	QQQ	ETF	44.59	44.8681	44.55	44.61	8942379.0
2008-03-26 09:00:00	QQQ	ETF	44.62	44.73	44.42	44.51	14048740.0
2008-03-26 10:00:00	QQQ	ETF	44.51	44.66	44.28	44.4801	23137053.0
2008-03-26 11:00:00	QQQ	ETF	44.48	44.61	44.39	44.5	8069125.0
2008-03-26 12:00:00	QQQ	ETF	44.51	44.53	44.42	44.48	5134934.0
2008-03-26 13:00:00	QQQ	ETF	44.4701	44.55	44.35	44.43	7043562.0
2008-03-26 14:00:00	QQQ	ETF	44.43	44.81	44.36	44.8	13881860.0
2008-03-26 15:00:00	QQQ	ETF	44.81	44.85	44.51	44.66	21161473.0
2008-03-26 16:00:00	QQQ	ETF	44.67	44.7	44.24	44.3	21692834.0
2008-03-26 17:00:00	QQQ	ETF	44.3	44.39	44.23	44.24	1000423.0
2008-03-26 18:00:00	QQQ	ETF	44.26	44.26	44.19	44.24	172436.0
2008-03-26 19:00:00	QQQ	ETF	44.25	44.28	44.25	44.28	30988.0
2008-03-26 04:00:00	IWM	ETF	69.96	69.96	69.96	69.96	100.0
2008-03-26 07:00:00	IWM	ETF	69.97	70.0	69.87	69.89	60900.0
2008-03-26 08:00:00	IWM	ETF	69.89	70.11	69.7	69.95	999100.0
2008-03-26 09:00:00	IWM	ETF	69.93	69.96	69.49	69.65	5516680.0
2008-03-26 10:00:00	IWM	ETF	69.65	69.87	69.34	69.57	7544574.0
2008-03-26 11:00:00	IWM	ETF	69.58	69.75	69.4	69.67	5690130.0
2008-03-26 12:00:00	IWM	ETF	69.67	69.76	69.42	69.5	3788899.0
2008-03-26 13:00:00	IWM	ETF	69.49	69.66	69.44	69.66	6200318.0
2008-03-26 14:00:00	IWM	ETF	69.65	70.18	69.57	70.17	9305910.0
2008-03-26 15:00:00	IWM	ETF	70.18	70.27	69.78	70.01	20535239.0
2008-03-26 16:00:00	IWM	ETF	70.02	70.02	69.4	69.6	2372200.0
2008-03-26 17:00:00	IWM	ETF	69.62	69.62	69.5	69.5	5800.0
2008-03-26 18:00:00	IWM	ETF	69.5	69.5	69.45	69.46	2200.0
2008-03-26 19:00:00	IWM	ETF	69.53	69.58	69.51	69.58	2500.0
2008-03-26 07:00:00	DIA	ETF	124.83	124.83	124.61	124.63	3000.0
2008-03-26 08:00:00	DIA	ETF	124.66	124.9	124.52	124.68	46100.0
2008-03-26 09:00:00	DIA	ETF	124.69	124.8	124.06	124.22	1872906.0
2008-03-26 10:00:00	DIA	ETF	124.24	124.51	123.68	123.92	2719976.0
2008-03-26 11:00:00	DIA	ETF	123.91	124.29	123.76	124.11	1100510.0
2008-03-26 12:00:00	DIA	ETF	124.11	124.26	123.82	123.96	867605.0

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

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