PREVIEW / etf_30min / 2008-09-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-29.parquet
  size:    199 KB
  rows:    7,069

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-09-29 04:00:00	SPY	ETF	118.42	118.42	118.42	118.42	2000.0
2008-09-29 05:00:00	SPY	ETF	118.94	118.94	118.94	118.94	1000.0
2008-09-29 05:30:00	SPY	ETF	118.99	118.99	118.51	118.51	6300.0
2008-09-29 06:00:00	SPY	ETF	118.67	118.67	118.5	118.5	800.0
2008-09-29 06:30:00	SPY	ETF	118.92	119.07	118.79	118.9	98090.0
2008-09-29 07:00:00	SPY	ETF	118.91	118.99	118.53	118.9	400986.0
2008-09-29 07:30:00	SPY	ETF	118.9	119.18	118.77	119.01	729778.0
2008-09-29 08:00:00	SPY	ETF	119.01	120.0	118.6	119.15	3366833.0
2008-09-29 08:30:00	SPY	ETF	119.09	120.55	118.6	119.17	3392028.0
2008-09-29 09:00:00	SPY	ETF	119.15	119.42	118.76	119.18	4159491.0
2008-09-29 09:30:00	SPY	ETF	119.18	120.85	116.4	117.14	47895582.0
2008-09-29 10:00:00	SPY	ETF	117.14	117.94	115.99	117.11	42640094.0
2008-09-29 10:30:00	SPY	ETF	117.11	117.48	116.61	117.05	21678685.0
2008-09-29 11:00:00	SPY	ETF	117.05	121.1793	116.47	116.7	18125767.0
2008-09-29 11:30:00	SPY	ETF	116.7	121.1793	116.25	116.68	16791721.0
2008-09-29 12:00:00	SPY	ETF	116.6784	121.08	115.91	116.27	17635611.0
2008-09-29 12:30:00	SPY	ETF	116.26	121.1793	115.76	116.48	18164350.0
2008-09-29 13:00:00	SPY	ETF	116.47	117.24	115.91	116.85	16342112.0
2008-09-29 13:30:00	SPY	ETF	116.85	116.91	111.01	114.1	83463649.0
2008-09-29 14:00:00	SPY	ETF	114.11	116.66	111.71	113.7	51754230.0
2008-09-29 14:30:00	SPY	ETF	113.7	114.15	113.05	113.199	22941259.0
2008-09-29 15:00:00	SPY	ETF	113.2	121.18	110.97	111.32	25752456.0
2008-09-29 15:30:00	SPY	ETF	111.33	113.59	111.07	112.83	34003157.0
2008-09-29 16:00:00	SPY	ETF	112.79	121.1793	111.0	111.59	8931143.0
2008-09-29 16:30:00	SPY	ETF	111.45	119.0	110.52	111.37	2562492.0
2008-09-29 17:00:00	SPY	ETF	111.33	121.179	111.25	111.5	878948.0
2008-09-29 17:30:00	SPY	ETF	111.55	111.82	111.45	111.6	1177204.0
2008-09-29 18:00:00	SPY	ETF	111.58	111.8	111.5	111.79	160724.0
2008-09-29 18:30:00	SPY	ETF	111.79	111.85	111.51	111.8	53129.0
2008-09-29 19:00:00	SPY	ETF	111.8	113.08	110.98	112.0	9018889.0
2008-09-29 19:30:00	SPY	ETF	112.0	113.47	111.69	111.74	4881609.0
2008-09-29 04:00:00	QQQ	ETF	40.24	40.24	40.24	40.24	100.0
2008-09-29 07:00:00	QQQ	ETF	40.33	40.38	40.23	40.38	19330.0
2008-09-29 07:30:00	QQQ	ETF	40.37	40.47	40.31	40.35	214207.0
2008-09-29 08:00:00	QQQ	ETF	40.35	40.43	40.25	40.3	1040500.0
2008-09-29 08:30:00	QQQ	ETF	40.31	40.7	39.9	40.28	1523966.0
2008-09-29 09:00:00	QQQ	ETF	40.28	40.32	40.13	40.26	1074712.0
2008-09-29 09:30:00	QQQ	ETF	40.26	40.38	39.09	39.28	32193949.0
2008-09-29 10:00:00	QQQ	ETF	39.28	39.44	38.62	38.99	34358295.0
2008-09-29 10:30:00	QQQ	ETF	38.99	39.2	38.84	39.11	17400510.0
2008-09-29 11:00:00	QQQ	ETF	39.11	39.17	39.01	39.08	12283758.0
2008-09-29 11:30:00	QQQ	ETF	39.09	39.09	38.77	38.8695	9730544.0
2008-09-29 12:00:00	QQQ	ETF	38.87	38.97	38.74	38.85	12418908.0
2008-09-29 12:30:00	QQQ	ETF	38.845	39.07	38.69	38.91	13492872.0
2008-09-29 13:00:00	QQQ	ETF	38.91	39.09	38.67	39.05	11658024.0
2008-09-29 13:30:00	QQQ	ETF	39.05	39.08	37.71	38.15	41994659.0
2008-09-29 14:00:00	QQQ	ETF	38.15	38.51	37.6	38.13	34013464.0
2008-09-29 14:30:00	QQQ	ETF	38.13	38.2	37.79	37.87	13266819.0
2008-09-29 15:00:00	QQQ	ETF	37.865	38.02	37.25	37.33	14930553.0
2008-09-29 15:30:00	QQQ	ETF	37.34	38.24	37.18	37.45	35225859.0

> showing 50 of 7,069 rows — these rows as CSV

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