PREVIEW / etf_30min / 2007-08-09

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-09.parquet
  size:    136 KB
  rows:    4,976

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-08-09 04:00:00	SPY	ETF	149.11	149.11	148.92	148.94	11200.0
2007-08-09 04:30:00	SPY	ETF	148.83	148.9	148.66	148.68	23800.0
2007-08-09 05:00:00	SPY	ETF	148.63	148.72	148.5	148.72	27100.0
2007-08-09 05:30:00	SPY	ETF	148.99	148.99	148.6	148.6	6900.0
2007-08-09 06:00:00	SPY	ETF	148.69	148.81	148.69	148.81	25000.0
2007-08-09 06:30:00	SPY	ETF	148.64	148.64	148.23	148.29	52900.0
2007-08-09 07:00:00	SPY	ETF	148.24	148.66	148.23	148.32	1428900.0
2007-08-09 07:30:00	SPY	ETF	148.3	148.56	148.17	148.52	1186300.0
2007-08-09 08:00:00	SPY	ETF	148.48	148.68	148.22	148.28	4398200.0
2007-08-09 08:30:00	SPY	ETF	148.27	148.57	147.54	147.63	5499700.0
2007-08-09 09:00:00	SPY	ETF	147.63	147.7	146.95	147.46	8905438.0
2007-08-09 09:30:00	SPY	ETF	147.43	147.97	146.75	147.78	44983922.0
2007-08-09 10:00:00	SPY	ETF	147.78	148.4	147.65	148.18	29456862.0
2007-08-09 10:30:00	SPY	ETF	148.2	149.9	147.81	148.12	30483699.0
2007-08-09 11:00:00	SPY	ETF	148.12	148.84	148.06	148.16	17393233.0
2007-08-09 11:30:00	SPY	ETF	148.1599	148.42	147.63	148.07	15826995.0
2007-08-09 12:00:00	SPY	ETF	148.07	148.19	147.6	148.12	15379963.0
2007-08-09 12:30:00	SPY	ETF	148.13	148.13	147.13	147.42	16353159.0
2007-08-09 13:00:00	SPY	ETF	147.42	147.49	146.7	147.16	22837969.0
2007-08-09 13:30:00	SPY	ETF	147.16	147.79	147.1	147.6	15377254.0
2007-08-09 14:00:00	SPY	ETF	147.62	147.96	146.79	146.91	12283043.0
2007-08-09 14:30:00	SPY	ETF	146.9	147.23	146.32	146.34	23345192.0
2007-08-09 15:00:00	SPY	ETF	146.34	149.95	145.89	146.64	30712911.0
2007-08-09 15:30:00	SPY	ETF	146.64	146.94	145.64	145.7	36840622.0
2007-08-09 16:00:00	SPY	ETF	145.65	148.67	145.29	145.36	8636800.0
2007-08-09 16:30:00	SPY	ETF	145.37	147.78	145.34	145.41	855900.0
2007-08-09 17:00:00	SPY	ETF	145.39	145.51	145.25	145.43	473700.0
2007-08-09 17:30:00	SPY	ETF	145.43	147.0	145.39	145.44	276300.0
2007-08-09 18:00:00	SPY	ETF	145.44	145.56	145.4	145.55	105200.0
2007-08-09 18:30:00	SPY	ETF	145.55	145.55	145.33	145.46	29500.0
2007-08-09 19:00:00	SPY	ETF	145.47	145.51	145.3	145.32	372200.0
2007-08-09 19:30:00	SPY	ETF	145.33	145.36	144.52	144.6	160200.0
2007-08-09 06:30:00	QQQ	ETF	48.65	48.65	48.65	48.65	5000.0
2007-08-09 07:00:00	QQQ	ETF	48.54	48.66	48.47	48.5	743223.0
2007-08-09 07:30:00	QQQ	ETF	48.5	48.59	48.49	48.58	326480.0
2007-08-09 08:00:00	QQQ	ETF	48.57	48.6	48.51	48.52	889235.0
2007-08-09 08:30:00	QQQ	ETF	48.54	48.63	48.18	48.25	4716506.0
2007-08-09 09:00:00	QQQ	ETF	48.26	48.37	48.08	48.2	5476300.0
2007-08-09 09:30:00	QQQ	ETF	48.19	48.57	48.15	48.53	24413942.0
2007-08-09 10:00:00	QQQ	ETF	48.54	48.86	48.48	48.81	21470399.0
2007-08-09 10:30:00	QQQ	ETF	48.8085	48.97	48.5696	48.71	14552294.0
2007-08-09 11:00:00	QQQ	ETF	48.71	48.87	48.6	48.61	9245165.0
2007-08-09 11:30:00	QQQ	ETF	48.61	48.67	48.41	48.52	12016300.0
2007-08-09 12:00:00	QQQ	ETF	48.52	48.58	48.4	48.57	7595342.0
2007-08-09 12:30:00	QQQ	ETF	48.57	48.57	48.12	48.23	21216720.0
2007-08-09 13:00:00	QQQ	ETF	48.23	48.26	48.06	48.24	17549717.0
2007-08-09 13:30:00	QQQ	ETF	48.24	48.4	48.22	48.3286	12248451.0
2007-08-09 14:00:00	QQQ	ETF	48.32	48.32	48.092	48.15	11424269.0
2007-08-09 14:30:00	QQQ	ETF	48.15	48.28	47.93	47.93	25357570.0
2007-08-09 15:00:00	QQQ	ETF	47.93	48.05	47.8	47.9	17537409.0

> showing 50 of 4,976 rows — these rows as CSV

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