PREVIEW / etf_30min / 2008-12-08

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-08.parquet
  size:    194 KB
  rows:    6,897

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-12-08 04:00:00	SPY	ETF	89.96	89.99	89.9	89.96	2700.0
2008-12-08 04:30:00	SPY	ETF	89.99	90.01	89.66	89.66	1996.0
2008-12-08 05:00:00	SPY	ETF	89.68	89.69	89.33	89.48	20600.0
2008-12-08 05:30:00	SPY	ETF	89.39	89.86	89.39	89.86	6182.0
2008-12-08 06:00:00	SPY	ETF	89.88	90.25	89.81	89.95	15300.0
2008-12-08 06:30:00	SPY	ETF	89.9	90.35	89.9	90.35	91832.0
2008-12-08 07:00:00	SPY	ETF	90.39	90.43	90.0	90.1	492098.0
2008-12-08 07:30:00	SPY	ETF	90.1	90.53	89.9	90.34	855654.0
2008-12-08 08:00:00	SPY	ETF	90.35	90.94	89.55	90.72	2330067.0
2008-12-08 08:30:00	SPY	ETF	90.73	91.04	90.51	90.57	2843839.0
2008-12-08 09:00:00	SPY	ETF	90.57	90.59	90.25	90.35	3467515.0
2008-12-08 09:30:00	SPY	ETF	90.34	91.23	90.02	90.34	47581132.0
2008-12-08 10:00:00	SPY	ETF	90.34	91.0	90.09	90.81	34765657.0
2008-12-08 10:30:00	SPY	ETF	90.81	91.64	90.68	91.4625	29615897.0
2008-12-08 11:00:00	SPY	ETF	91.45	91.62	91.0	91.1	20038643.0
2008-12-08 11:30:00	SPY	ETF	91.1	91.41	90.31	90.47	22486975.0
2008-12-08 12:00:00	SPY	ETF	90.48	90.96	90.15	90.86	18070876.0
2008-12-08 12:30:00	SPY	ETF	90.86	90.98	90.18	90.38	12777321.0
2008-12-08 13:00:00	SPY	ETF	90.39	90.92	90.16	90.47	17786232.0
2008-12-08 13:30:00	SPY	ETF	90.47	90.52	89.8	90.26	25137619.0
2008-12-08 14:00:00	SPY	ETF	90.29	91.41	90.19	91.18	23577405.0
2008-12-08 14:30:00	SPY	ETF	91.18	91.97	90.87	91.97	28308427.0
2008-12-08 15:00:00	SPY	ETF	91.96	92.31	91.65	92.1	36390852.0
2008-12-08 15:30:00	SPY	ETF	92.1	92.38	90.64	91.25	67415060.0
2008-12-08 16:00:00	SPY	ETF	91.2	91.5	90.7407	91.02	13997070.0
2008-12-08 16:30:00	SPY	ETF	91.09	91.25	90.3	90.43	2422526.0
2008-12-08 17:00:00	SPY	ETF	90.46	90.56	90.32	90.47	1353314.0
2008-12-08 17:30:00	SPY	ETF	90.47	90.5	90.35	90.4	83544.0
2008-12-08 18:00:00	SPY	ETF	90.39	90.52	90.26	90.5	157620.0
2008-12-08 18:30:00	SPY	ETF	90.5	90.64	90.34	90.34	76947.0
2008-12-08 19:00:00	SPY	ETF	90.36	90.66	90.31	90.64	28955.0
2008-12-08 19:30:00	SPY	ETF	90.67	90.75	90.51	90.57	58309.0
2008-12-08 04:00:00	QQQ	ETF	29.65	29.65	29.63	29.63	1147.0
2008-12-08 04:30:00	QQQ	ETF	29.59	29.59	29.5	29.5	900.0
2008-12-08 05:00:00	QQQ	ETF	29.45	29.45	29.45	29.45	100.0
2008-12-08 06:00:00	QQQ	ETF	29.54	29.62	29.54	29.58	3450.0
2008-12-08 06:30:00	QQQ	ETF	29.52	29.64	29.52	29.64	1881.0
2008-12-08 07:00:00	QQQ	ETF	29.68	29.68	29.58	29.61	119473.0
2008-12-08 07:30:00	QQQ	ETF	29.59	29.84	29.53	29.8	95547.0
2008-12-08 08:00:00	QQQ	ETF	29.79	29.91	29.72	29.9	695400.0
2008-12-08 08:30:00	QQQ	ETF	29.89	29.94	29.72	29.74	1751228.0
2008-12-08 09:00:00	QQQ	ETF	29.73	29.73	29.52	29.56	858199.0
2008-12-08 09:30:00	QQQ	ETF	29.55	29.79	29.44	29.59	20778846.0
2008-12-08 10:00:00	QQQ	ETF	29.58	29.93	29.54	29.89	14458938.0
2008-12-08 10:30:00	QQQ	ETF	29.9	30.18	29.85	29.95	18496857.0
2008-12-08 11:00:00	QQQ	ETF	29.952	30.04	29.89	29.95	5871369.0
2008-12-08 11:30:00	QQQ	ETF	29.95	30.09	29.82	29.92	20536006.0
2008-12-08 12:00:00	QQQ	ETF	29.91	30.04	29.82	30.0085	4518961.0
2008-12-08 12:30:00	QQQ	ETF	30.01	30.05	29.86	29.91	3676917.0
2008-12-08 13:00:00	QQQ	ETF	29.91	30.09	29.87	29.95	6165337.0

> showing 50 of 6,897 rows — these rows as CSV

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