PREVIEW / etf_30min / 2008-10-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-15.parquet
  size:    180 KB
  rows:    6,452

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-15 04:00:00	SPY	ETF	99.0	99.11	99.0	99.11	200.0
2008-10-15 04:30:00	SPY	ETF	99.16	99.16	98.5	98.5	200.0
2008-10-15 05:00:00	SPY	ETF	98.77	98.85	98.53	98.53	6250.0
2008-10-15 05:30:00	SPY	ETF	98.33	98.33	98.0	98.23	5600.0
2008-10-15 06:00:00	SPY	ETF	99.0	99.2	98.7	98.84	1000.0
2008-10-15 06:30:00	SPY	ETF	99.17	99.86	99.09	99.45	96700.0
2008-10-15 07:00:00	SPY	ETF	99.43	99.61	98.62	99.0	527370.0
2008-10-15 07:30:00	SPY	ETF	99.05	99.14	98.21	98.21	376846.0
2008-10-15 08:00:00	SPY	ETF	98.22	99.526	97.45	97.75	3421705.0
2008-10-15 08:30:00	SPY	ETF	97.71	97.81	96.86	97.35	4215188.0
2008-10-15 09:00:00	SPY	ETF	97.36	97.8	97.17	97.47	4143378.0
2008-10-15 09:30:00	SPY	ETF	97.46	97.8	96.32	97.0	48252160.0
2008-10-15 10:00:00	SPY	ETF	97.02	97.02	95.85	96.18	36079598.0
2008-10-15 10:30:00	SPY	ETF	96.18	96.87	95.05	95.13	38613072.0
2008-10-15 11:00:00	SPY	ETF	95.087	95.71	94.83	95.24	32167124.0
2008-10-15 11:30:00	SPY	ETF	95.23	95.84	95.11	95.55	21711346.0
2008-10-15 12:00:00	SPY	ETF	95.54	95.93	94.56	94.85	21227948.0
2008-10-15 12:30:00	SPY	ETF	94.86	95.98	94.86	95.568	16731141.0
2008-10-15 13:00:00	SPY	ETF	95.57	95.6475	94.04	94.33	26282103.0
2008-10-15 13:30:00	SPY	ETF	94.34	94.4575	93.02	93.21	31034671.0
2008-10-15 14:00:00	SPY	ETF	93.22	93.6	92.5	93.51	35848176.0
2008-10-15 14:30:00	SPY	ETF	93.54	94.32	93.05	93.49	30963412.0
2008-10-15 15:00:00	SPY	ETF	93.48	94.75	93.02	93.3795	46563985.0
2008-10-15 15:30:00	SPY	ETF	93.37	93.8675	90.5	90.71	56444166.0
2008-10-15 16:00:00	SPY	ETF	90.72	94.25	89.68	90.35	20108315.0
2008-10-15 16:30:00	SPY	ETF	90.32	99.824	89.8	89.92	4963977.0
2008-10-15 17:00:00	SPY	ETF	89.94	99.824	88.76	88.8	2275242.0
2008-10-15 17:30:00	SPY	ETF	88.8	88.84	88.55	88.74	204269.0
2008-10-15 18:00:00	SPY	ETF	88.78	89.42	88.34	88.61	462071.0
2008-10-15 18:30:00	SPY	ETF	88.65	89.22	88.59	89.07	152371.0
2008-10-15 19:00:00	SPY	ETF	89.07	89.26	88.94	89.17	37640.0
2008-10-15 19:30:00	SPY	ETF	89.1	89.18	88.75	88.9	49697.0
2008-10-15 04:30:00	QQQ	ETF	33.61	33.61	33.4	33.4	200.0
2008-10-15 05:00:00	QQQ	ETF	33.6	33.6	33.54	33.54	1500.0
2008-10-15 05:30:00	QQQ	ETF	33.4	33.45	33.4	33.45	1700.0
2008-10-15 06:00:00	QQQ	ETF	33.5	33.65	33.5	33.6	3500.0
2008-10-15 06:30:00	QQQ	ETF	33.53	33.78	33.53	33.78	7700.0
2008-10-15 07:00:00	QQQ	ETF	33.7	33.7	33.53	33.64	160985.0
2008-10-15 07:30:00	QQQ	ETF	33.64	33.64	33.3	33.4	345473.0
2008-10-15 08:00:00	QQQ	ETF	33.37	33.48	33.17	33.24	710087.0
2008-10-15 08:30:00	QQQ	ETF	33.23	33.27	32.86	33.05	2435516.0
2008-10-15 09:00:00	QQQ	ETF	33.06	33.25	33.03	33.23	845246.0
2008-10-15 09:30:00	QQQ	ETF	33.23	33.35	32.7	33.14	42662113.0
2008-10-15 10:00:00	QQQ	ETF	33.14	33.17	32.81	32.96	23345857.0
2008-10-15 10:30:00	QQQ	ETF	32.95	33.18	32.42	32.49	23268025.0
2008-10-15 11:00:00	QQQ	ETF	32.48	32.69	32.36	32.51	15937365.0
2008-10-15 11:30:00	QQQ	ETF	32.52	32.68	32.39	32.532	12571760.0
2008-10-15 12:00:00	QQQ	ETF	32.53	32.7	32.2	32.29	11815335.0
2008-10-15 12:30:00	QQQ	ETF	32.3	32.55	32.29	32.39	11927372.0
2008-10-15 13:00:00	QQQ	ETF	32.407	32.407	31.9	31.97	16529228.0

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

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