PREVIEW / etf_30min / 2009-02-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-20.parquet
  size:    215 KB
  rows:    7,196

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
2009-02-20 04:00:00	SPY	ETF	77.4	77.46	77.26	77.3	2519.0
2009-02-20 04:30:00	SPY	ETF	77.36	77.36	76.96	77.06	6800.0
2009-02-20 05:00:00	SPY	ETF	77.11	77.11	77.01	77.01	1300.0
2009-02-20 05:30:00	SPY	ETF	77.18	77.34	77.09	77.09	3700.0
2009-02-20 06:00:00	SPY	ETF	77.2	77.36	77.2	77.33	1550.0
2009-02-20 06:30:00	SPY	ETF	77.36	77.38	77.25	77.25	5496.0
2009-02-20 07:00:00	SPY	ETF	77.24	77.31	77.07	77.12	459189.0
2009-02-20 07:30:00	SPY	ETF	77.11	77.12	76.82	77.06	763498.0
2009-02-20 08:00:00	SPY	ETF	77.08	77.35	76.85	77.12	2383510.0
2009-02-20 08:30:00	SPY	ETF	77.04	77.38	76.94	76.99	2214666.0
2009-02-20 09:00:00	SPY	ETF	76.98	77.0	76.62	76.73	3789319.0
2009-02-20 09:30:00	SPY	ETF	76.73	77.53	76.7	77.4	44923698.0
2009-02-20 10:00:00	SPY	ETF	77.4	77.89	77.15	77.49	42384980.0
2009-02-20 10:30:00	SPY	ETF	77.49	77.74	77.0	77.11	28611225.0
2009-02-20 11:00:00	SPY	ETF	77.11	77.35	76.54	76.75	22826815.0
2009-02-20 11:30:00	SPY	ETF	76.7406	76.96	76.49	76.76	20466767.0
2009-02-20 12:00:00	SPY	ETF	76.76	77.28	76.7	76.9504	16878034.0
2009-02-20 12:30:00	SPY	ETF	76.95	77.01	76.15	76.33	22428651.0
2009-02-20 13:00:00	SPY	ETF	76.33	76.36	75.77	76.13	28033883.0
2009-02-20 13:30:00	SPY	ETF	76.13	76.63	75.84	76.48	21610823.0
2009-02-20 14:00:00	SPY	ETF	76.49	77.87	76.21	77.16	51289387.0
2009-02-20 14:30:00	SPY	ETF	77.17	78.34	76.0	77.73	51830108.0
2009-02-20 15:00:00	SPY	ETF	77.73	77.74	77.0	77.08	37387535.0
2009-02-20 15:30:00	SPY	ETF	77.08	78.2565	76.81	77.41	53808723.0
2009-02-20 16:00:00	SPY	ETF	77.43	77.6111	76.3201	77.43	15190797.0
2009-02-20 16:30:00	SPY	ETF	77.42	77.51	77.34	77.41	1943261.0
2009-02-20 17:00:00	SPY	ETF	77.44	77.46	77.36	77.41	872667.0
2009-02-20 17:30:00	SPY	ETF	77.41	77.57	77.37	77.52	77155.0
2009-02-20 18:00:00	SPY	ETF	77.52	77.96	77.52	77.6	103712.0
2009-02-20 18:30:00	SPY	ETF	77.79	77.79	77.6	77.75	17825.0
2009-02-20 19:00:00	SPY	ETF	77.7	77.71	77.62	77.62	4678.0
2009-02-20 19:30:00	SPY	ETF	77.62	77.7	77.55	77.65	8985.0
2009-02-20 04:00:00	QQQ	ETF	28.5	28.5	28.47	28.47	1186.0
2009-02-20 04:30:00	QQQ	ETF	28.38	28.38	28.38	28.38	100.0
2009-02-20 05:00:00	QQQ	ETF	28.35	28.42	28.35	28.38	1075.0
2009-02-20 05:30:00	QQQ	ETF	28.42	28.42	28.42	28.42	100.0
2009-02-20 06:00:00	QQQ	ETF	28.45	28.47	28.44	28.45	800.0
2009-02-20 06:30:00	QQQ	ETF	28.46	28.47	28.46	28.46	600.0
2009-02-20 07:00:00	QQQ	ETF	28.42	28.49	28.39	28.47	28939.0
2009-02-20 07:30:00	QQQ	ETF	28.44	28.47	28.37	28.45	65174.0
2009-02-20 08:00:00	QQQ	ETF	28.44	28.5	28.39	28.48	462410.0
2009-02-20 08:30:00	QQQ	ETF	28.46	28.55	28.4	28.43	605605.0
2009-02-20 09:00:00	QQQ	ETF	28.42	28.5	28.34	28.45	1580304.0
2009-02-20 09:30:00	QQQ	ETF	28.46	28.75	28.42	28.67	21959835.0
2009-02-20 10:00:00	QQQ	ETF	28.68	28.88	28.6	28.74	14802045.0
2009-02-20 10:30:00	QQQ	ETF	28.74	28.85	28.63	28.67	10898005.0
2009-02-20 11:00:00	QQQ	ETF	28.67	28.73	28.57	28.71	12667044.0
2009-02-20 11:30:00	QQQ	ETF	28.71	28.74	28.6101	28.68	11811106.0
2009-02-20 12:00:00	QQQ	ETF	28.6825	28.84	28.6701	28.752	7563789.0
2009-02-20 12:30:00	QQQ	ETF	28.75	28.76	28.51	28.565	11728913.0

> showing 50 of 7,196 rows — these rows as CSV

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