PREVIEW / etf_30min / 2008-02-22

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-22.parquet
  size:    155 KB
  rows:    5,642

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-02-22 05:00:00	SPY	ETF	134.64	134.64	134.64	134.64	100.0
2008-02-22 05:30:00	SPY	ETF	134.86	134.86	134.86	134.86	4000.0
2008-02-22 06:30:00	SPY	ETF	134.51	134.53	134.49	134.52	143900.0
2008-02-22 07:00:00	SPY	ETF	134.52	134.7	134.5	134.59	172600.0
2008-02-22 07:30:00	SPY	ETF	134.6	134.6	134.36	134.52	184700.0
2008-02-22 08:00:00	SPY	ETF	134.52	134.92	134.52	134.81	510100.0
2008-02-22 08:30:00	SPY	ETF	134.78	135.27	134.77	135.22	1167000.0
2008-02-22 09:00:00	SPY	ETF	135.23	135.24	134.96	134.98	815100.0
2008-02-22 09:30:00	SPY	ETF	134.97	135.07	134.3	134.47	15368205.0
2008-02-22 10:00:00	SPY	ETF	134.47	134.47	133.58	133.85	19873568.0
2008-02-22 10:30:00	SPY	ETF	133.86	133.93	133.24	133.53	17109696.0
2008-02-22 11:00:00	SPY	ETF	133.54	134.02	133.4	133.75	11540028.0
2008-02-22 11:30:00	SPY	ETF	133.74	134.0	133.46	133.69	6777262.0
2008-02-22 12:00:00	SPY	ETF	133.68	133.7	133.06	133.24	8394594.0
2008-02-22 12:30:00	SPY	ETF	133.24	133.5	133.01	133.32	8696570.0
2008-02-22 13:00:00	SPY	ETF	133.32	133.68	133.15	133.33	8095662.0
2008-02-22 13:30:00	SPY	ETF	133.34	133.54	133.06	133.35	9729748.0
2008-02-22 14:00:00	SPY	ETF	133.34	133.42	133.04	133.19	8406447.0
2008-02-22 14:30:00	SPY	ETF	133.2	133.67	133.06	133.42	10185976.0
2008-02-22 15:00:00	SPY	ETF	133.43	133.62	132.86	133.51	13854431.0
2008-02-22 15:30:00	SPY	ETF	133.52	135.65	133.5	135.64	51433825.0
2008-02-22 16:00:00	SPY	ETF	135.67	135.85	135.44	135.71	3726100.0
2008-02-22 16:30:00	SPY	ETF	135.74	135.8	134.4613	135.41	2139848.0
2008-02-22 17:00:00	SPY	ETF	135.38	135.53	135.26	135.45	178800.0
2008-02-22 17:30:00	SPY	ETF	135.45	135.75	135.45	135.54	87300.0
2008-02-22 18:00:00	SPY	ETF	135.47	135.55	135.47	135.5	15400.0
2008-02-22 18:30:00	SPY	ETF	135.5	135.55	135.5	135.55	12600.0
2008-02-22 19:00:00	SPY	ETF	135.55	135.59	135.45	135.55	10200.0
2008-02-22 19:30:00	SPY	ETF	135.52	135.55	135.47	135.53	4200.0
2008-02-22 05:00:00	QQQ	ETF	43.73	43.73	43.73	43.73	2000.0
2008-02-22 05:30:00	QQQ	ETF	43.71	43.71	43.68	43.68	600.0
2008-02-22 06:00:00	QQQ	ETF	43.66	43.66	43.65	43.65	600.0
2008-02-22 06:30:00	QQQ	ETF	43.64	43.64	43.64	43.64	500.0
2008-02-22 07:00:00	QQQ	ETF	43.56	43.63	43.55	43.59	145863.0
2008-02-22 07:30:00	QQQ	ETF	43.6	43.6	43.54	43.57	124929.0
2008-02-22 08:00:00	QQQ	ETF	43.58	43.7	43.57	43.67	255240.0
2008-02-22 08:30:00	QQQ	ETF	43.67	43.79	43.67	43.79	414764.0
2008-02-22 09:00:00	QQQ	ETF	43.79	43.79	43.66	43.67	640259.0
2008-02-22 09:30:00	QQQ	ETF	43.68	43.68	43.48	43.569	10561232.0
2008-02-22 10:00:00	QQQ	ETF	43.57	43.58	43.2	43.3	12000844.0
2008-02-22 10:30:00	QQQ	ETF	43.3	43.33	43.11	43.13	11980935.0
2008-02-22 11:00:00	QQQ	ETF	43.13	43.25	43.05	43.18	10383577.0
2008-02-22 11:30:00	QQQ	ETF	43.19	43.24	43.07	43.13	5527162.0
2008-02-22 12:00:00	QQQ	ETF	43.1301	43.14	42.87	42.93	8952826.0
2008-02-22 12:30:00	QQQ	ETF	42.9305	43.04	42.86	43.0	5924497.0
2008-02-22 13:00:00	QQQ	ETF	43.0	43.08	42.9	42.9	6686609.0
2008-02-22 13:30:00	QQQ	ETF	42.91	43.0	42.83	42.9199	6998599.0
2008-02-22 14:00:00	QQQ	ETF	42.91	42.95	42.81	42.86	5700792.0
2008-02-22 14:30:00	QQQ	ETF	42.86	43.07	42.82	42.9901	7858472.0
2008-02-22 15:00:00	QQQ	ETF	42.99	43.07	42.78	42.99	14432002.0

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

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