PREVIEW / etf_30min / 2007-11-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-05.parquet
  size:    139 KB
  rows:    5,232

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-11-05 04:00:00	SPY	ETF	150.13	150.13	150.13	150.13	3200.0
2007-11-05 04:30:00	SPY	ETF	150.18	150.18	150.18	150.18	10000.0
2007-11-05 05:00:00	SPY	ETF	150.0	150.0	150.0	150.0	1100.0
2007-11-05 05:30:00	SPY	ETF	150.01	150.01	149.95	149.95	4500.0
2007-11-05 06:00:00	SPY	ETF	149.93	149.93	149.77	149.9	140000.0
2007-11-05 06:30:00	SPY	ETF	149.8	149.93	149.75	149.79	112200.0
2007-11-05 07:00:00	SPY	ETF	149.78	150.1	149.78	149.98	709700.0
2007-11-05 07:30:00	SPY	ETF	149.97	150.33	149.93	150.07	571600.0
2007-11-05 08:00:00	SPY	ETF	150.08	150.09	149.73	149.77	2606900.0
2007-11-05 08:30:00	SPY	ETF	149.76	149.78	149.48	149.77	2112800.0
2007-11-05 09:00:00	SPY	ETF	149.78	149.78	149.47	149.63	1213597.0
2007-11-05 09:30:00	SPY	ETF	149.64	150.28	149.36	150.19	28190946.0
2007-11-05 10:00:00	SPY	ETF	150.2	150.65	149.91	150.04	20957231.0
2007-11-05 10:30:00	SPY	ETF	150.06	150.78	150.03	150.39	12227655.0
2007-11-05 11:00:00	SPY	ETF	150.4	150.64	150.14	150.25	7653218.0
2007-11-05 11:30:00	SPY	ETF	150.25	150.76	150.15	150.53	5676985.0
2007-11-05 12:00:00	SPY	ETF	150.53	150.66	150.05	150.24	6764083.0
2007-11-05 12:30:00	SPY	ETF	150.23	150.46	150.05	150.28	3891556.0
2007-11-05 13:00:00	SPY	ETF	150.29	150.44	149.84	149.92	8830721.0
2007-11-05 13:30:00	SPY	ETF	149.93	150.06	148.0	149.36	19595413.0
2007-11-05 14:00:00	SPY	ETF	149.38	149.73	149.07	149.31	21270716.0
2007-11-05 14:30:00	SPY	ETF	149.31	149.88	148.97	149.56	18904210.0
2007-11-05 15:00:00	SPY	ETF	149.56	150.98	149.2	150.73	31633398.0
2007-11-05 15:30:00	SPY	ETF	150.73	151.16	150.16	150.19	22578562.0
2007-11-05 16:00:00	SPY	ETF	150.15	150.38	149.94	150.1	3779600.0
2007-11-05 16:30:00	SPY	ETF	150.12	150.9691	150.12	150.27	4084200.0
2007-11-05 17:00:00	SPY	ETF	150.29	150.3	150.22	150.27	19800.0
2007-11-05 17:30:00	SPY	ETF	150.48	150.75	150.2	150.65	13800.0
2007-11-05 18:00:00	SPY	ETF	150.22	150.26	149.22	150.26	12600.0
2007-11-05 18:30:00	SPY	ETF	150.12	150.12	150.11	150.12	700.0
2007-11-05 19:00:00	SPY	ETF	150.13	150.24	150.1	150.21	66900.0
2007-11-05 19:30:00	SPY	ETF	150.26	150.4	150.26	150.4	12600.0
2007-11-05 04:30:00	QQQ	ETF	54.04	54.04	54.04	54.04	100.0
2007-11-05 05:00:00	QQQ	ETF	54.04	54.04	54.04	54.04	100.0
2007-11-05 05:30:00	QQQ	ETF	54.0	54.01	54.0	54.01	12300.0
2007-11-05 06:00:00	QQQ	ETF	53.91	53.96	53.91	53.96	100100.0
2007-11-05 06:30:00	QQQ	ETF	53.96	53.98	53.92	53.96	53500.0
2007-11-05 07:00:00	QQQ	ETF	53.92	54.04	53.92	53.94	130800.0
2007-11-05 07:30:00	QQQ	ETF	53.93	54.06	53.93	54.0	150000.0
2007-11-05 08:00:00	QQQ	ETF	53.98	54.0	53.9	53.92	442675.0
2007-11-05 08:30:00	QQQ	ETF	53.92	53.93	53.85	53.91	586340.0
2007-11-05 09:00:00	QQQ	ETF	53.9	53.92	53.82	53.86	1152352.0
2007-11-05 09:30:00	QQQ	ETF	53.87	54.04	53.63	54.02	22786249.0
2007-11-05 10:00:00	QQQ	ETF	54.02	54.2	53.99	54.06	14874523.0
2007-11-05 10:30:00	QQQ	ETF	54.06	54.4	54.05	54.24	10329004.0
2007-11-05 11:00:00	QQQ	ETF	54.24	54.32	54.08	54.17	8436345.0
2007-11-05 11:30:00	QQQ	ETF	54.17	54.31	54.08	54.25	3740602.0
2007-11-05 12:00:00	QQQ	ETF	54.26	54.3	54.08	54.1201	4155854.0
2007-11-05 12:30:00	QQQ	ETF	54.12	54.18	54.06	54.12	2753037.0
2007-11-05 13:00:00	QQQ	ETF	54.12	54.19	54.0	54.05	4366868.0

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

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