PREVIEW / etf_30min / 2008-11-11

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-11.parquet
  size:    174 KB
  rows:    6,135

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-11-11 04:00:00	SPY	ETF	92.04	92.04	91.8	91.8	400.0
2008-11-11 04:30:00	SPY	ETF	91.81	92.13	91.6	91.6	20200.0
2008-11-11 05:00:00	SPY	ETF	91.73	91.73	91.3	91.7	5600.0
2008-11-11 05:30:00	SPY	ETF	91.5	91.8	91.5	91.8	600.0
2008-11-11 06:00:00	SPY	ETF	91.71	91.71	91.6	91.6	7800.0
2008-11-11 06:30:00	SPY	ETF	91.62	91.62	91.24	91.26	19940.0
2008-11-11 07:00:00	SPY	ETF	91.34	91.39	90.48	90.68	473480.0
2008-11-11 07:30:00	SPY	ETF	90.67	91.08	90.53	90.94	606153.0
2008-11-11 08:00:00	SPY	ETF	90.94	92.63	90.55	90.67	1166634.0
2008-11-11 08:30:00	SPY	ETF	90.67	91.12	90.64	90.87	1159979.0
2008-11-11 09:00:00	SPY	ETF	90.89	91.08	90.51	90.76	1128459.0
2008-11-11 09:30:00	SPY	ETF	90.76	90.95	89.25	89.53	46076675.0
2008-11-11 10:00:00	SPY	ETF	89.54	90.13	89.26	89.65	30724856.0
2008-11-11 10:30:00	SPY	ETF	89.65	90.04	89.1	89.18	22955227.0
2008-11-11 11:00:00	SPY	ETF	89.19	92.1377	88.85	89.34	18818739.0
2008-11-11 11:30:00	SPY	ETF	89.33	89.88	89.0	89.29	16250707.0
2008-11-11 12:00:00	SPY	ETF	89.29	89.39	88.65	88.85	14184771.0
2008-11-11 12:30:00	SPY	ETF	88.86	89.33	88.72	89.32	9589079.0
2008-11-11 13:00:00	SPY	ETF	89.33	90.51	89.0	89.17	13851990.0
2008-11-11 13:30:00	SPY	ETF	89.17	90.4	88.9	90.3501	22010421.0
2008-11-11 14:00:00	SPY	ETF	90.35	91.68	89.89	91.56	53868629.0
2008-11-11 14:30:00	SPY	ETF	91.56	92.04	89.94	89.98	51764853.0
2008-11-11 15:00:00	SPY	ETF	89.98	90.97	89.87	90.43	38508243.0
2008-11-11 15:30:00	SPY	ETF	90.41	90.53	89.03	90.1	56160257.0
2008-11-11 16:00:00	SPY	ETF	90.11	92.138	89.0316	89.76	8877300.0
2008-11-11 16:30:00	SPY	ETF	89.76	89.92	89.7	89.72	6029044.0
2008-11-11 17:00:00	SPY	ETF	89.72	89.76	89.65	89.72	146860.0
2008-11-11 17:30:00	SPY	ETF	89.74	89.78	89.64	89.74	62853.0
2008-11-11 18:00:00	SPY	ETF	89.67	89.86	89.67	89.8	139360.0
2008-11-11 18:30:00	SPY	ETF	89.75	89.93	89.72	89.82	16325.0
2008-11-11 19:00:00	SPY	ETF	89.85	90.19	89.83	90.19	38207.0
2008-11-11 19:30:00	SPY	ETF	90.13	90.28	90.13	90.17	42666.0
2008-11-11 04:00:00	QQQ	ETF	30.7	30.7	30.7	30.7	100.0
2008-11-11 06:00:00	QQQ	ETF	30.58	30.58	30.58	30.58	400.0
2008-11-11 06:30:00	QQQ	ETF	30.46	30.53	30.46	30.53	13340.0
2008-11-11 07:00:00	QQQ	ETF	30.5	30.5	30.26	30.35	211350.0
2008-11-11 07:30:00	QQQ	ETF	30.35	30.47	30.33	30.43	106832.0
2008-11-11 08:00:00	QQQ	ETF	30.7	30.7	30.37	30.37	433046.0
2008-11-11 08:30:00	QQQ	ETF	30.37	30.52	30.37	30.46	494107.0
2008-11-11 09:00:00	QQQ	ETF	30.46	30.51	30.37	30.47	592898.0
2008-11-11 09:30:00	QQQ	ETF	30.47	30.51	29.87	29.9595	19708357.0
2008-11-11 10:00:00	QQQ	ETF	29.95	30.07	29.85	29.95	12369762.0
2008-11-11 10:30:00	QQQ	ETF	29.9495	30.06	29.83	29.8699	9049152.0
2008-11-11 11:00:00	QQQ	ETF	29.86	29.94	29.75	29.859	8456714.0
2008-11-11 11:30:00	QQQ	ETF	29.84	30.0101	29.77	29.88	4861192.0
2008-11-11 12:00:00	QQQ	ETF	29.89	29.91	29.72	29.79	4365044.0
2008-11-11 12:30:00	QQQ	ETF	29.79	29.93	29.77	29.93	3491395.0
2008-11-11 13:00:00	QQQ	ETF	29.93	30.01	29.81	29.86	6315455.0
2008-11-11 13:30:00	QQQ	ETF	29.87	30.22	29.7799	30.18	8994999.0
2008-11-11 14:00:00	QQQ	ETF	30.18	30.61	30.03	30.59	18317859.0

> showing 50 of 6,135 rows — these rows as CSV

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