PREVIEW / etf_30min / 2008-03-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-07.parquet
  size:    165 KB
  rows:    5,942

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-07 04:00:00	SPY	ETF	130.38	130.42	130.38	130.41	1800.0
2008-03-07 05:00:00	SPY	ETF	130.81	130.81	130.81	130.81	1000.0
2008-03-07 05:30:00	SPY	ETF	130.69	130.69	130.65	130.65	13000.0
2008-03-07 06:00:00	SPY	ETF	130.6	130.6	130.6	130.6	100.0
2008-03-07 06:30:00	SPY	ETF	130.62	130.7	130.55	130.7	112000.0
2008-03-07 07:00:00	SPY	ETF	130.7	131.34	130.7	131.3	678000.0
2008-03-07 07:30:00	SPY	ETF	131.35	131.43	131.22	131.33	333200.0
2008-03-07 08:00:00	SPY	ETF	130.95	132.09	130.03	130.76	14732800.0
2008-03-07 08:30:00	SPY	ETF	130.76	130.76	129.13	129.94	14972199.0
2008-03-07 09:00:00	SPY	ETF	129.95	129.98	129.48	129.7	3732262.0
2008-03-07 09:30:00	SPY	ETF	129.73	131.26	129.445	131.11	43902454.0
2008-03-07 10:00:00	SPY	ETF	131.1	131.43	130.53	130.98	30042790.0
2008-03-07 10:30:00	SPY	ETF	130.98	131.74	130.87	130.97	18503304.0
2008-03-07 11:00:00	SPY	ETF	130.96	131.0	130.24	130.29	15378899.0
2008-03-07 11:30:00	SPY	ETF	130.29	130.67	129.95	130.14	16878536.0
2008-03-07 12:00:00	SPY	ETF	130.14	130.21	129.72	129.93	12429012.0
2008-03-07 12:30:00	SPY	ETF	129.94	130.24	129.69	130.13	9423136.0
2008-03-07 13:00:00	SPY	ETF	130.13	130.13	129.58	129.87	8135081.0
2008-03-07 13:30:00	SPY	ETF	129.87	129.89	129.09	129.17	16195227.0
2008-03-07 14:00:00	SPY	ETF	129.18	129.41	128.68	128.95	23793013.0
2008-03-07 14:30:00	SPY	ETF	128.95	129.74	128.58	129.69	19667638.0
2008-03-07 15:00:00	SPY	ETF	129.69	131.0	129.14	129.99	36728896.0
2008-03-07 15:30:00	SPY	ETF	129.98	130.34	129.36	129.71	31395630.0
2008-03-07 16:00:00	SPY	ETF	129.722	131.5	129.53	129.6	4482100.0
2008-03-07 16:30:00	SPY	ETF	129.67	129.79	129.6	129.63	1080400.0
2008-03-07 17:00:00	SPY	ETF	129.65	129.72	129.49	129.55	366700.0
2008-03-07 17:30:00	SPY	ETF	129.6	129.64	129.5	129.5	31800.0
2008-03-07 18:00:00	SPY	ETF	129.57	129.6	129.54	129.58	38700.0
2008-03-07 18:30:00	SPY	ETF	129.54	129.54	129.45	129.49	3100.0
2008-03-07 19:00:00	SPY	ETF	129.5	129.5	129.46	129.49	10200.0
2008-03-07 19:30:00	SPY	ETF	129.47	129.47	129.46	129.46	7700.0
2008-03-07 04:00:00	QQQ	ETF	42.01	42.01	42.0	42.0	1800.0
2008-03-07 05:00:00	QQQ	ETF	42.1	42.12	42.1	42.12	12609.0
2008-03-07 05:30:00	QQQ	ETF	42.08	42.08	42.06	42.06	5082.0
2008-03-07 06:00:00	QQQ	ETF	42.06	42.06	42.06	42.06	231.0
2008-03-07 06:30:00	QQQ	ETF	42.08	42.08	42.08	42.08	600.0
2008-03-07 07:00:00	QQQ	ETF	42.12	42.32	42.12	42.28	298269.0
2008-03-07 07:30:00	QQQ	ETF	42.28	42.3	42.25	42.28	151653.0
2008-03-07 08:00:00	QQQ	ETF	42.28	42.61	41.98	42.27	6366213.0
2008-03-07 08:30:00	QQQ	ETF	42.14	42.28	41.85	41.97	7797516.0
2008-03-07 09:00:00	QQQ	ETF	41.96	41.96	41.83	41.91	2307019.0
2008-03-07 09:30:00	QQQ	ETF	41.91	42.49	41.78	42.42	37550965.0
2008-03-07 10:00:00	QQQ	ETF	42.42	42.54	42.2	42.3805	26253286.0
2008-03-07 10:30:00	QQQ	ETF	42.38	42.64	42.35	42.4199	14744351.0
2008-03-07 11:00:00	QQQ	ETF	42.41	42.41	42.14	42.15	10397496.0
2008-03-07 11:30:00	QQQ	ETF	42.1401	42.2701	41.99	42.0499	11687251.0
2008-03-07 12:00:00	QQQ	ETF	42.05	42.09	41.91	41.9925	6885056.0
2008-03-07 12:30:00	QQQ	ETF	41.9999	42.13	41.89	42.07	7988597.0
2008-03-07 13:00:00	QQQ	ETF	42.07	42.07	41.8	41.95	8545096.0
2008-03-07 13:30:00	QQQ	ETF	41.9499	41.95	41.58	41.61	10653257.0

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

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