PREVIEW / etf_30min / 2008-10-09

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-09.parquet
  size:    184 KB
  rows:    6,505

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-09 04:00:00	SPY	ETF	100.27	100.33	100.08	100.08	4500.0
2008-10-09 04:30:00	SPY	ETF	100.2	100.47	100.15	100.4	5800.0
2008-10-09 05:00:00	SPY	ETF	100.4	100.4	99.75	99.75	9400.0
2008-10-09 05:30:00	SPY	ETF	99.95	99.95	99.23	99.47	22400.0
2008-10-09 06:00:00	SPY	ETF	99.4	99.62	99.0	99.19	58100.0
2008-10-09 06:30:00	SPY	ETF	99.17	99.45	99.0	99.44	79400.0
2008-10-09 07:00:00	SPY	ETF	99.5	99.5	98.88	99.35	425815.0
2008-10-09 07:30:00	SPY	ETF	99.38	99.88	98.75	98.78	780776.0
2008-10-09 08:00:00	SPY	ETF	98.76	100.39	97.75	98.69	3057801.0
2008-10-09 08:30:00	SPY	ETF	98.7	99.68	98.15	99.54	3829481.0
2008-10-09 09:00:00	SPY	ETF	99.54	99.72	99.19	99.65	2603870.0
2008-10-09 09:30:00	SPY	ETF	99.66	100.62	99.0	99.14	54378435.0
2008-10-09 10:00:00	SPY	ETF	99.15	99.61	97.87	97.88	35364805.0
2008-10-09 10:30:00	SPY	ETF	97.88	98.64	97.01	97.22	39407721.0
2008-10-09 11:00:00	SPY	ETF	97.21	97.93	95.93	97.3	41395239.0
2008-10-09 11:30:00	SPY	ETF	97.31	99.0	97.01	97.46	36759279.0
2008-10-09 12:00:00	SPY	ETF	97.45	98.5012	97.12	97.67	15473486.0
2008-10-09 12:30:00	SPY	ETF	97.68	97.82	96.69	97.15	13696558.0
2008-10-09 13:00:00	SPY	ETF	97.15	98.33	97.03	97.87	21203226.0
2008-10-09 13:30:00	SPY	ETF	97.86	98.35	96.91	97.3	21653112.0
2008-10-09 14:00:00	SPY	ETF	97.3	97.66	96.25	96.54	21887321.0
2008-10-09 14:30:00	SPY	ETF	96.53	96.87	95.55	95.69	32556312.0
2008-10-09 15:00:00	SPY	ETF	95.69	95.71	93.58	93.77	61219069.0
2008-10-09 15:30:00	SPY	ETF	93.76	96.35	90.9	91.75	93906165.0
2008-10-09 16:00:00	SPY	ETF	91.72	98.48	90.27	90.89	16363298.0
2008-10-09 16:30:00	SPY	ETF	90.87	99.56	90.3	90.73	10302304.0
2008-10-09 17:00:00	SPY	ETF	90.68	99.58	90.68	91.3	452759.0
2008-10-09 17:30:00	SPY	ETF	91.3	91.4	91.01	91.22	2697037.0
2008-10-09 18:00:00	SPY	ETF	91.22	91.32	90.5	90.75	3770250.0
2008-10-09 18:30:00	SPY	ETF	90.8	91.12	90.58	91.12	64002.0
2008-10-09 19:00:00	SPY	ETF	91.01	91.25	90.88	90.88	72917.0
2008-10-09 19:30:00	SPY	ETF	90.88	91.0	90.8	90.85	89250.0
2008-10-09 04:00:00	QQQ	ETF	33.43	33.43	33.43	33.43	1400.0
2008-10-09 04:30:00	QQQ	ETF	33.37	33.46	33.32	33.42	4200.0
2008-10-09 05:00:00	QQQ	ETF	33.35	33.35	33.35	33.35	100.0
2008-10-09 05:30:00	QQQ	ETF	33.37	33.37	33.24	33.24	10200.0
2008-10-09 06:00:00	QQQ	ETF	33.2	33.2	33.04	33.04	16000.0
2008-10-09 06:30:00	QQQ	ETF	33.05	33.18	33.05	33.18	4000.0
2008-10-09 07:00:00	QQQ	ETF	33.09	33.18	33.05	33.05	189473.0
2008-10-09 07:30:00	QQQ	ETF	33.0	33.21	32.84	32.88	548576.0
2008-10-09 08:00:00	QQQ	ETF	32.88	32.96	32.72	32.9	820916.0
2008-10-09 08:30:00	QQQ	ETF	32.89	33.27	32.89	33.13	2279163.0
2008-10-09 09:00:00	QQQ	ETF	33.13	33.2	33.02	33.15	1204771.0
2008-10-09 09:30:00	QQQ	ETF	33.15	33.68	33.0	33.18	30205426.0
2008-10-09 10:00:00	QQQ	ETF	33.18	33.45	32.89	32.92	24824308.0
2008-10-09 10:30:00	QQQ	ETF	32.92	33.21	32.74	32.87	24635155.0
2008-10-09 11:00:00	QQQ	ETF	32.87	33.13	32.37	32.92	25757426.0
2008-10-09 11:30:00	QQQ	ETF	32.92	33.46	32.88	33.13	26489436.0
2008-10-09 12:00:00	QQQ	ETF	33.14	33.34	33.03	33.12	9739843.0
2008-10-09 12:30:00	QQQ	ETF	33.13	33.16	32.79	32.95	10531728.0

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

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