PREVIEW / etf_30min / 2007-09-11

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-11.parquet
  size:    122 KB
  rows:    4,530

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-09-11 05:30:00	SPY	ETF	146.04	146.04	146.04	146.04	1000.0
2007-09-11 06:00:00	SPY	ETF	146.18	146.18	146.18	146.18	1000.0
2007-09-11 06:30:00	SPY	ETF	146.39	146.43	146.33	146.33	21000.0
2007-09-11 07:00:00	SPY	ETF	146.39	146.39	146.2	146.25	405400.0
2007-09-11 07:30:00	SPY	ETF	146.22	146.48	146.19	146.33	549300.0
2007-09-11 08:00:00	SPY	ETF	146.3	146.55	146.26	146.36	2232200.0
2007-09-11 08:30:00	SPY	ETF	146.36	146.4	146.1	146.12	467600.0
2007-09-11 09:00:00	SPY	ETF	146.12	146.27	146.09	146.24	912404.0
2007-09-11 09:30:00	SPY	ETF	146.24	146.74	146.13	146.62	19870871.0
2007-09-11 10:00:00	SPY	ETF	146.61	147.01	146.35	146.93	15145600.0
2007-09-11 10:30:00	SPY	ETF	146.94	147.09	146.83	146.89	8970800.0
2007-09-11 11:00:00	SPY	ETF	146.89	146.96	146.54	146.87	10980300.0
2007-09-11 11:30:00	SPY	ETF	146.86	146.92	146.49	146.6	10094200.0
2007-09-11 12:00:00	SPY	ETF	146.59	146.72	146.4	146.65	6537100.0
2007-09-11 12:30:00	SPY	ETF	146.66	146.96	146.55	146.8	5665400.0
2007-09-11 13:00:00	SPY	ETF	146.8	146.9	146.52	146.81	6473200.0
2007-09-11 13:30:00	SPY	ETF	146.81	147.05	146.7	146.93	7659400.0
2007-09-11 14:00:00	SPY	ETF	146.92	147.58	146.91	147.57	14441500.0
2007-09-11 14:30:00	SPY	ETF	147.57	147.63	147.17	147.35	9376700.0
2007-09-11 15:00:00	SPY	ETF	147.351	147.68	147.23	147.53	10187300.0
2007-09-11 15:30:00	SPY	ETF	147.53	147.7	146.88	147.64	22752500.0
2007-09-11 16:00:00	SPY	ETF	147.59	147.6	146.34	147.52	4087000.0
2007-09-11 16:30:00	SPY	ETF	147.52	147.55	147.42	147.45	1383700.0
2007-09-11 17:00:00	SPY	ETF	147.45	147.5	147.42	147.46	198600.0
2007-09-11 17:30:00	SPY	ETF	147.5	147.51	147.47	147.47	2500.0
2007-09-11 18:00:00	SPY	ETF	147.47	147.49	147.43	147.44	31600.0
2007-09-11 18:30:00	SPY	ETF	147.43	147.43	147.38	147.42	105100.0
2007-09-11 19:00:00	SPY	ETF	147.4	147.4	147.32	147.35	11700.0
2007-09-11 19:30:00	SPY	ETF	147.35	147.45	147.34	147.36	4300.0
2007-09-11 06:30:00	QQQ	ETF	48.59	48.59	48.55	48.55	2000.0
2007-09-11 07:00:00	QQQ	ETF	48.56	48.57	48.5	48.54	290474.0
2007-09-11 07:30:00	QQQ	ETF	48.54	48.65	48.54	48.64	1055049.0
2007-09-11 08:00:00	QQQ	ETF	48.63	48.68	48.58	48.59	1968748.0
2007-09-11 08:30:00	QQQ	ETF	48.6	48.62	48.47	48.47	925124.0
2007-09-11 09:00:00	QQQ	ETF	48.48	48.54	48.48	48.52	762228.0
2007-09-11 09:30:00	QQQ	ETF	48.51	48.61	48.43	48.58	11785984.0
2007-09-11 10:00:00	QQQ	ETF	48.57	48.74	48.15	48.72	9108337.0
2007-09-11 10:30:00	QQQ	ETF	48.7175	48.75	48.63	48.6601	6301530.0
2007-09-11 11:00:00	QQQ	ETF	48.66	48.6619	48.56	48.6575	6567542.0
2007-09-11 11:30:00	QQQ	ETF	48.66	48.68	48.56	48.6	3825566.0
2007-09-11 12:00:00	QQQ	ETF	48.6	48.67	48.52	48.651	4624020.0
2007-09-11 12:30:00	QQQ	ETF	48.65	48.75	48.6222	48.74	3589435.0
2007-09-11 13:00:00	QQQ	ETF	48.75	48.78	48.69	48.7611	2328897.0
2007-09-11 13:30:00	QQQ	ETF	48.77	48.89	48.7495	48.8415	5780326.0
2007-09-11 14:00:00	QQQ	ETF	48.848	48.9885	48.848	48.96	4546025.0
2007-09-11 14:30:00	QQQ	ETF	48.96	48.98	48.81	48.87	4529642.0
2007-09-11 15:00:00	QQQ	ETF	48.87	48.97	48.82	48.9	5552875.0
2007-09-11 15:30:00	QQQ	ETF	48.9	48.96	48.66	48.95	12564994.0
2007-09-11 16:00:00	QQQ	ETF	48.96	48.97	48.89	48.96	3755901.0
2007-09-11 16:30:00	QQQ	ETF	48.95	49.01	48.87	48.88	929899.0

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

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