PREVIEW / etf_30min / 2008-11-06

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-06.parquet
  size:    181 KB
  rows:    6,341

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-06 04:00:00	SPY	ETF	95.31	95.31	95.31	95.31	1500.0
2008-11-06 04:30:00	SPY	ETF	95.2	95.21	94.81	94.81	5300.0
2008-11-06 05:00:00	SPY	ETF	94.6	94.6	94.25	94.56	5300.0
2008-11-06 05:30:00	SPY	ETF	94.52	94.7	94.52	94.64	3900.0
2008-11-06 06:00:00	SPY	ETF	94.34	94.35	93.92	94.02	9000.0
2008-11-06 06:30:00	SPY	ETF	94.21	94.81	94.17	94.78	64900.0
2008-11-06 07:00:00	SPY	ETF	95.0	95.6	94.52	95.41	1112924.0
2008-11-06 07:30:00	SPY	ETF	95.37	96.1	94.13	94.22	1268127.0
2008-11-06 08:00:00	SPY	ETF	94.26	95.76	93.9	94.4	2428972.0
2008-11-06 08:30:00	SPY	ETF	94.36	95.25	94.3	94.83	2135198.0
2008-11-06 09:00:00	SPY	ETF	94.85	96.19	94.29	94.44	1951400.0
2008-11-06 09:30:00	SPY	ETF	94.46	95.44	93.94	94.26	45503023.0
2008-11-06 10:00:00	SPY	ETF	94.26	94.92	93.45	93.64	31167524.0
2008-11-06 10:30:00	SPY	ETF	93.66	93.6805	92.72	93.27	30264009.0
2008-11-06 11:00:00	SPY	ETF	93.26	93.46	92.27	92.64	28474673.0
2008-11-06 11:30:00	SPY	ETF	92.65	92.87	92.06	92.42	28033550.0
2008-11-06 12:00:00	SPY	ETF	92.42	92.68	91.48	91.55	32450641.0
2008-11-06 12:30:00	SPY	ETF	91.54	91.93	91.22	91.67	30263221.0
2008-11-06 13:00:00	SPY	ETF	91.68	91.8	90.61	91.17	29289010.0
2008-11-06 13:30:00	SPY	ETF	91.16	91.27	90.2991	91.26	30167416.0
2008-11-06 14:00:00	SPY	ETF	91.26	91.96	90.85	91.09	34990770.0
2008-11-06 14:30:00	SPY	ETF	91.08	95.2	91.03	91.7	29853453.0
2008-11-06 15:00:00	SPY	ETF	91.71	91.95	90.49	90.67	37269632.0
2008-11-06 15:30:00	SPY	ETF	90.67	91.24	90.06	90.65	59935171.0
2008-11-06 16:00:00	SPY	ETF	90.66	96.19	90.3435	90.75	12353054.0
2008-11-06 16:30:00	SPY	ETF	90.75	91.26	90.73	91.15	4575511.0
2008-11-06 17:00:00	SPY	ETF	91.1	91.15	90.91	90.98	78510.0
2008-11-06 17:30:00	SPY	ETF	90.92	95.4451	90.49	90.83	3343486.0
2008-11-06 18:00:00	SPY	ETF	90.87	90.92	90.77	90.89	142677.0
2008-11-06 18:30:00	SPY	ETF	90.85	90.99	90.84	90.97	155850.0
2008-11-06 19:00:00	SPY	ETF	90.97	91.19	90.97	91.05	49599.0
2008-11-06 19:30:00	SPY	ETF	90.97	91.05	90.8	90.83	18719.0
2008-11-06 04:30:00	QQQ	ETF	31.49	31.49	31.49	31.49	4950.0
2008-11-06 05:00:00	QQQ	ETF	31.38	31.38	31.18	31.23	5300.0
2008-11-06 05:30:00	QQQ	ETF	31.33	31.33	31.26	31.26	1400.0
2008-11-06 06:00:00	QQQ	ETF	31.23	31.23	31.1	31.1	1800.0
2008-11-06 06:30:00	QQQ	ETF	31.08	31.35	31.08	31.34	1200.0
2008-11-06 07:00:00	QQQ	ETF	31.45	31.68	31.42	31.68	121100.0
2008-11-06 07:30:00	QQQ	ETF	31.69	31.79	31.11	31.16	459791.0
2008-11-06 08:00:00	QQQ	ETF	31.21	31.67	31.15	31.37	1534949.0
2008-11-06 08:30:00	QQQ	ETF	31.3	31.71	31.26	31.58	991897.0
2008-11-06 09:00:00	QQQ	ETF	31.58	31.6	31.37	31.49	766212.0
2008-11-06 09:30:00	QQQ	ETF	31.49	31.87	31.2	31.28	31575108.0
2008-11-06 10:00:00	QQQ	ETF	31.281	31.53	31.02	31.26	15093375.0
2008-11-06 10:30:00	QQQ	ETF	31.26	31.27	30.89	31.15	16633931.0
2008-11-06 11:00:00	QQQ	ETF	31.15	31.2	30.89	31.09	11487360.0
2008-11-06 11:30:00	QQQ	ETF	31.0899	31.2	30.91	31.06	10104420.0
2008-11-06 12:00:00	QQQ	ETF	31.0625	31.16	30.73	30.768	14293788.0
2008-11-06 12:30:00	QQQ	ETF	30.76	30.87	30.65	30.8	11737633.0
2008-11-06 13:00:00	QQQ	ETF	30.8	30.84	30.56	30.7401	10988468.0

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

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