PREVIEW / etf_1hour / 2008-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-28.parquet
  size:    97 KB
  rows:    3,241

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-28 04:00:00	SPY	ETF	133.3	133.47	133.21	133.47	9900.0
2008-03-28 05:00:00	SPY	ETF	133.49	133.7	133.49	133.7	2500.0
2008-03-28 06:00:00	SPY	ETF	133.54	133.54	133.36	133.4	38100.0
2008-03-28 07:00:00	SPY	ETF	133.4	133.5	133.24	133.24	798400.0
2008-03-28 08:00:00	SPY	ETF	133.27	133.68	132.84	133.05	4451800.0
2008-03-28 09:00:00	SPY	ETF	133.06	133.25	132.59	132.9	23683922.0
2008-03-28 10:00:00	SPY	ETF	132.89	133.36	132.45	132.69	26087883.0
2008-03-28 11:00:00	SPY	ETF	132.7	133.12	132.55	132.99	14306669.0
2008-03-28 12:00:00	SPY	ETF	132.99	133.03	132.29	132.41	18652788.0
2008-03-28 13:00:00	SPY	ETF	132.4	132.61	131.99	132.1197	17752730.0
2008-03-28 14:00:00	SPY	ETF	132.11	132.32	131.74	132.0501	18613975.0
2008-03-28 15:00:00	SPY	ETF	132.06	132.06	131.06	131.4	39577421.0
2008-03-28 16:00:00	SPY	ETF	131.441	133.07	131.3	131.75	12937400.0
2008-03-28 17:00:00	SPY	ETF	131.75	131.86	131.7	131.81	152300.0
2008-03-28 18:00:00	SPY	ETF	131.75	131.77	131.68	131.77	8100.0
2008-03-28 19:00:00	SPY	ETF	131.7	131.78	131.7	131.78	15800.0
2008-03-28 04:00:00	QQQ	ETF	44.11	44.11	44.11	44.11	200.0
2008-03-28 05:00:00	QQQ	ETF	44.2	44.25	44.18	44.24	2600.0
2008-03-28 06:00:00	QQQ	ETF	44.19	44.21	44.14	44.15	51441.0
2008-03-28 07:00:00	QQQ	ETF	44.12	44.15	44.09	44.1	110322.0
2008-03-28 08:00:00	QQQ	ETF	44.11	44.23	43.95	44.05	1572604.0
2008-03-28 09:00:00	QQQ	ETF	44.05	44.29	43.96	44.2	18088870.0
2008-03-28 10:00:00	QQQ	ETF	44.2	44.34	43.96	44.03	15996662.0
2008-03-28 11:00:00	QQQ	ETF	44.04	44.15	43.98	44.09	7987209.0
2008-03-28 12:00:00	QQQ	ETF	44.1	44.11	43.81	43.88	12809636.0
2008-03-28 13:00:00	QQQ	ETF	43.888	43.98	43.65	43.71	10200268.0
2008-03-28 14:00:00	QQQ	ETF	43.71	43.81	43.53	43.68	11506932.0
2008-03-28 15:00:00	QQQ	ETF	43.68	43.68	43.33	43.5	16821932.0
2008-03-28 16:00:00	QQQ	ETF	43.5	43.7246	43.43	43.58	7625279.0
2008-03-28 17:00:00	QQQ	ETF	43.7246	43.7246	43.58	43.6	4055636.0
2008-03-28 18:00:00	QQQ	ETF	43.62	43.62	43.59	43.6	13150.0
2008-03-28 19:00:00	QQQ	ETF	43.62	43.65	43.62	43.63	10900.0
2008-03-28 04:00:00	IWM	ETF	69.29	69.34	69.29	69.34	800.0
2008-03-28 07:00:00	IWM	ETF	69.4	69.4	69.29	69.29	35300.0
2008-03-28 08:00:00	IWM	ETF	69.59	69.59	69.01	69.14	375700.0
2008-03-28 09:00:00	IWM	ETF	69.14	69.25	68.71	69.11	5519377.0
2008-03-28 10:00:00	IWM	ETF	69.1	69.41	68.85	68.98	7877916.0
2008-03-28 11:00:00	IWM	ETF	68.97	69.28	68.87	69.2	3528085.0
2008-03-28 12:00:00	IWM	ETF	69.21	69.23	68.73	68.88	3327347.0
2008-03-28 13:00:00	IWM	ETF	68.88	69.0	68.41	68.51	6296779.0
2008-03-28 14:00:00	IWM	ETF	68.5	68.65	68.28	68.55	4136127.0
2008-03-28 15:00:00	IWM	ETF	68.54	68.56	67.97	68.1	11331892.0
2008-03-28 16:00:00	IWM	ETF	68.1	69.28	68.08	69.28	6264800.0
2008-03-28 17:00:00	IWM	ETF	68.25	68.33	68.25	68.33	500.0
2008-03-28 05:00:00	DIA	ETF	123.45	123.45	123.45	123.45	100.0
2008-03-28 07:00:00	DIA	ETF	123.68	123.68	123.68	123.68	100.0
2008-03-28 08:00:00	DIA	ETF	123.52	123.85	123.23	123.46	40600.0
2008-03-28 09:00:00	DIA	ETF	123.36	123.6	123.05	123.35	1165368.0
2008-03-28 10:00:00	DIA	ETF	123.34	123.71	122.96	123.15	1854682.0
2008-03-28 11:00:00	DIA	ETF	123.15	123.43	123.02	123.29	1075259.0

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

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