PREVIEW / etf_30min / 2008-10-31

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-31.parquet
  size:    176 KB
  rows:    6,256

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-31 04:00:00	SPY	ETF	94.67	94.67	94.5	94.55	2000.0
2008-10-31 04:30:00	SPY	ETF	94.6	94.6	94.6	94.6	2500.0
2008-10-31 05:00:00	SPY	ETF	94.48	94.48	94.25	94.35	5400.0
2008-10-31 05:30:00	SPY	ETF	94.35	94.57	94.35	94.55	11700.0
2008-10-31 06:00:00	SPY	ETF	94.62	95.0	94.4	94.5	36000.0
2008-10-31 06:30:00	SPY	ETF	94.57	94.85	94.54	94.68	61800.0
2008-10-31 07:00:00	SPY	ETF	94.68	94.94	94.47	94.47	363250.0
2008-10-31 07:30:00	SPY	ETF	94.5	94.77	94.49	94.58	489789.0
2008-10-31 08:00:00	SPY	ETF	94.58	95.62	94.47	94.93	2595116.0
2008-10-31 08:30:00	SPY	ETF	94.92	95.72	94.85	95.65	2770823.0
2008-10-31 09:00:00	SPY	ETF	95.65	95.88	95.04	95.07	3732582.0
2008-10-31 09:30:00	SPY	ETF	95.08	95.48	94.48	95.07	34183077.0
2008-10-31 10:00:00	SPY	ETF	95.07	96.04	94.75	95.69	28513766.0
2008-10-31 10:30:00	SPY	ETF	95.7	96.04	94.96	95.42	23282515.0
2008-10-31 11:00:00	SPY	ETF	95.4278	96.64	95.41	96.44	30668565.0
2008-10-31 11:30:00	SPY	ETF	96.44	96.83	96.2	96.44	20564158.0
2008-10-31 12:00:00	SPY	ETF	96.44	96.52	95.84	96.13	16779245.0
2008-10-31 12:30:00	SPY	ETF	96.12	96.56	95.78	96.37	11993513.0
2008-10-31 13:00:00	SPY	ETF	96.38	97.85	96.34	97.52	22700255.0
2008-10-31 13:30:00	SPY	ETF	97.52	98.2	97.33	97.51	23433481.0
2008-10-31 14:00:00	SPY	ETF	97.51	97.99	96.96	97.49	22856001.0
2008-10-31 14:30:00	SPY	ETF	97.49	98.15	95.0	98.0	25222968.0
2008-10-31 15:00:00	SPY	ETF	98.02	98.57	96.37	96.59	51413699.0
2008-10-31 15:30:00	SPY	ETF	96.58	98.4	95.72	97.17	70616273.0
2008-10-31 16:00:00	SPY	ETF	97.24	97.37	96.5891	97.09	16052857.0
2008-10-31 16:30:00	SPY	ETF	97.07	97.22	97.0	97.12	1440110.0
2008-10-31 17:00:00	SPY	ETF	97.15	97.65	97.12	97.35	114138.0
2008-10-31 17:30:00	SPY	ETF	97.35	97.41	97.27	97.31	123098.0
2008-10-31 18:00:00	SPY	ETF	97.3	97.35	97.08	97.08	97202.0
2008-10-31 18:30:00	SPY	ETF	97.08	97.2	97.08	97.2	1100.0
2008-10-31 19:00:00	SPY	ETF	97.4	97.4	97.06	97.06	8424.0
2008-10-31 19:30:00	SPY	ETF	97.08	97.4	97.06	97.33	5560.0
2008-10-31 04:00:00	QQQ	ETF	32.45	32.45	32.37	32.42	2000.0
2008-10-31 05:00:00	QQQ	ETF	32.35	32.35	32.32	32.32	1200.0
2008-10-31 05:30:00	QQQ	ETF	32.33	32.4	32.33	32.39	2200.0
2008-10-31 06:00:00	QQQ	ETF	32.42	32.42	32.24	32.25	12100.0
2008-10-31 06:30:00	QQQ	ETF	32.24	32.3	32.18	32.27	51900.0
2008-10-31 07:00:00	QQQ	ETF	32.3	32.41	32.27	32.28	14060.0
2008-10-31 07:30:00	QQQ	ETF	32.27	32.36	32.27	32.35	44939.0
2008-10-31 08:00:00	QQQ	ETF	32.35	32.57	32.32	32.51	492206.0
2008-10-31 08:30:00	QQQ	ETF	32.51	32.66	32.4	32.65	944304.0
2008-10-31 09:00:00	QQQ	ETF	32.64	32.66	32.28	32.36	1794374.0
2008-10-31 09:30:00	QQQ	ETF	32.37	32.48	32.09	32.31	23253082.0
2008-10-31 10:00:00	QQQ	ETF	32.3	32.73	32.28	32.56	18565341.0
2008-10-31 10:30:00	QQQ	ETF	32.55	32.7	32.44	32.59	11412841.0
2008-10-31 11:00:00	QQQ	ETF	32.59	32.96	32.57	32.8705	13099109.0
2008-10-31 11:30:00	QQQ	ETF	32.87	33.0	32.72	32.84	13567308.0
2008-10-31 12:00:00	QQQ	ETF	32.84	32.86	32.56	32.71	12183997.0
2008-10-31 12:30:00	QQQ	ETF	32.71	32.84	32.61	32.8	4527189.0
2008-10-31 13:00:00	QQQ	ETF	32.79	33.24	32.77	33.14	9291884.0

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

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