PREVIEW / etf_30min / 2010-08-02

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-02.parquet
  size:    259 KB
  rows:    8,747

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
2010-08-02 04:00:00	SPY	ETF	110.99	111.6	110.99	111.6	12810.0
2010-08-02 04:30:00	SPY	ETF	111.6	111.62	111.52	111.56	3075.0
2010-08-02 05:00:00	SPY	ETF	111.57	111.6	111.56	111.56	1000.0
2010-08-02 05:30:00	SPY	ETF	111.56	111.7	111.56	111.7	3900.0
2010-08-02 06:00:00	SPY	ETF	111.65	111.65	111.56	111.57	5900.0
2010-08-02 06:30:00	SPY	ETF	111.61	111.64	111.57	111.57	22701.0
2010-08-02 07:00:00	SPY	ETF	111.57	111.78	111.57	111.7	591201.0
2010-08-02 07:30:00	SPY	ETF	111.71	111.75	111.61	111.64	212377.0
2010-08-02 08:00:00	SPY	ETF	111.64	111.7	111.15	111.64	824349.0
2010-08-02 08:30:00	SPY	ETF	111.64	111.74	110.27	111.67	1055790.0
2010-08-02 09:00:00	SPY	ETF	111.68	112.0	110.27	111.98	2261848.0
2010-08-02 09:30:00	SPY	ETF	111.99	112.06	111.54	111.769	21797530.0
2010-08-02 10:00:00	SPY	ETF	111.76	112.42	111.72	112.36	25433535.0
2010-08-02 10:30:00	SPY	ETF	112.35	112.49	112.28	112.4	9845862.0
2010-08-02 11:00:00	SPY	ETF	112.3981	112.49	112.1	112.39	8445798.0
2010-08-02 11:30:00	SPY	ETF	112.4	112.67	112.4	112.629	9016093.0
2010-08-02 12:00:00	SPY	ETF	112.62	112.64	112.36	112.375	5381453.0
2010-08-02 12:30:00	SPY	ETF	112.38	112.5618	112.26	112.44	5563016.0
2010-08-02 13:00:00	SPY	ETF	112.43	112.54	112.41	112.42	3738910.0
2010-08-02 13:30:00	SPY	ETF	112.4199	112.57	112.32	112.51	6052624.0
2010-08-02 14:00:00	SPY	ETF	112.5199	112.6733	112.445	112.53	9326707.0
2010-08-02 14:30:00	SPY	ETF	112.53	112.85	112.53	112.8	10650881.0
2010-08-02 15:00:00	SPY	ETF	112.8	112.88	112.66	112.85	9678582.0
2010-08-02 15:30:00	SPY	ETF	112.85	112.94	112.69	112.74	21143307.0
2010-08-02 16:00:00	SPY	ETF	112.74	112.85	112.33	112.72	17874649.0
2010-08-02 16:30:00	SPY	ETF	112.71	112.8774	110.3463	112.69	17763194.0
2010-08-02 17:00:00	SPY	ETF	112.68	112.7	110.27	112.69	174203.0
2010-08-02 17:30:00	SPY	ETF	112.69	112.73	112.65	112.66	46911.0
2010-08-02 18:00:00	SPY	ETF	112.68	112.76	112.62	112.65	110933.0
2010-08-02 18:30:00	SPY	ETF	112.65	112.69	112.64	112.69	42955.0
2010-08-02 19:00:00	SPY	ETF	112.69	112.69	112.65	112.68	17935.0
2010-08-02 19:30:00	SPY	ETF	112.69	112.73	112.66	112.72	37148.0
2010-08-02 04:00:00	QQQ	ETF	45.71	46.31	45.71	46.31	1250.0
2010-08-02 04:30:00	QQQ	ETF	46.29	46.29	46.29	46.29	100.0
2010-08-02 05:30:00	QQQ	ETF	46.31	46.33	46.31	46.33	600.0
2010-08-02 06:00:00	QQQ	ETF	46.31	46.31	46.31	46.31	100.0
2010-08-02 06:30:00	QQQ	ETF	46.28	46.31	46.28	46.29	600.0
2010-08-02 07:00:00	QQQ	ETF	46.3	46.37	46.3	46.31	16878.0
2010-08-02 07:30:00	QQQ	ETF	46.34	46.35	46.3	46.3	135185.0
2010-08-02 08:00:00	QQQ	ETF	46.29	46.32	46.25	46.3	162230.0
2010-08-02 08:30:00	QQQ	ETF	46.3	46.8	45.81	46.3	383430.0
2010-08-02 09:00:00	QQQ	ETF	46.3	46.39	46.29	46.37	203166.0
2010-08-02 09:30:00	QQQ	ETF	46.38	46.41	46.2101	46.38	13291438.0
2010-08-02 10:00:00	QQQ	ETF	46.37	46.72	46.37	46.645	13321870.0
2010-08-02 10:30:00	QQQ	ETF	46.64	46.69	46.56	46.645	2359135.0
2010-08-02 11:00:00	QQQ	ETF	46.65	46.69	46.6	46.66	3161822.0
2010-08-02 11:30:00	QQQ	ETF	46.66	46.75	46.66	46.701	2471525.0
2010-08-02 12:00:00	QQQ	ETF	46.7	46.72	46.6	46.6	1023424.0
2010-08-02 12:30:00	QQQ	ETF	46.6033	46.64	46.54	46.61	1183445.0
2010-08-02 13:00:00	QQQ	ETF	46.602	46.66	46.59	46.61	621040.0

> showing 50 of 8,747 rows — these rows as CSV

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