PREVIEW / etf_30min / 2007-03-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-23.parquet
  size:    101 KB
  rows:    3,637

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-03-23 06:00:00	SPY	ETF	143.24	143.24	143.24	143.24	500.0
2007-03-23 07:00:00	SPY	ETF	143.25	143.34	143.24	143.34	8900.0
2007-03-23 07:30:00	SPY	ETF	143.39	143.5	143.3	143.5	26300.0
2007-03-23 08:00:00	SPY	ETF	143.43	143.5	143.33	143.36	557400.0
2007-03-23 08:30:00	SPY	ETF	143.36	143.37	143.19	143.25	1112200.0
2007-03-23 09:00:00	SPY	ETF	143.25	143.29	143.14	143.28	673000.0
2007-03-23 09:30:00	SPY	ETF	143.28	143.45	143.15	143.23	8841899.0
2007-03-23 10:00:00	SPY	ETF	143.23	143.81	143.19	143.35	14733835.0
2007-03-23 10:30:00	SPY	ETF	143.36	143.61	143.28	143.53	7167514.0
2007-03-23 11:00:00	SPY	ETF	143.52	143.67	143.43	143.54	4864327.0
2007-03-23 11:30:00	SPY	ETF	143.53	143.66	143.45	143.55	3620400.0
2007-03-23 12:00:00	SPY	ETF	143.56	143.74	143.55	143.57	2812944.0
2007-03-23 12:30:00	SPY	ETF	143.57	143.58	143.41	143.5	3193492.0
2007-03-23 13:00:00	SPY	ETF	143.51	143.56	143.27	143.39	4061300.0
2007-03-23 13:30:00	SPY	ETF	143.38	143.5	143.3	143.4	4212200.0
2007-03-23 14:00:00	SPY	ETF	143.4	143.45	143.19	143.33	4204900.0
2007-03-23 14:30:00	SPY	ETF	143.32	143.52	143.3	143.51	3362104.0
2007-03-23 15:00:00	SPY	ETF	143.51	143.66	143.43	143.58	3938400.0
2007-03-23 15:30:00	SPY	ETF	143.59	143.6	143.43	143.49	5206720.0
2007-03-23 16:00:00	SPY	ETF	143.51	143.52	143.38	143.39	929400.0
2007-03-23 16:30:00	SPY	ETF	143.39	143.45	143.39	143.45	33400.0
2007-03-23 17:00:00	SPY	ETF	143.4	143.4	143.39	143.39	17700.0
2007-03-23 17:30:00	SPY	ETF	143.38	143.42	143.36	143.42	6000.0
2007-03-23 18:00:00	SPY	ETF	143.4	143.4	143.36	143.36	600.0
2007-03-23 18:30:00	SPY	ETF	143.39	143.45	143.39	143.45	5800.0
2007-03-23 19:00:00	SPY	ETF	143.45	143.45	143.44	143.44	4200.0
2007-03-23 19:30:00	SPY	ETF	143.45	143.45	143.45	143.45	200.0
2007-03-23 07:30:00	QQQ	ETF	44.26	44.3	44.26	44.3	5231.0
2007-03-23 08:00:00	QQQ	ETF	44.3	44.34	44.23	44.24	355456.0
2007-03-23 08:30:00	QQQ	ETF	44.24	44.25	44.19	44.22	593298.0
2007-03-23 09:00:00	QQQ	ETF	44.22	44.26	44.17	44.25	690461.0
2007-03-23 09:30:00	QQQ	ETF	44.26	44.34	44.17	44.2	8204700.0
2007-03-23 10:00:00	QQQ	ETF	44.21	44.37	44.15	44.19	11665600.0
2007-03-23 10:30:00	QQQ	ETF	44.2	44.26	44.15	44.22	5916300.0
2007-03-23 11:00:00	QQQ	ETF	44.22	44.26	44.19	44.22	2655400.0
2007-03-23 11:30:00	QQQ	ETF	44.21	44.26	44.17	44.21	4316800.0
2007-03-23 12:00:00	QQQ	ETF	44.21	44.29	44.2	44.23	3213000.0
2007-03-23 12:30:00	QQQ	ETF	44.23	44.24	44.17	44.22	2400000.0
2007-03-23 13:00:00	QQQ	ETF	44.22	44.25	44.14	44.16	3738000.0
2007-03-23 13:30:00	QQQ	ETF	44.16	44.2	44.13	44.17	3506500.0
2007-03-23 14:00:00	QQQ	ETF	44.17	44.19	44.07	44.13	4134900.0
2007-03-23 14:30:00	QQQ	ETF	44.13	44.17	44.12	44.17	4225100.0
2007-03-23 15:00:00	QQQ	ETF	44.16	44.23	44.14	44.21	3380900.0
2007-03-23 15:30:00	QQQ	ETF	44.21	44.21	44.1	44.12	5897700.0
2007-03-23 16:00:00	QQQ	ETF	44.11	44.11	44.04	44.06	3281967.0
2007-03-23 16:30:00	QQQ	ETF	44.07	44.09	44.05	44.08	71060.0
2007-03-23 17:00:00	QQQ	ETF	44.09	44.09	44.06	44.06	2290.0
2007-03-23 17:30:00	QQQ	ETF	44.07	44.09	44.07	44.07	5600.0
2007-03-23 18:00:00	QQQ	ETF	44.07	44.13	44.07	44.11	48988.0
2007-03-23 18:30:00	QQQ	ETF	44.13	44.16	44.13	44.13	29738.0

> showing 50 of 3,637 rows — these rows as CSV

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