PREVIEW / etf_30min / 2007-11-07

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-07.parquet
  size:    151 KB
  rows:    5,401

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-07 04:00:00	SPY	ETF	151.33	151.4	151.01	151.01	12200.0
2007-11-07 04:30:00	SPY	ETF	151.01	151.01	150.2	150.44	15100.0
2007-11-07 05:00:00	SPY	ETF	150.24	150.55	150.24	150.55	37000.0
2007-11-07 05:30:00	SPY	ETF	150.4	150.58	150.4	150.58	24400.0
2007-11-07 06:00:00	SPY	ETF	150.54	150.63	150.48	150.56	11800.0
2007-11-07 06:30:00	SPY	ETF	150.28	150.5	150.27	150.29	214000.0
2007-11-07 07:00:00	SPY	ETF	150.24	150.54	149.84	150.45	1896600.0
2007-11-07 07:30:00	SPY	ETF	150.49	150.51	150.1	150.14	1095300.0
2007-11-07 08:00:00	SPY	ETF	150.17	151.45	149.92	150.4	6194000.0
2007-11-07 08:30:00	SPY	ETF	150.4	150.65	150.27	150.63	3065700.0
2007-11-07 09:00:00	SPY	ETF	150.63	151.75	150.31	150.46	2738810.0
2007-11-07 09:30:00	SPY	ETF	150.44	150.97	150.42	150.72	18160668.0
2007-11-07 10:00:00	SPY	ETF	150.71	151.13	150.57	150.83	13082874.0
2007-11-07 10:30:00	SPY	ETF	150.83	150.88	150.05	150.2	19112115.0
2007-11-07 11:00:00	SPY	ETF	150.19	150.62	150.03	150.48	10883423.0
2007-11-07 11:30:00	SPY	ETF	150.47	150.56	150.26	150.55	6921542.0
2007-11-07 12:00:00	SPY	ETF	150.55	150.5501	149.64	149.98	17625790.0
2007-11-07 12:30:00	SPY	ETF	149.97	150.21	149.37	149.52	14645650.0
2007-11-07 13:00:00	SPY	ETF	149.51	149.74	148.41	148.88	34307103.0
2007-11-07 13:30:00	SPY	ETF	148.88	149.45	148.855	149.18	21794621.0
2007-11-07 14:00:00	SPY	ETF	149.15	150.29	148.58	149.63	20213436.0
2007-11-07 14:30:00	SPY	ETF	149.63	149.86	148.83	149.11	21453995.0
2007-11-07 15:00:00	SPY	ETF	149.11	149.6	148.49	148.61	20021689.0
2007-11-07 15:30:00	SPY	ETF	148.6	152.1072	147.55	147.58	51669079.0
2007-11-07 16:00:00	SPY	ETF	147.67	149.15	147.55	147.74	8117200.0
2007-11-07 16:30:00	SPY	ETF	147.75	147.93	147.1	147.13	1589800.0
2007-11-07 17:00:00	SPY	ETF	147.13	148.0174	146.35	146.67	2098100.0
2007-11-07 17:30:00	SPY	ETF	146.63	147.2	146.5	147.0	1097000.0
2007-11-07 18:00:00	SPY	ETF	146.9	147.25	146.85	147.07	593200.0
2007-11-07 18:30:00	SPY	ETF	147.1	147.91	146.9	146.91	224000.0
2007-11-07 19:00:00	SPY	ETF	146.88	147.21	146.88	147.21	54900.0
2007-11-07 19:30:00	SPY	ETF	147.19	147.19	147.02	147.04	6700.0
2007-11-07 04:30:00	QQQ	ETF	54.35	54.35	54.12	54.12	6800.0
2007-11-07 05:30:00	QQQ	ETF	54.19	54.19	54.19	54.19	10000.0
2007-11-07 06:00:00	QQQ	ETF	54.24	54.24	54.2	54.21	8600.0
2007-11-07 06:30:00	QQQ	ETF	54.15	54.19	54.15	54.19	13700.0
2007-11-07 07:00:00	QQQ	ETF	54.14	54.21	54.04	54.17	403230.0
2007-11-07 07:30:00	QQQ	ETF	54.19	54.21	54.07	54.09	352440.0
2007-11-07 08:00:00	QQQ	ETF	54.12	54.19	54.09	54.14	1387970.0
2007-11-07 08:30:00	QQQ	ETF	54.14	54.32	54.13	54.29	885107.0
2007-11-07 09:00:00	QQQ	ETF	54.29	54.32	54.19	54.24	1640178.0
2007-11-07 09:30:00	QQQ	ETF	54.23	54.41	54.19	54.37	13574142.0
2007-11-07 10:00:00	QQQ	ETF	54.37	54.58	54.31	54.425	11214042.0
2007-11-07 10:30:00	QQQ	ETF	54.44	54.44	54.14	54.2	14018587.0
2007-11-07 11:00:00	QQQ	ETF	54.2	54.36	54.15	54.32	6161157.0
2007-11-07 11:30:00	QQQ	ETF	54.32	54.35	54.22	54.33	5058776.0
2007-11-07 12:00:00	QQQ	ETF	54.34	54.34	54.03	54.09	11956680.0
2007-11-07 12:30:00	QQQ	ETF	54.1	54.2	53.98	54.04	8763880.0
2007-11-07 13:00:00	QQQ	ETF	54.03	54.12	53.74	53.83	16756397.0
2007-11-07 13:30:00	QQQ	ETF	53.83	54.03	53.79	53.913	12536485.0

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

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