PREVIEW / etf_30min / 2008-01-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-14.parquet
  size:    147 KB
  rows:    5,488

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-01-14 04:00:00	SPY	ETF	140.42	140.44	140.42	140.44	5000.0
2008-01-14 06:00:00	SPY	ETF	140.48	140.48	140.35	140.37	5500.0
2008-01-14 06:30:00	SPY	ETF	140.37	140.37	140.25	140.28	34600.0
2008-01-14 07:00:00	SPY	ETF	140.25	140.5	140.25	140.5	182900.0
2008-01-14 07:30:00	SPY	ETF	140.51	141.12	140.51	140.97	1362800.0
2008-01-14 08:00:00	SPY	ETF	140.5	141.19	140.27	141.05	3799600.0
2008-01-14 08:30:00	SPY	ETF	141.08	141.16	140.97	141.13	425400.0
2008-01-14 09:00:00	SPY	ETF	141.12	141.16	140.15	141.1	646700.0
2008-01-14 09:30:00	SPY	ETF	141.16	141.24	140.43	140.65	27034158.0
2008-01-14 10:00:00	SPY	ETF	140.6599	140.99	140.4	140.82	13111489.0
2008-01-14 10:30:00	SPY	ETF	140.82	141.15	140.74	141.1	10008411.0
2008-01-14 11:00:00	SPY	ETF	141.09	141.35	140.89	141.01	9919116.0
2008-01-14 11:30:00	SPY	ETF	141.0	141.03	140.81	140.81	6900039.0
2008-01-14 12:00:00	SPY	ETF	140.82	140.95	140.54	140.55	8209893.0
2008-01-14 12:30:00	SPY	ETF	140.55	140.86	140.5	140.75	7727999.0
2008-01-14 13:00:00	SPY	ETF	140.75	140.93	140.63	140.73	3926567.0
2008-01-14 13:30:00	SPY	ETF	140.73	141.28	140.67	141.17	9232060.0
2008-01-14 14:00:00	SPY	ETF	141.17	141.28	140.85	141.05	6130577.0
2008-01-14 14:30:00	SPY	ETF	141.04	141.52	141.03	141.47	12106768.0
2008-01-14 15:00:00	SPY	ETF	141.48	141.59	141.09	141.28	12834282.0
2008-01-14 15:30:00	SPY	ETF	141.28	141.86	141.11	141.46	21973641.0
2008-01-14 16:00:00	SPY	ETF	141.46	141.51	141.28	141.43	4728100.0
2008-01-14 16:30:00	SPY	ETF	141.43	141.43	141.26	141.36	7259900.0
2008-01-14 17:00:00	SPY	ETF	141.37	141.42	141.31	141.35	20900.0
2008-01-14 17:30:00	SPY	ETF	141.39	141.78	141.35	141.61	253400.0
2008-01-14 18:00:00	SPY	ETF	141.57	141.6	141.45	141.47	70700.0
2008-01-14 18:30:00	SPY	ETF	141.46	141.47	141.4	141.4	17000.0
2008-01-14 19:00:00	SPY	ETF	141.39	141.39	141.18	141.23	26100.0
2008-01-14 19:30:00	SPY	ETF	141.28	141.31	141.23	141.25	34900.0
2008-01-14 20:00:00	SPY	ETF	141.25	141.25	141.25	141.25	900.0
2008-01-14 04:00:00	QQQ	ETF	47.18	47.18	47.18	47.18	100.0
2008-01-14 05:00:00	QQQ	ETF	47.14	47.2	47.14	47.2	4000.0
2008-01-14 05:30:00	QQQ	ETF	47.23	47.23	47.21	47.21	6200.0
2008-01-14 06:00:00	QQQ	ETF	47.21	47.21	47.15	47.15	2900.0
2008-01-14 06:30:00	QQQ	ETF	47.11	47.11	47.06	47.06	375.0
2008-01-14 07:00:00	QQQ	ETF	47.06	47.22	47.06	47.22	536566.0
2008-01-14 07:30:00	QQQ	ETF	47.23	47.65	47.22	47.61	2369585.0
2008-01-14 08:00:00	QQQ	ETF	47.57	47.87	47.2	47.68	3255662.0
2008-01-14 08:30:00	QQQ	ETF	47.69	47.7	47.58	47.62	1369486.0
2008-01-14 09:00:00	QQQ	ETF	47.62	47.71	47.35	47.69	1841882.0
2008-01-14 09:30:00	QQQ	ETF	47.69	47.82	47.31	47.5001	25843777.0
2008-01-14 10:00:00	QQQ	ETF	47.5	47.69	47.37	47.67	16238251.0
2008-01-14 10:30:00	QQQ	ETF	47.67	47.74	47.56	47.6801	12466717.0
2008-01-14 11:00:00	QQQ	ETF	47.6801	47.9	47.68	47.73	14810476.0
2008-01-14 11:30:00	QQQ	ETF	47.7299	47.75	47.58	47.592	7752079.0
2008-01-14 12:00:00	QQQ	ETF	47.59	47.61	47.43	47.47	8891821.0
2008-01-14 12:30:00	QQQ	ETF	47.47	47.62	47.43	47.56	5632434.0
2008-01-14 13:00:00	QQQ	ETF	47.57	47.65	47.5	47.55	4174653.0
2008-01-14 13:30:00	QQQ	ETF	47.55	47.81	47.53	47.78	11718326.0
2008-01-14 14:00:00	QQQ	ETF	47.79	47.81	47.63	47.77	4514699.0

> showing 50 of 5,488 rows — these rows as CSV

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