PREVIEW / etf_30min / 2014-01-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-17.parquet
  size:    340 KB
  rows:    11,458

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
2014-01-17 04:00:00	SPY	ETF	184.12	184.22	184.12	184.18	11149.0
2014-01-17 04:30:00	SPY	ETF	184.18	184.28	184.17	184.28	2126.0
2014-01-17 05:00:00	SPY	ETF	184.3	184.56	184.3	184.56	4114.0
2014-01-17 05:30:00	SPY	ETF	184.56	184.63	184.56	184.57	4759.0
2014-01-17 06:00:00	SPY	ETF	184.57	184.6	184.53	184.55	40595.0
2014-01-17 06:30:00	SPY	ETF	184.56	184.62	184.54	184.61	14887.0
2014-01-17 07:00:00	SPY	ETF	184.61	184.63	184.43	184.47	149538.0
2014-01-17 07:30:00	SPY	ETF	184.47	184.54	184.36	184.39	367472.0
2014-01-17 08:00:00	SPY	ETF	184.58	184.58	184.2	184.28	1044651.0
2014-01-17 08:30:00	SPY	ETF	184.27	184.29	184.01	184.19	2122240.0
2014-01-17 09:00:00	SPY	ETF	184.19	184.24	184.08	184.1	2366312.0
2014-01-17 09:30:00	SPY	ETF	184.1	184.3	183.78	184.0	16150775.0
2014-01-17 10:00:00	SPY	ETF	183.99	184.18	183.83	184.062	5796937.0
2014-01-17 10:30:00	SPY	ETF	184.06	184.23	184.04	184.21	4487326.0
2014-01-17 11:00:00	SPY	ETF	184.21	184.36	184.21	184.255	3179815.0
2014-01-17 11:30:00	SPY	ETF	184.25	184.33	184.17	184.28	3241462.0
2014-01-17 12:00:00	SPY	ETF	184.28	184.45	184.24	184.405	2773146.0
2014-01-17 12:30:00	SPY	ETF	184.41	184.42	184.22	184.23	1757765.0
2014-01-17 13:00:00	SPY	ETF	184.23	184.29	183.89	184.01	7208170.0
2014-01-17 13:30:00	SPY	ETF	184.02	184.11	183.91	184.08	2723881.0
2014-01-17 14:00:00	SPY	ETF	184.09	184.17	183.99	184.07	3793833.0
2014-01-17 14:30:00	SPY	ETF	184.07	184.07	183.87	183.915	4196512.0
2014-01-17 15:00:00	SPY	ETF	183.92	184.02	183.52	183.59	9937366.0
2014-01-17 15:30:00	SPY	ETF	183.59	183.76	183.32	183.61	21520877.0
2014-01-17 16:00:00	SPY	ETF	183.6	184.4154	183.54	183.8	5727870.0
2014-01-17 16:30:00	SPY	ETF	183.82	184.1458	183.649	183.79	1996980.0
2014-01-17 17:00:00	SPY	ETF	183.79	183.8	183.74	183.75	115682.0
2014-01-17 17:30:00	SPY	ETF	183.75	183.75	183.64	183.64	133937.0
2014-01-17 18:00:00	SPY	ETF	183.64	183.64	183.58	183.6	3821210.0
2014-01-17 18:30:00	SPY	ETF	183.6	183.65	183.57	183.64	30334.0
2014-01-17 19:00:00	SPY	ETF	183.61	183.7	183.6	183.69	10799.0
2014-01-17 19:30:00	SPY	ETF	183.68	183.7	183.6	183.6	17166.0
2014-01-17 04:00:00	QQQ	ETF	88.22	88.28	88.22	88.28	6500.0
2014-01-17 04:30:00	QQQ	ETF	88.27	88.3	88.27	88.3	11000.0
2014-01-17 05:00:00	QQQ	ETF	88.35	88.47	88.35	88.47	2900.0
2014-01-17 05:30:00	QQQ	ETF	88.47	88.49	88.47	88.49	200.0
2014-01-17 06:00:00	QQQ	ETF	88.46	88.47	88.46	88.46	1700.0
2014-01-17 06:30:00	QQQ	ETF	88.46	88.46	88.45	88.45	7000.0
2014-01-17 07:00:00	QQQ	ETF	88.44	88.45	88.36	88.36	133000.0
2014-01-17 07:30:00	QQQ	ETF	88.4	88.4	88.32	88.32	27800.0
2014-01-17 08:00:00	QQQ	ETF	88.37	88.37	88.16	88.26	270800.0
2014-01-17 08:30:00	QQQ	ETF	88.25	88.25	88.11	88.2	307180.0
2014-01-17 09:00:00	QQQ	ETF	88.2	88.4269	88.12	88.13	3323562.0
2014-01-17 09:30:00	QQQ	ETF	88.12	88.29	87.93	88.07	5297808.0
2014-01-17 10:00:00	QQQ	ETF	88.07	88.2	88.0001	88.1199	2138313.0
2014-01-17 10:30:00	QQQ	ETF	88.12	88.25	88.08	88.23	1024490.0
2014-01-17 11:00:00	QQQ	ETF	88.23	88.305	88.2	88.24	1086589.0
2014-01-17 11:30:00	QQQ	ETF	88.24	88.27	88.2	88.2501	630271.0
2014-01-17 12:00:00	QQQ	ETF	88.26	88.3701	88.24	88.31	834907.0
2014-01-17 12:30:00	QQQ	ETF	88.32	88.33	88.22	88.221	528965.0

> showing 50 of 11,458 rows — these rows as CSV

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