PREVIEW / etf_30min / 2008-10-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-24.parquet
  size:    179 KB
  rows:    6,469

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-10-24 04:00:00	SPY	ETF	86.16	86.42	86.07	86.07	5200.0
2008-10-24 04:30:00	SPY	ETF	86.0	86.1	85.85	85.88	5400.0
2008-10-24 05:00:00	SPY	ETF	85.9	85.9	85.5	85.8	5200.0
2008-10-24 05:30:00	SPY	ETF	85.8	85.8	85.47	85.47	211090.0
2008-10-24 06:00:00	SPY	ETF	85.48	85.8	85.0	85.5	111000.0
2008-10-24 06:30:00	SPY	ETF	85.52	85.64	85.4	85.4	344938.0
2008-10-24 07:00:00	SPY	ETF	85.4	85.65	85.15	85.5	388295.0
2008-10-24 07:30:00	SPY	ETF	85.5	85.7	84.9	85.2	839871.0
2008-10-24 08:00:00	SPY	ETF	85.55	87.41	84.61	84.78	2334922.0
2008-10-24 08:30:00	SPY	ETF	84.77	85.24	83.25	84.25	3691347.0
2008-10-24 09:00:00	SPY	ETF	84.25	84.27	83.35	83.98	2745755.0
2008-10-24 09:30:00	SPY	ETF	84.06	87.56	84.0	87.1	77669281.0
2008-10-24 10:00:00	SPY	ETF	87.09	88.0	85.71	86.23	58528013.0
2008-10-24 10:30:00	SPY	ETF	86.23	87.6	85.86	87.27	37126675.0
2008-10-24 11:00:00	SPY	ETF	87.27	88.51	86.81	88.18	35295491.0
2008-10-24 11:30:00	SPY	ETF	88.18	89.0	87.67	87.96	31833885.0
2008-10-24 12:00:00	SPY	ETF	87.95	88.45	87.04	87.05	20035396.0
2008-10-24 12:30:00	SPY	ETF	87.05	87.6	86.65	87.1	21878773.0
2008-10-24 13:00:00	SPY	ETF	87.1	88.4	87.09	87.67	21097193.0
2008-10-24 13:30:00	SPY	ETF	87.68	87.69	86.18	86.18	24234947.0
2008-10-24 14:00:00	SPY	ETF	86.19	87.5	85.98	86.92	29749432.0
2008-10-24 14:30:00	SPY	ETF	86.91	88.93	86.9	88.71	39554353.0
2008-10-24 15:00:00	SPY	ETF	88.72	89.92	87.25	89.19	53961781.0
2008-10-24 15:30:00	SPY	ETF	89.2	89.54	86.5	87.63	54505042.0
2008-10-24 16:00:00	SPY	ETF	87.44	88.5691	85.4627	87.01	22184290.0
2008-10-24 16:30:00	SPY	ETF	87.09	87.19	87.0	87.17	1289195.0
2008-10-24 17:00:00	SPY	ETF	87.14	87.2	87.06	87.19	44970.0
2008-10-24 17:30:00	SPY	ETF	87.19	87.28	87.14	87.18	107016.0
2008-10-24 18:00:00	SPY	ETF	87.18	87.8	87.18	87.45	61548.0
2008-10-24 18:30:00	SPY	ETF	87.47	87.53	87.3	87.48	43500.0
2008-10-24 19:00:00	SPY	ETF	87.41	87.67	87.41	87.45	21275.0
2008-10-24 19:30:00	SPY	ETF	87.46	87.65	87.36	87.6	63322.0
2008-10-24 04:00:00	QQQ	ETF	29.2	29.32	29.08	29.1	3630.0
2008-10-24 04:30:00	QQQ	ETF	29.04	29.17	28.93	28.93	1900.0
2008-10-24 05:30:00	QQQ	ETF	28.75	28.8	28.75	28.8	1300.0
2008-10-24 06:00:00	QQQ	ETF	28.92	29.04	28.69	28.7	45000.0
2008-10-24 06:30:00	QQQ	ETF	28.68	28.8	28.6	28.75	15200.0
2008-10-24 07:00:00	QQQ	ETF	28.74	28.82	28.6	28.69	94024.0
2008-10-24 07:30:00	QQQ	ETF	28.75	28.78	28.58	28.59	60842.0
2008-10-24 08:00:00	QQQ	ETF	28.6	28.79	28.38	28.61	544948.0
2008-10-24 08:30:00	QQQ	ETF	28.6	28.61	28.35	28.4	974523.0
2008-10-24 09:00:00	QQQ	ETF	28.4	28.41	28.02	28.09	618446.0
2008-10-24 09:30:00	QQQ	ETF	28.12	29.65	28.09	29.44	45962374.0
2008-10-24 10:00:00	QQQ	ETF	29.4299	29.82	28.87	29.09	32403335.0
2008-10-24 10:30:00	QQQ	ETF	29.09	29.47	29.0	29.41	19048785.0
2008-10-24 11:00:00	QQQ	ETF	29.41	29.86	29.22	29.79	19343113.0
2008-10-24 11:30:00	QQQ	ETF	29.8	30.13	29.68	29.86	19738057.0
2008-10-24 12:00:00	QQQ	ETF	29.86	30.07	29.52	29.52	13780571.0
2008-10-24 12:30:00	QQQ	ETF	29.51	29.67	29.32	29.51	12196934.0
2008-10-24 13:00:00	QQQ	ETF	29.5	29.89	29.5	29.6285	13210499.0

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

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