PREVIEW / etf_30min / 2008-03-13

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-13.parquet
  size:    167 KB
  rows:    5,974

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-03-13 04:00:00	SPY	ETF	129.96	130.05	129.95	130.05	12300.0
2008-03-13 04:30:00	SPY	ETF	130.0	130.0	129.57	129.57	8600.0
2008-03-13 05:00:00	SPY	ETF	129.4	129.47	129.4	129.4	3600.0
2008-03-13 06:00:00	SPY	ETF	129.71	129.71	129.39	129.39	65100.0
2008-03-13 06:30:00	SPY	ETF	129.52	129.64	129.33	129.6	398600.0
2008-03-13 07:00:00	SPY	ETF	129.66	129.69	129.47	129.51	966400.0
2008-03-13 07:30:00	SPY	ETF	129.56	129.74	129.51	129.59	1234900.0
2008-03-13 08:00:00	SPY	ETF	129.6	129.83	129.45	129.65	3614600.0
2008-03-13 08:30:00	SPY	ETF	129.6	129.8	129.18	129.6	4020900.0
2008-03-13 09:00:00	SPY	ETF	129.58	129.74	129.4	129.62	3576900.0
2008-03-13 09:30:00	SPY	ETF	129.61	129.87	128.9	129.15	30736337.0
2008-03-13 10:00:00	SPY	ETF	129.14	129.78	128.9	129.12	23404729.0
2008-03-13 10:30:00	SPY	ETF	129.13	129.24	128.6	128.9685	21437909.0
2008-03-13 11:00:00	SPY	ETF	128.96	130.71	128.85	130.34	49331239.0
2008-03-13 11:30:00	SPY	ETF	130.33	130.65	130.01	130.59	22103559.0
2008-03-13 12:00:00	SPY	ETF	130.6	131.17	130.38	130.56	19506186.0
2008-03-13 12:30:00	SPY	ETF	130.55	130.83	130.06	130.4	9564141.0
2008-03-13 13:00:00	SPY	ETF	130.4	131.95	130.24	131.8	23166400.0
2008-03-13 13:30:00	SPY	ETF	131.78	132.59	131.45	132.19	29754167.0
2008-03-13 14:00:00	SPY	ETF	132.18	132.61	132.0	132.52	21855940.0
2008-03-13 14:30:00	SPY	ETF	132.52	132.52	131.65	132.15	21497629.0
2008-03-13 15:00:00	SPY	ETF	132.15	132.53	131.78	132.24	23233590.0
2008-03-13 15:30:00	SPY	ETF	132.25	132.64	131.69	131.92	23872362.0
2008-03-13 16:00:00	SPY	ETF	131.88	131.96	129.35	131.63	4655600.0
2008-03-13 16:30:00	SPY	ETF	131.65	131.7	131.29	131.57	4267400.0
2008-03-13 17:00:00	SPY	ETF	131.55	131.69	131.44	131.46	2232200.0
2008-03-13 17:30:00	SPY	ETF	131.48	131.65	131.46	131.53	3085400.0
2008-03-13 18:00:00	SPY	ETF	131.53	131.7	131.53	131.7	38500.0
2008-03-13 18:30:00	SPY	ETF	131.75	131.8	131.6	131.65	306500.0
2008-03-13 19:00:00	SPY	ETF	131.68	131.78	131.61	131.78	25000.0
2008-03-13 19:30:00	SPY	ETF	131.74	131.88	131.72	131.75	26700.0
2008-03-13 04:00:00	QQQ	ETF	42.32	42.33	42.29	42.3	5400.0
2008-03-13 04:30:00	QQQ	ETF	42.27	42.27	42.12	42.12	2248.0
2008-03-13 05:00:00	QQQ	ETF	42.03	42.11	42.03	42.11	600.0
2008-03-13 05:30:00	QQQ	ETF	42.17	42.17	42.17	42.17	200.0
2008-03-13 06:00:00	QQQ	ETF	42.07	42.1	42.03	42.03	2251.0
2008-03-13 06:30:00	QQQ	ETF	42.12	42.2	42.07	42.2	1630.0
2008-03-13 07:00:00	QQQ	ETF	42.19	42.21	42.06	42.08	265444.0
2008-03-13 07:30:00	QQQ	ETF	42.07	42.16	42.05	42.15	672841.0
2008-03-13 08:00:00	QQQ	ETF	42.13	42.23	42.06	42.09	1199881.0
2008-03-13 08:30:00	QQQ	ETF	42.09	42.21	42.02	42.17	1749278.0
2008-03-13 09:00:00	QQQ	ETF	42.15	42.25	42.14	42.21	2165622.0
2008-03-13 09:30:00	QQQ	ETF	42.21	42.29	42.05	42.11	22718492.0
2008-03-13 10:00:00	QQQ	ETF	42.11	42.36	42.01	42.13	17440181.0
2008-03-13 10:30:00	QQQ	ETF	42.14	42.15	41.81	41.97	15625114.0
2008-03-13 11:00:00	QQQ	ETF	41.97	42.51	41.9	42.36	25933799.0
2008-03-13 11:30:00	QQQ	ETF	42.35	42.54	42.2901	42.48	16394061.0
2008-03-13 12:00:00	QQQ	ETF	42.482	42.69	42.41	42.48	9963235.0
2008-03-13 12:30:00	QQQ	ETF	42.48	42.59	42.29	42.47	10851152.0
2008-03-13 13:00:00	QQQ	ETF	42.47	43.0695	42.42	43.03	14474660.0

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

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