PREVIEW / etf_30min / 2014-03-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-10.parquet
  size:    326 KB
  rows:    11,122

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-03-10 04:00:00	SPY	ETF	187.92	187.92	187.61	187.86	5000.0
2014-03-10 04:30:00	SPY	ETF	187.82	188.17	187.8	188.17	12295.0
2014-03-10 05:00:00	SPY	ETF	188.17	188.36	188.17	188.26	6990.0
2014-03-10 05:30:00	SPY	ETF	188.24	188.27	188.2	188.2	4172.0
2014-03-10 06:00:00	SPY	ETF	188.16	188.2	188.07	188.17	26752.0
2014-03-10 06:30:00	SPY	ETF	188.18	188.18	188.12	188.13	94071.0
2014-03-10 07:00:00	SPY	ETF	188.12	188.16	188.04	188.09	169371.0
2014-03-10 07:30:00	SPY	ETF	188.08	188.24	187.97	188.08	146930.0
2014-03-10 08:00:00	SPY	ETF	188.12	188.19	187.8	187.96	257377.0
2014-03-10 08:30:00	SPY	ETF	188.0	188.03	187.72	187.88	392517.0
2014-03-10 09:00:00	SPY	ETF	187.88	188.05	187.84	187.94	552276.0
2014-03-10 09:30:00	SPY	ETF	187.94	188.22	187.7	188.11	9764248.0
2014-03-10 10:00:00	SPY	ETF	188.11	188.1399	187.46	187.58	6704343.0
2014-03-10 10:30:00	SPY	ETF	187.58	187.58	187.08	187.25	8291761.0
2014-03-10 11:00:00	SPY	ETF	187.25	187.84	187.13	187.8	6242121.0
2014-03-10 11:30:00	SPY	ETF	187.8	187.87	187.53	187.5649	3944107.0
2014-03-10 12:00:00	SPY	ETF	187.56	187.8	187.48	187.73	3731908.0
2014-03-10 12:30:00	SPY	ETF	187.73	188.0	187.6496	187.96	3174313.0
2014-03-10 13:00:00	SPY	ETF	187.96	187.99	187.8	187.875	2841492.0
2014-03-10 13:30:00	SPY	ETF	187.88	187.88	187.55	187.615	3231442.0
2014-03-10 14:00:00	SPY	ETF	187.61	187.74	187.52	187.705	3342732.0
2014-03-10 14:30:00	SPY	ETF	187.71	187.95	187.67	187.905	2712414.0
2014-03-10 15:00:00	SPY	ETF	187.905	187.905	187.68	187.87	4202464.0
2014-03-10 15:30:00	SPY	ETF	187.87	188.23	187.8101	188.18	9600063.0
2014-03-10 16:00:00	SPY	ETF	188.18	188.26	187.65	188.18	3029472.0
2014-03-10 16:30:00	SPY	ETF	188.18	188.34	188.16	188.25	532065.0
2014-03-10 17:00:00	SPY	ETF	188.25	188.28	188.15	188.2	183428.0
2014-03-10 17:30:00	SPY	ETF	188.2	188.21	188.11	188.11	156161.0
2014-03-10 18:00:00	SPY	ETF	188.11	188.15	188.07	188.15	49682.0
2014-03-10 18:30:00	SPY	ETF	188.13	188.14	188.12	188.14	7034.0
2014-03-10 19:00:00	SPY	ETF	188.11	188.14	188.09	188.12	12408.0
2014-03-10 19:30:00	SPY	ETF	188.12	188.13	188.09	188.09	35413.0
2014-03-10 05:30:00	QQQ	ETF	90.6	90.6	90.6	90.6	100.0
2014-03-10 06:30:00	QQQ	ETF	90.53	90.55	90.52	90.53	2500.0
2014-03-10 07:00:00	QQQ	ETF	90.55	90.55	90.51	90.54	4200.0
2014-03-10 07:30:00	QQQ	ETF	90.5	90.58	90.5	90.53	30300.0
2014-03-10 08:00:00	QQQ	ETF	90.53	90.53	90.45	90.46	49300.0
2014-03-10 08:30:00	QQQ	ETF	90.47	90.5	90.38	90.46	80861.0
2014-03-10 09:00:00	QQQ	ETF	90.46	90.52	90.43	90.48	69490.0
2014-03-10 09:30:00	QQQ	ETF	90.48	90.651	90.33	90.65	3991330.0
2014-03-10 10:00:00	QQQ	ETF	90.64	90.655	90.25	90.312	1811490.0
2014-03-10 10:30:00	QQQ	ETF	90.31	90.31	90.03	90.14	2152389.0
2014-03-10 11:00:00	QQQ	ETF	90.12	90.51	90.07	90.48	1355339.0
2014-03-10 11:30:00	QQQ	ETF	90.48	90.505	90.32	90.35	683944.0
2014-03-10 12:00:00	QQQ	ETF	90.345	90.47	90.32	90.41	597961.0
2014-03-10 12:30:00	QQQ	ETF	90.41	90.54	90.315	90.52	858039.0
2014-03-10 13:00:00	QQQ	ETF	90.529	90.54	90.37	90.4196	623302.0
2014-03-10 13:30:00	QQQ	ETF	90.415	90.42	90.26	90.31	487765.0
2014-03-10 14:00:00	QQQ	ETF	90.3	90.405	90.25	90.39	392638.0
2014-03-10 14:30:00	QQQ	ETF	90.39	90.501	90.36	90.4803	656041.0

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

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