PREVIEW / etf_30min / 2007-12-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-21.parquet
  size:    140 KB
  rows:    5,354

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-21 04:00:00	SPY	ETF	147.11	147.11	146.99	146.99	4900.0
2007-12-21 04:30:00	SPY	ETF	146.91	146.91	146.91	146.91	1000.0
2007-12-21 05:00:00	SPY	ETF	147.06	147.16	147.06	147.16	1700.0
2007-12-21 05:30:00	SPY	ETF	146.98	147.18	146.98	147.18	3600.0
2007-12-21 06:00:00	SPY	ETF	147.12	147.12	147.11	147.11	22500.0
2007-12-21 06:30:00	SPY	ETF	147.1	147.24	147.09	147.15	25900.0
2007-12-21 07:00:00	SPY	ETF	147.19	147.19	147.04	147.09	334300.0
2007-12-21 07:30:00	SPY	ETF	147.1	147.25	147.07	147.12	409900.0
2007-12-21 08:00:00	SPY	ETF	147.13	147.31	147.07	147.2	1232600.0
2007-12-21 08:30:00	SPY	ETF	147.19	147.41	146.406	147.29	1793500.0
2007-12-21 09:00:00	SPY	ETF	147.29	147.52	147.25	147.38	2228323.0
2007-12-21 09:30:00	SPY	ETF	147.37	147.68	147.09	147.29	21254621.0
2007-12-21 10:00:00	SPY	ETF	147.29	147.84	147.29	147.63	17081584.0
2007-12-21 10:30:00	SPY	ETF	147.63	147.68	147.4	147.42	8110928.0
2007-12-21 11:00:00	SPY	ETF	147.43	147.72	147.41	147.54	6576186.0
2007-12-21 11:30:00	SPY	ETF	147.54	147.56	147.27	147.45	7490045.0
2007-12-21 12:00:00	SPY	ETF	147.46	147.61	147.37	147.61	3964997.0
2007-12-21 12:30:00	SPY	ETF	147.6	147.61	147.39	147.42	4013339.0
2007-12-21 13:00:00	SPY	ETF	147.42	147.56	147.34	147.45	5374129.0
2007-12-21 13:30:00	SPY	ETF	147.45	147.56	147.425	147.55	2091522.0
2007-12-21 14:00:00	SPY	ETF	147.55	147.94	147.54	147.79	8967126.0
2007-12-21 14:30:00	SPY	ETF	147.785	148.08	147.76	148.02	6686876.0
2007-12-21 15:00:00	SPY	ETF	148.01	148.26	147.58	148.19	9574347.0
2007-12-21 15:30:00	SPY	ETF	148.19	148.27	147.78	148.19	15923769.0
2007-12-21 16:00:00	SPY	ETF	148.15	148.43	147.7019	148.25	7324000.0
2007-12-21 16:30:00	SPY	ETF	148.34	148.37	148.13	148.33	3137400.0
2007-12-21 17:00:00	SPY	ETF	148.28	148.32	147.74	148.22	1193900.0
2007-12-21 17:30:00	SPY	ETF	148.33	148.35	148.33	148.34	520600.0
2007-12-21 18:00:00	SPY	ETF	148.33	148.43	148.29	148.43	3700.0
2007-12-21 18:30:00	SPY	ETF	148.3	148.3	148.3	148.3	800.0
2007-12-21 19:30:00	SPY	ETF	148.4	148.42	148.4	148.42	1400.0
2007-12-21 05:30:00	QQQ	ETF	51.48	51.48	51.45	51.45	7900.0
2007-12-21 06:00:00	QQQ	ETF	51.47	51.5	51.46	51.46	3000.0
2007-12-21 06:30:00	QQQ	ETF	51.46	51.49	51.45	51.49	3600.0
2007-12-21 07:00:00	QQQ	ETF	51.46	51.49	51.41	51.42	98100.0
2007-12-21 07:30:00	QQQ	ETF	51.43	51.49	51.39	51.42	127904.0
2007-12-21 08:00:00	QQQ	ETF	51.41	51.5	51.39	51.45	510342.0
2007-12-21 08:30:00	QQQ	ETF	51.45	51.58	51.45	51.57	1217565.0
2007-12-21 09:00:00	QQQ	ETF	51.56	51.75	51.56	51.71	2329632.0
2007-12-21 09:30:00	QQQ	ETF	51.71	51.72	51.5	51.552	17146188.0
2007-12-21 10:00:00	QQQ	ETF	51.57	51.72	51.53	51.64	8162510.0
2007-12-21 10:30:00	QQQ	ETF	51.64	51.65	51.52	51.57	6562051.0
2007-12-21 11:00:00	QQQ	ETF	51.56	51.66	51.55	51.5624	5592250.0
2007-12-21 11:30:00	QQQ	ETF	51.56	51.58	51.49	51.54	6556546.0
2007-12-21 12:00:00	QQQ	ETF	51.55	51.61	51.48	51.5999	6741756.0
2007-12-21 12:30:00	QQQ	ETF	51.6	51.63	51.55	51.56	3139647.0
2007-12-21 13:00:00	QQQ	ETF	51.56	51.63	51.54	51.58	3432240.0
2007-12-21 13:30:00	QQQ	ETF	51.58	51.66	51.58	51.65	3919309.0
2007-12-21 14:00:00	QQQ	ETF	51.64	51.75	51.64	51.6901	6668031.0
2007-12-21 14:30:00	QQQ	ETF	51.69	51.81	51.669	51.78	4526776.0

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

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