PREVIEW / etf_30min / 2013-10-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-11.parquet
  size:    326 KB
  rows:    10,870

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
2013-10-11 04:00:00	SPY	ETF	168.95	169.08	168.95	169.08	15800.0
2013-10-11 04:30:00	SPY	ETF	169.09	169.25	169.09	169.25	13915.0
2013-10-11 05:00:00	SPY	ETF	169.25	169.29	169.13	169.17	8475.0
2013-10-11 05:30:00	SPY	ETF	169.15	169.2	169.13	169.2	5300.0
2013-10-11 06:00:00	SPY	ETF	169.21	169.21	169.1	169.12	9300.0
2013-10-11 06:30:00	SPY	ETF	169.09	169.19	168.99	169.13	73600.0
2013-10-11 07:00:00	SPY	ETF	169.11	169.2	169.08	169.18	225285.0
2013-10-11 07:30:00	SPY	ETF	169.17	169.25	169.03	169.07	335799.0
2013-10-11 08:00:00	SPY	ETF	169.05	169.17	168.83	168.9	625498.0
2013-10-11 08:30:00	SPY	ETF	168.9	168.94	168.8	168.89	314954.0
2013-10-11 09:00:00	SPY	ETF	168.9	169.0	168.7	168.9	1071641.0
2013-10-11 09:30:00	SPY	ETF	168.91	169.53	168.77	169.52	12188045.0
2013-10-11 10:00:00	SPY	ETF	169.52	169.65	169.34	169.47	8801699.0
2013-10-11 10:30:00	SPY	ETF	169.48	169.48	169.06	169.32	6394300.0
2013-10-11 11:00:00	SPY	ETF	169.32	169.43	169.24	169.32	4271616.0
2013-10-11 11:30:00	SPY	ETF	169.32	169.95	169.319	169.93	10570011.0
2013-10-11 12:00:00	SPY	ETF	169.92	170.27	169.895	170.1	7552881.0
2013-10-11 12:30:00	SPY	ETF	170.1	170.22	170.06	170.17	3200635.0
2013-10-11 13:00:00	SPY	ETF	170.16	170.32	169.94	170.04	5980028.0
2013-10-11 13:30:00	SPY	ETF	170.035	170.13	169.93	170.09	3120108.0
2013-10-11 14:00:00	SPY	ETF	170.0897	170.21	170.02	170.145	3043904.0
2013-10-11 14:30:00	SPY	ETF	170.15	170.16	170.0	170.06	2865153.0
2013-10-11 15:00:00	SPY	ETF	170.055	170.08	169.81	169.99	5590872.0
2013-10-11 15:30:00	SPY	ETF	169.99	170.27	169.78	170.24	15761424.0
2013-10-11 16:00:00	SPY	ETF	170.24	170.44	169.1961	170.41	5392105.0
2013-10-11 16:30:00	SPY	ETF	170.37	170.47	170.34	170.45	1361741.0
2013-10-11 17:00:00	SPY	ETF	170.45	170.49	170.31	170.4	112720.0
2013-10-11 17:30:00	SPY	ETF	170.37	170.5	170.37	170.5	10590.0
2013-10-11 18:00:00	SPY	ETF	170.46	170.57	170.46	170.48	36411.0
2013-10-11 18:30:00	SPY	ETF	170.47	170.53	170.42	170.45	5169.0
2013-10-11 19:00:00	SPY	ETF	170.45	170.49	170.39	170.44	18297.0
2013-10-11 19:30:00	SPY	ETF	170.4	170.44	170.38	170.41	12826.0
2013-10-11 04:00:00	QQQ	ETF	78.47	78.52	78.46	78.52	5100.0
2013-10-11 04:30:00	QQQ	ETF	78.53	78.61	78.53	78.6	8300.0
2013-10-11 05:00:00	QQQ	ETF	78.61	78.61	78.55	78.56	3300.0
2013-10-11 05:30:00	QQQ	ETF	78.55	78.58	78.54	78.58	3200.0
2013-10-11 06:00:00	QQQ	ETF	78.56	78.56	78.5	78.51	4100.0
2013-10-11 06:30:00	QQQ	ETF	78.5	78.53	78.46	78.5	9200.0
2013-10-11 07:00:00	QQQ	ETF	78.5	78.52	78.49	78.51	6400.0
2013-10-11 07:30:00	QQQ	ETF	78.52	78.52	78.46	78.46	5850.0
2013-10-11 08:00:00	QQQ	ETF	78.45	78.47	78.38	78.4	22200.0
2013-10-11 08:30:00	QQQ	ETF	78.39	78.46	78.37	78.44	25616.0
2013-10-11 09:00:00	QQQ	ETF	78.45	78.5	78.38	78.4	62875.0
2013-10-11 09:30:00	QQQ	ETF	78.42	78.88	78.4	78.86	2829612.0
2013-10-11 10:00:00	QQQ	ETF	78.86	78.935	78.73	78.89	2859265.0
2013-10-11 10:30:00	QQQ	ETF	78.89	78.89	78.65	78.7901	1530126.0
2013-10-11 11:00:00	QQQ	ETF	78.79	78.85	78.71	78.77	1075443.0
2013-10-11 11:30:00	QQQ	ETF	78.77	79.14	78.75	79.13	2020366.0
2013-10-11 12:00:00	QQQ	ETF	79.12	79.24	79.11	79.1599	2020149.0
2013-10-11 12:30:00	QQQ	ETF	79.16	79.26	79.15	79.21	733669.0

> showing 50 of 10,870 rows — these rows as CSV

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