PREVIEW / etf_30min / 2008-11-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-14.parquet
  size:    182 KB
  rows:    6,354

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-14 04:00:00	SPY	ETF	90.22	90.22	89.95	89.95	20300.0
2008-11-14 04:30:00	SPY	ETF	90.0	90.12	89.8	89.8	7700.0
2008-11-14 05:00:00	SPY	ETF	89.79	90.02	89.43	90.02	3624.0
2008-11-14 05:30:00	SPY	ETF	90.05	90.17	89.94	90.13	5900.0
2008-11-14 06:00:00	SPY	ETF	90.14	90.36	90.01	90.28	16900.0
2008-11-14 06:30:00	SPY	ETF	90.32	90.4	90.21	90.34	66823.0
2008-11-14 07:00:00	SPY	ETF	90.31	90.59	89.78	89.99	332470.0
2008-11-14 07:30:00	SPY	ETF	90.0	90.45	89.74	89.78	747425.0
2008-11-14 08:00:00	SPY	ETF	89.79	90.3	89.25	89.48	2314231.0
2008-11-14 08:30:00	SPY	ETF	89.53	90.8598	89.24	89.87	4773145.0
2008-11-14 09:00:00	SPY	ETF	89.88	91.17	89.26	89.43	3338322.0
2008-11-14 09:30:00	SPY	ETF	89.41	91.11	89.3	90.67	50186109.0
2008-11-14 10:00:00	SPY	ETF	90.66	90.96	88.92	89.39	41317838.0
2008-11-14 10:30:00	SPY	ETF	89.39	89.39	88.13	88.5001	36123161.0
2008-11-14 11:00:00	SPY	ETF	88.5	89.05	88.01	88.42	24014696.0
2008-11-14 11:30:00	SPY	ETF	88.41	88.54	87.84	88.0	19978771.0
2008-11-14 12:00:00	SPY	ETF	88.0	88.02	87.23	87.87	24064523.0
2008-11-14 12:30:00	SPY	ETF	87.87	88.74	87.55	88.44	23213513.0
2008-11-14 13:00:00	SPY	ETF	88.43	88.68	87.42	88.65	19843348.0
2008-11-14 13:30:00	SPY	ETF	88.65	89.28	87.8	88.76	29044978.0
2008-11-14 14:00:00	SPY	ETF	88.77	90.71	88.57	89.98	40261724.0
2008-11-14 14:30:00	SPY	ETF	89.9575	91.79	89.5	91.69	47939203.0
2008-11-14 15:00:00	SPY	ETF	91.69	92.06	90.24	90.58	60027231.0
2008-11-14 15:30:00	SPY	ETF	90.575	90.75	87.32	87.55	76849502.0
2008-11-14 16:00:00	SPY	ETF	87.56	91.94	86.32	86.55	22468729.0
2008-11-14 16:30:00	SPY	ETF	86.55	86.92	86.55	86.75	2096283.0
2008-11-14 17:00:00	SPY	ETF	86.75	86.79	86.55	86.7	5296231.0
2008-11-14 17:30:00	SPY	ETF	86.67	87.62	86.65	86.72	794425.0
2008-11-14 18:00:00	SPY	ETF	86.7	91.4135	86.65	86.76	1082683.0
2008-11-14 18:30:00	SPY	ETF	86.79	86.79	86.69	86.78	23127.0
2008-11-14 19:00:00	SPY	ETF	86.73	86.8	86.68	86.78	12048.0
2008-11-14 19:30:00	SPY	ETF	86.79	86.85	86.7	86.8	41175.0
2008-11-14 05:00:00	QQQ	ETF	30.01	30.06	29.95	30.06	1620.0
2008-11-14 05:30:00	QQQ	ETF	30.14	30.14	30.14	30.14	300.0
2008-11-14 06:00:00	QQQ	ETF	30.18	30.18	30.18	30.18	300.0
2008-11-14 07:00:00	QQQ	ETF	30.25	30.25	30.09	30.17	174500.0
2008-11-14 07:30:00	QQQ	ETF	30.14	30.25	30.12	30.15	195891.0
2008-11-14 08:00:00	QQQ	ETF	30.13	30.14	29.84	29.87	1047762.0
2008-11-14 08:30:00	QQQ	ETF	29.94	30.15	29.79	29.93	1147975.0
2008-11-14 09:00:00	QQQ	ETF	29.92	29.95	29.77	29.81	1757426.0
2008-11-14 09:30:00	QQQ	ETF	29.8	30.06	29.62	29.89	27843198.0
2008-11-14 10:00:00	QQQ	ETF	29.89	29.98	29.37	29.54	20626262.0
2008-11-14 10:30:00	QQQ	ETF	29.54	29.56	29.27	29.37	20357521.0
2008-11-14 11:00:00	QQQ	ETF	29.37	29.49	29.15	29.2701	13016920.0
2008-11-14 11:30:00	QQQ	ETF	29.27	29.33	29.09	29.19	10602391.0
2008-11-14 12:00:00	QQQ	ETF	29.19	29.23	28.96	29.2	10170899.0
2008-11-14 12:30:00	QQQ	ETF	29.2	29.56	29.13	29.46	11949019.0
2008-11-14 13:00:00	QQQ	ETF	29.46	29.49	29.16	29.49	8583976.0
2008-11-14 13:30:00	QQQ	ETF	29.49	29.69	29.32	29.5	15437480.0
2008-11-14 14:00:00	QQQ	ETF	29.51	30.04	29.47	29.8305	16103282.0

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

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