PREVIEW / etf_30min / 2008-11-12

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-12.parquet
  size:    180 KB
  rows:    6,452

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-11-12 04:00:00	SPY	ETF	90.0	90.03	90.0	90.03	300.0
2008-11-12 04:30:00	SPY	ETF	90.13	90.13	89.6	89.6	2400.0
2008-11-12 05:00:00	SPY	ETF	89.7	89.7	89.5	89.65	8349.0
2008-11-12 05:30:00	SPY	ETF	89.68	89.69	89.68	89.69	200.0
2008-11-12 06:00:00	SPY	ETF	89.8	90.33	89.79	90.31	36500.0
2008-11-12 06:30:00	SPY	ETF	90.2	90.56	90.12	90.56	11400.0
2008-11-12 07:00:00	SPY	ETF	90.6	90.75	90.14	90.19	736876.0
2008-11-12 07:30:00	SPY	ETF	90.2	90.26	89.16	89.25	754057.0
2008-11-12 08:00:00	SPY	ETF	89.27	90.9	88.92	89.33	2690052.0
2008-11-12 08:30:00	SPY	ETF	89.34	89.4	88.54	88.74	2943112.0
2008-11-12 09:00:00	SPY	ETF	88.76	88.78	87.96	88.23	3921763.0
2008-11-12 09:30:00	SPY	ETF	88.23	88.95	87.91	88.4975	46847583.0
2008-11-12 10:00:00	SPY	ETF	88.49	89.77	87.76	87.79	35198886.0
2008-11-12 10:30:00	SPY	ETF	87.79	88.01	86.97	87.46	48639880.0
2008-11-12 11:00:00	SPY	ETF	87.46	87.68	86.83	87.6	30179228.0
2008-11-12 11:30:00	SPY	ETF	87.6	87.76	86.81	87.39	21342261.0
2008-11-12 12:00:00	SPY	ETF	87.4	87.68	86.92	87.5	18714570.0
2008-11-12 12:30:00	SPY	ETF	87.5	87.91	87.08	87.82	22031873.0
2008-11-12 13:00:00	SPY	ETF	87.815	87.97	86.97	87.27	15388838.0
2008-11-12 13:30:00	SPY	ETF	87.26	87.31	86.5	86.69	17572557.0
2008-11-12 14:00:00	SPY	ETF	86.68	87.35	86.27	86.81	22138176.0
2008-11-12 14:30:00	SPY	ETF	86.81	87.26	86.1	86.31	28621729.0
2008-11-12 15:00:00	SPY	ETF	86.3	90.1516	85.54	85.73	38011143.0
2008-11-12 15:30:00	SPY	ETF	85.74	86.34	85.12	85.68	69259411.0
2008-11-12 16:00:00	SPY	ETF	85.66	88.02	85.45	85.8	22624073.0
2008-11-12 16:30:00	SPY	ETF	85.8	86.05	85.55	85.72	2235128.0
2008-11-12 17:00:00	SPY	ETF	85.77	86.9285	84.49	84.8	2803448.0
2008-11-12 17:30:00	SPY	ETF	84.8	84.87	84.6	84.7	607525.0
2008-11-12 18:00:00	SPY	ETF	84.71	84.94	84.7	84.88	86460.0
2008-11-12 18:30:00	SPY	ETF	84.88	85.02	84.8	84.95	66061.0
2008-11-12 19:00:00	SPY	ETF	84.95	85.14	84.95	85.0	70719.0
2008-11-12 19:30:00	SPY	ETF	84.96	85.19	84.83	84.84	98964.0
2008-11-12 04:30:00	QQQ	ETF	29.99	29.99	29.81	29.81	200.0
2008-11-12 05:00:00	QQQ	ETF	29.88	29.88	29.88	29.88	100.0
2008-11-12 06:30:00	QQQ	ETF	30.02	30.24	30.02	30.2	1600.0
2008-11-12 07:00:00	QQQ	ETF	30.28	30.3	30.12	30.13	16325.0
2008-11-12 07:30:00	QQQ	ETF	30.12	30.12	29.82	29.85	107010.0
2008-11-12 08:00:00	QQQ	ETF	29.85	29.87	29.74	29.84	1433779.0
2008-11-12 08:30:00	QQQ	ETF	29.84	29.87	29.64	29.71	780870.0
2008-11-12 09:00:00	QQQ	ETF	29.72	29.73	29.53	29.65	1240896.0
2008-11-12 09:30:00	QQQ	ETF	29.65	29.8	29.42	29.6005	20432788.0
2008-11-12 10:00:00	QQQ	ETF	29.6	29.75	29.4301	29.45	14082654.0
2008-11-12 10:30:00	QQQ	ETF	29.45	29.56	29.29	29.5001	18918432.0
2008-11-12 11:00:00	QQQ	ETF	29.5	29.5399	29.3	29.47	10858744.0
2008-11-12 11:30:00	QQQ	ETF	29.48	29.52	29.22	29.34	9273261.0
2008-11-12 12:00:00	QQQ	ETF	29.34	29.38	29.15	29.3	8718987.0
2008-11-12 12:30:00	QQQ	ETF	29.3	29.47	29.26	29.46	6518735.0
2008-11-12 13:00:00	QQQ	ETF	29.46	29.5	29.28	29.35	7846409.0
2008-11-12 13:30:00	QQQ	ETF	29.36	29.37	29.06	29.12	9221952.0
2008-11-12 14:00:00	QQQ	ETF	29.1	29.15	28.93	29.03	11121089.0

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

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