PREVIEW / etf_30min / 2008-05-09

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-09.parquet
  size:    155 KB
  rows:    5,528

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
2008-05-09 04:00:00	SPY	ETF	138.7	138.7	138.61	138.61	500.0
2008-05-09 04:30:00	SPY	ETF	138.65	138.65	138.62	138.62	7500.0
2008-05-09 05:30:00	SPY	ETF	138.5	138.5	138.32	138.32	400.0
2008-05-09 06:00:00	SPY	ETF	138.35	138.53	138.35	138.52	17600.0
2008-05-09 06:30:00	SPY	ETF	138.45	138.5	138.33	138.5	93400.0
2008-05-09 07:00:00	SPY	ETF	138.49	138.59	138.42	138.55	394240.0
2008-05-09 07:30:00	SPY	ETF	138.55	138.59	138.35	138.36	905843.0
2008-05-09 08:00:00	SPY	ETF	138.58	139.8	138.36	138.42	1384226.0
2008-05-09 08:30:00	SPY	ETF	138.43	138.66	138.43	138.57	987799.0
2008-05-09 09:00:00	SPY	ETF	138.57	138.7	138.52	138.59	906611.0
2008-05-09 09:30:00	SPY	ETF	138.6	138.92	138.45	138.6	17978698.0
2008-05-09 10:00:00	SPY	ETF	138.6	138.97	138.59	138.84	12193126.0
2008-05-09 10:30:00	SPY	ETF	138.83	139.39	138.81	139.14	15857194.0
2008-05-09 11:00:00	SPY	ETF	139.14	139.18	138.85	139.02	10294374.0
2008-05-09 11:30:00	SPY	ETF	139.02	139.03	138.69	138.83	10764720.0
2008-05-09 12:00:00	SPY	ETF	138.82	138.85	138.65	138.8	5252111.0
2008-05-09 12:30:00	SPY	ETF	138.8	138.95	138.68	138.93	7152829.0
2008-05-09 13:00:00	SPY	ETF	138.93	138.95	138.56	138.62	8492957.0
2008-05-09 13:30:00	SPY	ETF	138.63	138.92	138.5	138.88	7680938.0
2008-05-09 14:00:00	SPY	ETF	138.88	139.02	138.66	138.66	8506356.0
2008-05-09 14:30:00	SPY	ETF	138.66	138.9	138.63	138.79	6555124.0
2008-05-09 15:00:00	SPY	ETF	138.78	139.2	138.75	139.18	7733617.0
2008-05-09 15:30:00	SPY	ETF	139.19	139.39	138.81	138.93	17775051.0
2008-05-09 16:00:00	SPY	ETF	138.92	139.8657	138.81	138.93	5944551.0
2008-05-09 16:30:00	SPY	ETF	138.93	138.94	138.82	138.9	183213.0
2008-05-09 17:00:00	SPY	ETF	138.87	139.05	138.87	138.9	56690.0
2008-05-09 17:30:00	SPY	ETF	138.91	139.12	138.91	139.11	52008.0
2008-05-09 18:00:00	SPY	ETF	139.11	139.12	139.04	139.09	1389.0
2008-05-09 18:30:00	SPY	ETF	139.1	139.11	138.93	138.95	41852.0
2008-05-09 19:00:00	SPY	ETF	138.99	139.0	138.95	138.96	6200.0
2008-05-09 19:30:00	SPY	ETF	138.95	138.95	138.91	138.95	7193.0
2008-05-09 05:00:00	QQQ	ETF	48.04	48.04	48.04	48.04	100.0
2008-05-09 05:30:00	QQQ	ETF	48.0	48.0	48.0	48.0	100.0
2008-05-09 06:00:00	QQQ	ETF	48.01	48.01	48.01	48.01	100.0
2008-05-09 06:30:00	QQQ	ETF	48.03	48.03	47.96	47.96	3800.0
2008-05-09 07:00:00	QQQ	ETF	48.01	48.03	47.97	48.03	56492.0
2008-05-09 07:30:00	QQQ	ETF	48.01	48.05	47.95	47.96	136872.0
2008-05-09 08:00:00	QQQ	ETF	47.96	48.06	47.95	48.01	696175.0
2008-05-09 08:30:00	QQQ	ETF	48.02	48.08	47.98	48.0	523167.0
2008-05-09 09:00:00	QQQ	ETF	48.0	48.04	47.99	48.02	686175.0
2008-05-09 09:30:00	QQQ	ETF	48.03	48.09	47.9	47.98	13238330.0
2008-05-09 10:00:00	QQQ	ETF	47.99	48.19	47.99	48.13	8286082.0
2008-05-09 10:30:00	QQQ	ETF	48.13	48.46	48.11	48.33	11101299.0
2008-05-09 11:00:00	QQQ	ETF	48.33	48.36	48.2	48.24	5384835.0
2008-05-09 11:30:00	QQQ	ETF	48.24	48.25	48.1	48.199	4942722.0
2008-05-09 12:00:00	QQQ	ETF	48.19	48.198	48.04	48.09	3218202.0
2008-05-09 12:30:00	QQQ	ETF	48.09	48.2	48.07	48.19	3345779.0
2008-05-09 13:00:00	QQQ	ETF	48.2	48.2	48.04	48.07	4290381.0
2008-05-09 13:30:00	QQQ	ETF	48.08	48.23	48.01	48.2	3949452.0
2008-05-09 14:00:00	QQQ	ETF	48.2	48.31	48.14	48.16	6088531.0

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

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