PREVIEW / etf_30min / 2007-12-14

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-14.parquet
  size:    139 KB
  rows:    5,157

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
2007-12-14 04:00:00	SPY	ETF	148.99	148.99	148.96	148.96	1000.0
2007-12-14 04:30:00	SPY	ETF	148.86	148.86	148.86	148.86	500.0
2007-12-14 05:00:00	SPY	ETF	148.97	148.98	148.79	148.79	18000.0
2007-12-14 06:00:00	SPY	ETF	148.73	148.73	148.37	148.45	5600.0
2007-12-14 06:30:00	SPY	ETF	148.54	148.55	148.4	148.54	26100.0
2007-12-14 07:00:00	SPY	ETF	148.6	148.6	148.19	148.36	334800.0
2007-12-14 07:30:00	SPY	ETF	148.42	148.81	148.41	148.79	360400.0
2007-12-14 08:00:00	SPY	ETF	148.75	149.04	148.2	148.8	3020600.0
2007-12-14 08:30:00	SPY	ETF	148.74	148.74	147.87	148.02	7857100.0
2007-12-14 09:00:00	SPY	ETF	148.02	148.15	147.9	148.06	2990000.0
2007-12-14 09:30:00	SPY	ETF	148.04	148.36	147.9	148.13	13249128.0
2007-12-14 10:00:00	SPY	ETF	148.13	148.63	148.11	148.39	11168832.0
2007-12-14 10:30:00	SPY	ETF	148.39	149.0	148.23	148.97	12623822.0
2007-12-14 11:00:00	SPY	ETF	148.97	149.1	148.65	148.65	8149807.0
2007-12-14 11:30:00	SPY	ETF	148.65	148.77	148.29	148.3999	7082988.0
2007-12-14 12:00:00	SPY	ETF	148.4	148.58	148.19	148.28	5801222.0
2007-12-14 12:30:00	SPY	ETF	148.28	148.6	148.01	148.5	7206753.0
2007-12-14 13:00:00	SPY	ETF	148.51	148.64	148.26	148.55	4555812.0
2007-12-14 13:30:00	SPY	ETF	148.54	148.55	148.13	148.28	3557643.0
2007-12-14 14:00:00	SPY	ETF	148.27	148.3	147.95	148.149	7040032.0
2007-12-14 14:30:00	SPY	ETF	148.15	148.28	147.63	147.64	10133933.0
2007-12-14 15:00:00	SPY	ETF	147.64	147.83	147.34	147.56	14138646.0
2007-12-14 15:30:00	SPY	ETF	147.56	147.99	147.17	147.18	26976984.0
2007-12-14 16:00:00	SPY	ETF	147.22	148.7	147.08	147.16	4065900.0
2007-12-14 16:30:00	SPY	ETF	147.16	147.6	147.14	147.25	3656000.0
2007-12-14 17:00:00	SPY	ETF	147.25	147.28	147.18	147.28	38800.0
2007-12-14 17:30:00	SPY	ETF	147.25	147.26	147.1	147.1	18200.0
2007-12-14 18:00:00	SPY	ETF	147.1	147.2	146.9	147.2	37200.0
2007-12-14 18:30:00	SPY	ETF	147.18	147.23	147.18	147.23	3100.0
2007-12-14 19:00:00	SPY	ETF	147.07	147.07	147.07	147.07	800.0
2007-12-14 19:30:00	SPY	ETF	147.07	147.17	147.02	147.16	6900.0
2007-12-14 07:00:00	QQQ	ETF	51.34	51.34	51.24	51.31	15415.0
2007-12-14 07:30:00	QQQ	ETF	51.32	51.47	51.32	51.44	391588.0
2007-12-14 08:00:00	QQQ	ETF	51.45	51.53	51.22	51.38	3586594.0
2007-12-14 08:30:00	QQQ	ETF	51.38	51.38	50.95	51.11	7434893.0
2007-12-14 09:00:00	QQQ	ETF	51.12	51.2	51.07	51.09	1692349.0
2007-12-14 09:30:00	QQQ	ETF	51.09	51.29	51.07	51.17	12067633.0
2007-12-14 10:00:00	QQQ	ETF	51.17	51.34	51.16	51.3	8478778.0
2007-12-14 10:30:00	QQQ	ETF	51.3	51.59	51.24	51.57	11550340.0
2007-12-14 11:00:00	QQQ	ETF	51.57	51.6	51.44	51.46	6710351.0
2007-12-14 11:30:00	QQQ	ETF	51.46	51.5	51.27	51.3	12198333.0
2007-12-14 12:00:00	QQQ	ETF	51.3	51.39	51.22	51.25	4490939.0
2007-12-14 12:30:00	QQQ	ETF	51.25	51.32	51.15	51.28	4005872.0
2007-12-14 13:00:00	QQQ	ETF	51.28	51.4	51.23	51.37	3944815.0
2007-12-14 13:30:00	QQQ	ETF	51.37	51.37	51.28	51.32	2707053.0
2007-12-14 14:00:00	QQQ	ETF	51.31	51.36	51.23	51.33	4239181.0
2007-12-14 14:30:00	QQQ	ETF	51.33	51.39	51.14	51.1494	7918516.0
2007-12-14 15:00:00	QQQ	ETF	51.14	51.2	50.92	50.97	16681997.0
2007-12-14 15:30:00	QQQ	ETF	50.98	51.16	50.93	51.0	19674479.0
2007-12-14 16:00:00	QQQ	ETF	51.01	51.3875	50.9	50.93	3740589.0

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

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