PREVIEW / etf_30min / 2008-10-22

all etf 30-min files

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

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-22 04:00:00	SPY	ETF	95.2	95.36	94.99	94.99	11900.0
2008-10-22 04:30:00	SPY	ETF	94.93	94.97	94.55	94.55	5100.0
2008-10-22 05:00:00	SPY	ETF	94.7	94.73	94.26	94.26	4600.0
2008-10-22 05:30:00	SPY	ETF	94.38	94.38	93.9	94.1	1800.0
2008-10-22 06:00:00	SPY	ETF	94.37	94.55	94.3	94.3	8400.0
2008-10-22 06:30:00	SPY	ETF	94.47	94.47	93.7	93.7	192749.0
2008-10-22 07:00:00	SPY	ETF	93.7	93.8	92.79	93.05	623941.0
2008-10-22 07:30:00	SPY	ETF	93.05	93.76	93.04	93.7	1149126.0
2008-10-22 08:00:00	SPY	ETF	93.68	96.85	92.92	93.22	5076707.0
2008-10-22 08:30:00	SPY	ETF	93.22	93.51	92.55	92.86	3147066.0
2008-10-22 09:00:00	SPY	ETF	92.86	93.24	92.44	93.2	3904682.0
2008-10-22 09:30:00	SPY	ETF	93.2	93.5001	91.84	91.91	47510176.0
2008-10-22 10:00:00	SPY	ETF	91.91	92.65	91.25	91.86	46370644.0
2008-10-22 10:30:00	SPY	ETF	91.855	93.13	91.6	92.96	29974001.0
2008-10-22 11:00:00	SPY	ETF	92.96	95.86	91.99	92.13	23734115.0
2008-10-22 11:30:00	SPY	ETF	92.11	92.9	91.8	92.53	19642974.0
2008-10-22 12:00:00	SPY	ETF	92.53	93.3	92.19	92.86	17746698.0
2008-10-22 12:30:00	SPY	ETF	92.86	92.93	92.34	92.47	12184231.0
2008-10-22 13:00:00	SPY	ETF	92.4692	95.5564	91.18	91.46	27508549.0
2008-10-22 13:30:00	SPY	ETF	91.47	95.5564	90.83	91.54	32008467.0
2008-10-22 14:00:00	SPY	ETF	91.54	92.7701	90.92	91.72	28261395.0
2008-10-22 14:30:00	SPY	ETF	91.71	92.39	90.4	90.89	28939360.0
2008-10-22 15:00:00	SPY	ETF	90.9	95.5564	89.73	89.76	45500119.0
2008-10-22 15:30:00	SPY	ETF	89.76	91.15	87.53	89.88	100692142.0
2008-10-22 16:00:00	SPY	ETF	90.27	90.96	88.3	90.63	23190701.0
2008-10-22 16:30:00	SPY	ETF	90.63	95.5564	90.6	90.87	8121022.0
2008-10-22 17:00:00	SPY	ETF	90.84	91.13	90.74	91.12	244617.0
2008-10-22 17:30:00	SPY	ETF	91.17	91.24	90.97	91.02	135125.0
2008-10-22 18:00:00	SPY	ETF	90.99	91.31	90.97	91.25	329132.0
2008-10-22 18:30:00	SPY	ETF	91.21	91.45	91.02	91.2	218600.0
2008-10-22 19:00:00	SPY	ETF	91.17	91.36	91.02	91.36	21034.0
2008-10-22 19:30:00	SPY	ETF	91.32	91.34	90.9	91.21	29922.0
2008-10-22 04:00:00	QQQ	ETF	31.9	31.98	31.85	31.85	10800.0
2008-10-22 04:30:00	QQQ	ETF	31.84	31.97	31.77	31.77	11112.0
2008-10-22 05:00:00	QQQ	ETF	31.63	31.63	31.61	31.61	300.0
2008-10-22 05:30:00	QQQ	ETF	31.53	31.53	31.4	31.47	4300.0
2008-10-22 06:00:00	QQQ	ETF	31.55	31.64	31.52	31.53	24700.0
2008-10-22 06:30:00	QQQ	ETF	31.53	31.55	31.3	31.3	171421.0
2008-10-22 07:00:00	QQQ	ETF	31.35	31.41	31.2	31.3	568089.0
2008-10-22 07:30:00	QQQ	ETF	31.3	31.58	31.27	31.49	1248413.0
2008-10-22 08:00:00	QQQ	ETF	31.5	31.75	31.27	31.28	2076970.0
2008-10-22 08:30:00	QQQ	ETF	31.28	31.4	31.19	31.22	2149658.0
2008-10-22 09:00:00	QQQ	ETF	31.22	31.4	31.2	31.37	2945978.0
2008-10-22 09:30:00	QQQ	ETF	31.37	31.5	31.09	31.13	35604708.0
2008-10-22 10:00:00	QQQ	ETF	31.12	31.33	30.86	30.9999	27893573.0
2008-10-22 10:30:00	QQQ	ETF	31.0	31.6	30.93	31.48	22427780.0
2008-10-22 11:00:00	QQQ	ETF	31.47	31.478	31.08	31.13	13630977.0
2008-10-22 11:30:00	QQQ	ETF	31.13	31.41	31.07	31.32	10485566.0
2008-10-22 12:00:00	QQQ	ETF	31.32	31.55	31.2	31.43	10691351.0
2008-10-22 12:30:00	QQQ	ETF	31.43	31.51	31.33	31.43	7929042.0

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

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