PREVIEW / etf_30min / 2008-03-28

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-28.parquet
  size:    151 KB
  rows:    5,408

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.3	133.21	133.21	7400.0
2008-03-28 04:30:00	SPY	ETF	133.47	133.47	133.47	133.47	2500.0
2008-03-28 05:00:00	SPY	ETF	133.49	133.7	133.49	133.7	1800.0
2008-03-28 05:30:00	SPY	ETF	133.7	133.7	133.7	133.7	700.0
2008-03-28 06:00:00	SPY	ETF	133.54	133.54	133.54	133.54	100.0
2008-03-28 06:30:00	SPY	ETF	133.4	133.45	133.36	133.4	38000.0
2008-03-28 07:00:00	SPY	ETF	133.4	133.5	133.37	133.42	268100.0
2008-03-28 07:30:00	SPY	ETF	133.42	133.44	133.24	133.24	530300.0
2008-03-28 08:00:00	SPY	ETF	133.27	133.68	133.2	133.37	912800.0
2008-03-28 08:30:00	SPY	ETF	133.37	133.61	132.84	133.05	3539000.0
2008-03-28 09:00:00	SPY	ETF	133.06	133.22	132.95	132.99	1542000.0
2008-03-28 09:30:00	SPY	ETF	132.99	133.25	132.59	132.9	22141922.0
2008-03-28 10:00:00	SPY	ETF	132.89	133.36	132.75	133.03	13576619.0
2008-03-28 10:30:00	SPY	ETF	133.03	133.14	132.45	132.69	12511264.0
2008-03-28 11:00:00	SPY	ETF	132.7	132.93	132.55	132.85	8004749.0
2008-03-28 11:30:00	SPY	ETF	132.85	133.12	132.82	132.99	6301920.0
2008-03-28 12:00:00	SPY	ETF	132.99	133.03	132.4122	132.71	9539461.0
2008-03-28 12:30:00	SPY	ETF	132.71	132.76	132.29	132.41	9113327.0
2008-03-28 13:00:00	SPY	ETF	132.4	132.61	132.35	132.54	7364549.0
2008-03-28 13:30:00	SPY	ETF	132.54	132.56	131.99	132.1197	10388181.0
2008-03-28 14:00:00	SPY	ETF	132.11	132.32	131.86	131.9525	8705283.0
2008-03-28 14:30:00	SPY	ETF	131.95	132.11	131.74	132.0501	9908692.0
2008-03-28 15:00:00	SPY	ETF	132.06	132.06	131.28	131.63	18191273.0
2008-03-28 15:30:00	SPY	ETF	131.63	131.72	131.06	131.4	21386148.0
2008-03-28 16:00:00	SPY	ETF	131.441	133.07	131.3	131.52	6462900.0
2008-03-28 16:30:00	SPY	ETF	131.53	132.4109	131.5	131.75	6474500.0
2008-03-28 17:00:00	SPY	ETF	131.75	131.86	131.7	131.71	142500.0
2008-03-28 17:30:00	SPY	ETF	131.8	131.81	131.8	131.81	9800.0
2008-03-28 18:00:00	SPY	ETF	131.75	131.75	131.68	131.74	5300.0
2008-03-28 18:30:00	SPY	ETF	131.74	131.77	131.7	131.77	2800.0
2008-03-28 19:00:00	SPY	ETF	131.7	131.78	131.7	131.7	8100.0
2008-03-28 19:30:00	SPY	ETF	131.7	131.78	131.7	131.78	7700.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.25	500.0
2008-03-28 05:30:00	QQQ	ETF	44.25	44.25	44.24	44.24	2100.0
2008-03-28 06:30:00	QQQ	ETF	44.19	44.21	44.14	44.15	51441.0
2008-03-28 07:00:00	QQQ	ETF	44.12	44.13	44.09	44.11	100605.0
2008-03-28 07:30:00	QQQ	ETF	44.14	44.15	44.1	44.1	9717.0
2008-03-28 08:00:00	QQQ	ETF	44.11	44.15	43.95	44.15	594160.0
2008-03-28 08:30:00	QQQ	ETF	44.16	44.23	44.03	44.05	978444.0
2008-03-28 09:00:00	QQQ	ETF	44.05	44.1	44.01	44.04	447280.0
2008-03-28 09:30:00	QQQ	ETF	44.03	44.29	43.96	44.2	17641590.0
2008-03-28 10:00:00	QQQ	ETF	44.2	44.34	44.09	44.16	9673809.0
2008-03-28 10:30:00	QQQ	ETF	44.15	44.21	43.96	44.03	6322853.0
2008-03-28 11:00:00	QQQ	ETF	44.04	44.1	43.98	44.04	3766508.0
2008-03-28 11:30:00	QQQ	ETF	44.05	44.15	44.04	44.09	4220701.0
2008-03-28 12:00:00	QQQ	ETF	44.1	44.11	43.89	43.97	5317731.0
2008-03-28 12:30:00	QQQ	ETF	43.96	43.98	43.81	43.88	7491905.0
2008-03-28 13:00:00	QQQ	ETF	43.888	43.95	43.878	43.91	3600046.0
2008-03-28 13:30:00	QQQ	ETF	43.91	43.98	43.65	43.71	6600222.0

> showing 50 of 5,408 rows — these rows as CSV

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