PREVIEW / etf_30min / 2014-07-31

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-31.parquet
  size:    376 KB
  rows:    12,555

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-07-31 04:00:00	SPY	ETF	196.61	196.61	195.9	196.0	10152.0
2014-07-31 04:30:00	SPY	ETF	196.11	196.11	195.35	195.5	42350.0
2014-07-31 05:00:00	SPY	ETF	195.5	195.8	195.5	195.8	24018.0
2014-07-31 05:30:00	SPY	ETF	195.78	195.8	195.68	195.71	19885.0
2014-07-31 06:00:00	SPY	ETF	195.68	195.77	195.62	195.77	68781.0
2014-07-31 06:30:00	SPY	ETF	195.86	195.98	195.79	195.92	159489.0
2014-07-31 07:00:00	SPY	ETF	195.96	196.0	195.83	195.84	187840.0
2014-07-31 07:30:00	SPY	ETF	195.91	196.04	195.61	195.94	392957.0
2014-07-31 08:00:00	SPY	ETF	195.76	196.966	195.7	196.05	947467.0
2014-07-31 08:30:00	SPY	ETF	196.02	196.03	195.36	195.54	1549884.0
2014-07-31 09:00:00	SPY	ETF	195.55	195.92	195.45	195.63	836739.0
2014-07-31 09:30:00	SPY	ETF	195.61	195.78	195.22	195.31	18753133.0
2014-07-31 10:00:00	SPY	ETF	195.31	195.51	194.94	195.06	13028786.0
2014-07-31 10:30:00	SPY	ETF	195.07	195.12	194.195	194.24	11903247.0
2014-07-31 11:00:00	SPY	ETF	194.23	194.6	194.21	194.37	10985174.0
2014-07-31 11:30:00	SPY	ETF	194.37	194.585	193.91	193.98	10391879.0
2014-07-31 12:00:00	SPY	ETF	193.98	194.1201	193.68	193.76	8991696.0
2014-07-31 12:30:00	SPY	ETF	193.77	194.28	193.75	194.1999	8010608.0
2014-07-31 13:00:00	SPY	ETF	194.19	194.24	193.81	194.0265	6489724.0
2014-07-31 13:30:00	SPY	ETF	194.02	194.4	193.98	194.23	7050571.0
2014-07-31 14:00:00	SPY	ETF	194.23	194.43	194.105	194.38	5036300.0
2014-07-31 14:30:00	SPY	ETF	194.38	194.39	193.49	193.505	9041794.0
2014-07-31 15:00:00	SPY	ETF	193.5	194.7	193.084	193.2	13683773.0
2014-07-31 15:30:00	SPY	ETF	193.19	193.58	193.04	193.05	30010174.0
2014-07-31 16:00:00	SPY	ETF	193.05	196.9727	192.9	193.28	14849046.0
2014-07-31 16:30:00	SPY	ETF	193.28	196.9727	192.96	192.96	5701695.0
2014-07-31 17:00:00	SPY	ETF	193.01	193.1	192.93	193.06	151590.0
2014-07-31 17:30:00	SPY	ETF	193.06	193.16	193.01	193.16	848629.0
2014-07-31 18:00:00	SPY	ETF	193.16	193.34	193.16	193.25	215064.0
2014-07-31 18:30:00	SPY	ETF	193.25	193.3	193.25	193.28	11876.0
2014-07-31 19:00:00	SPY	ETF	193.28	193.39	193.23	193.36	100370.0
2014-07-31 19:30:00	SPY	ETF	193.26	193.41	193.25	193.37	63026.0
2014-07-31 04:00:00	QQQ	ETF	96.7	96.7	96.45	96.45	27250.0
2014-07-31 04:30:00	QQQ	ETF	96.41	96.41	96.11	96.19	29760.0
2014-07-31 05:00:00	QQQ	ETF	96.24	96.34	96.16	96.34	2300.0
2014-07-31 06:00:00	QQQ	ETF	96.3	96.35	96.29	96.35	1000.0
2014-07-31 06:30:00	QQQ	ETF	96.38	96.41	96.38	96.41	6850.0
2014-07-31 07:00:00	QQQ	ETF	96.45	96.45	96.36	96.36	21030.0
2014-07-31 07:30:00	QQQ	ETF	96.38	96.41	96.2	96.37	67830.0
2014-07-31 08:00:00	QQQ	ETF	96.38	96.49	96.35	96.42	205603.0
2014-07-31 08:30:00	QQQ	ETF	96.42	96.42	96.12	96.18	267658.0
2014-07-31 09:00:00	QQQ	ETF	96.16	96.31	96.14	96.21	259810.0
2014-07-31 09:30:00	QQQ	ETF	96.2	96.34	95.94	95.95	6333061.0
2014-07-31 10:00:00	QQQ	ETF	95.95	96.09	95.78	95.86	4424644.0
2014-07-31 10:30:00	QQQ	ETF	95.87	95.89	95.39	95.41	3513858.0
2014-07-31 11:00:00	QQQ	ETF	95.4	95.5786	95.38	95.44	2687368.0
2014-07-31 11:30:00	QQQ	ETF	95.44	95.54	95.13	95.19	3362158.0
2014-07-31 12:00:00	QQQ	ETF	95.2	95.29	95.04	95.085	2254184.0
2014-07-31 12:30:00	QQQ	ETF	95.09	95.42	95.075	95.415	2276584.0
2014-07-31 13:00:00	QQQ	ETF	95.41	95.454	95.2328	95.33	1492265.0

> showing 50 of 12,555 rows — these rows as CSV

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