PREVIEW / etf_30min / 2008-12-26

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-26.parquet
  size:    183 KB
  rows:    6,050

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-26 07:00:00	SPY	ETF	87.04	87.08	86.98	87.08	23804.0
2008-12-26 07:30:00	SPY	ETF	87.05	87.37	87.05	87.21	87049.0
2008-12-26 08:00:00	SPY	ETF	87.21	87.34	87.17	87.32	175301.0
2008-12-26 08:30:00	SPY	ETF	87.3	87.33	87.17	87.2	230839.0
2008-12-26 09:00:00	SPY	ETF	87.18	87.24	87.16	87.23	381599.0
2008-12-26 09:30:00	SPY	ETF	87.24	87.3	86.91	86.94	7200828.0
2008-12-26 10:00:00	SPY	ETF	86.93	87.15	86.93	86.96	5177446.0
2008-12-26 10:30:00	SPY	ETF	86.95	87.0	86.76	86.87	5073598.0
2008-12-26 11:00:00	SPY	ETF	86.87	86.95	86.68	86.72	4826379.0
2008-12-26 11:30:00	SPY	ETF	86.7209	86.9031	86.7	86.83	3188757.0
2008-12-26 12:00:00	SPY	ETF	86.82	86.93	86.72	86.74	3162918.0
2008-12-26 12:30:00	SPY	ETF	86.73	86.83	86.5	86.59	4522980.0
2008-12-26 13:00:00	SPY	ETF	86.59	86.68	86.55	86.6597	2260223.0
2008-12-26 13:30:00	SPY	ETF	86.6525	86.83	86.63	86.67	6954462.0
2008-12-26 14:00:00	SPY	ETF	86.669	86.84	86.64	86.72	5501750.0
2008-12-26 14:30:00	SPY	ETF	86.72	86.97	86.71	86.96	4523351.0
2008-12-26 15:00:00	SPY	ETF	86.95	87.2799	86.83	87.19	6086035.0
2008-12-26 15:30:00	SPY	ETF	87.199	87.27	86.93	87.13	11144987.0
2008-12-26 16:00:00	SPY	ETF	87.14	87.17	87.01	87.16	1043127.0
2008-12-26 16:30:00	SPY	ETF	87.08	87.22	87.08	87.1	52503.0
2008-12-26 17:00:00	SPY	ETF	87.16	87.2	87.13	87.13	2196.0
2008-12-26 17:30:00	SPY	ETF	87.15	87.18	87.15	87.18	1900.0
2008-12-26 18:00:00	SPY	ETF	87.16	87.18	87.16	87.18	430.0
2008-12-26 18:30:00	SPY	ETF	87.18	87.18	87.12	87.12	1500.0
2008-12-26 19:00:00	SPY	ETF	87.13	87.13	87.12	87.12	316.0
2008-12-26 19:30:00	SPY	ETF	87.14	87.16	87.12	87.16	3995.0
2008-12-26 07:00:00	QQQ	ETF	29.16	29.16	29.14	29.14	1815.0
2008-12-26 07:30:00	QQQ	ETF	29.16	29.23	29.16	29.23	27807.0
2008-12-26 08:00:00	QQQ	ETF	29.2	29.25	29.19	29.22	68493.0
2008-12-26 08:30:00	QQQ	ETF	29.24	29.25	29.2	29.22	123420.0
2008-12-26 09:00:00	QQQ	ETF	29.22	29.22	29.18	29.19	129002.0
2008-12-26 09:30:00	QQQ	ETF	29.19	29.23	29.07	29.07	1698388.0
2008-12-26 10:00:00	QQQ	ETF	29.08	29.14	29.07	29.1	1275030.0
2008-12-26 10:30:00	QQQ	ETF	29.099	29.12	29.04	29.09	913432.0
2008-12-26 11:00:00	QQQ	ETF	29.09	29.11	28.99	28.99	1257711.0
2008-12-26 11:30:00	QQQ	ETF	28.99	29.06	28.97	29.04	1271532.0
2008-12-26 12:00:00	QQQ	ETF	29.05	29.08	29.03	29.04	888730.0
2008-12-26 12:30:00	QQQ	ETF	29.05	29.07	28.97	28.99	1053486.0
2008-12-26 13:00:00	QQQ	ETF	28.99	29.02	28.98	29.01	900809.0
2008-12-26 13:30:00	QQQ	ETF	29.0199	29.08	29.01	29.05	2122343.0
2008-12-26 14:00:00	QQQ	ETF	29.05	29.09	29.04	29.0699	1257714.0
2008-12-26 14:30:00	QQQ	ETF	29.07	29.14	29.06	29.1295	1282075.0
2008-12-26 15:00:00	QQQ	ETF	29.13	29.19	29.09	29.1795	2527923.0
2008-12-26 15:30:00	QQQ	ETF	29.1775	29.2	29.09	29.14	3560173.0
2008-12-26 16:00:00	QQQ	ETF	29.14	29.18	29.02	29.11	501339.0
2008-12-26 16:30:00	QQQ	ETF	29.13	29.2	29.11	29.14	24601.0
2008-12-26 17:00:00	QQQ	ETF	29.18	29.2	29.15	29.17	2185.0
2008-12-26 17:30:00	QQQ	ETF	29.19	29.21	29.16	29.21	3600.0
2008-12-26 18:00:00	QQQ	ETF	29.21	29.22	29.2	29.2	6565.0
2008-12-26 19:00:00	QQQ	ETF	29.17	29.17	29.16	29.16	767.0

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

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