PREVIEW / etf_30min / 2014-09-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-29.parquet
  size:    348 KB
  rows:    11,900

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-09-29 04:00:00	SPY	ETF	197.36	197.4	197.19	197.35	17706.0
2014-09-29 04:30:00	SPY	ETF	197.23	197.38	197.18	197.28	6760.0
2014-09-29 05:00:00	SPY	ETF	197.29	197.32	197.15	197.23	11147.0
2014-09-29 05:30:00	SPY	ETF	197.28	197.38	197.26	197.28	5200.0
2014-09-29 06:00:00	SPY	ETF	197.26	197.38	197.2	197.29	95860.0
2014-09-29 06:30:00	SPY	ETF	197.33	197.33	196.82	196.97	122138.0
2014-09-29 07:00:00	SPY	ETF	197.0	197.03	196.67	196.8	223566.0
2014-09-29 07:30:00	SPY	ETF	196.8	197.01	196.75	197.01	439654.0
2014-09-29 08:00:00	SPY	ETF	197.01	197.215	196.6	196.81	475434.0
2014-09-29 08:30:00	SPY	ETF	196.82	196.96	196.13	196.22	998534.0
2014-09-29 09:00:00	SPY	ETF	196.22	196.33	196.06	196.18	1524366.0
2014-09-29 09:30:00	SPY	ETF	196.2	196.66	196.05	196.59	14432730.0
2014-09-29 10:00:00	SPY	ETF	196.59	197.24	196.42	197.01	9660528.0
2014-09-29 10:30:00	SPY	ETF	197.01	197.42	196.93	197.19	6754730.0
2014-09-29 11:00:00	SPY	ETF	197.19	197.75	197.06	197.56	7996216.0
2014-09-29 11:30:00	SPY	ETF	197.56	197.68	197.37	197.68	3504389.0
2014-09-29 12:00:00	SPY	ETF	197.679	197.679	197.06	197.14	3810430.0
2014-09-29 12:30:00	SPY	ETF	197.1392	197.33	196.91	197.21	4203329.0
2014-09-29 13:00:00	SPY	ETF	197.21	197.41	197.02	197.39	2888626.0
2014-09-29 13:30:00	SPY	ETF	197.4	197.59	197.15	197.34	3803014.0
2014-09-29 14:00:00	SPY	ETF	197.3351	197.51	196.76	196.86	3700684.0
2014-09-29 14:30:00	SPY	ETF	196.855	197.35	196.82	197.29	3702425.0
2014-09-29 15:00:00	SPY	ETF	197.285	197.89	197.23	197.81	6767359.0
2014-09-29 15:30:00	SPY	ETF	197.819	197.84	197.38	197.52	12049558.0
2014-09-29 16:00:00	SPY	ETF	197.52	198.0199	197.31	197.37	5163039.0
2014-09-29 16:30:00	SPY	ETF	197.37	197.49	197.3	197.37	153895.0
2014-09-29 17:00:00	SPY	ETF	197.34	197.4	197.32	197.32	32250.0
2014-09-29 17:30:00	SPY	ETF	197.4	197.42	197.34	197.4	31188.0
2014-09-29 18:00:00	SPY	ETF	197.38	197.4	197.37	197.37	23343.0
2014-09-29 18:30:00	SPY	ETF	197.35	197.37	197.34	197.37	3540.0
2014-09-29 19:00:00	SPY	ETF	197.36	197.42	197.34	197.42	7890.0
2014-09-29 19:30:00	SPY	ETF	197.43	197.44	197.4	197.44	5651.0
2014-09-29 04:00:00	QQQ	ETF	98.41	98.41	98.33	98.33	345.0
2014-09-29 04:30:00	QQQ	ETF	98.44	98.44	98.44	98.44	1000.0
2014-09-29 05:00:00	QQQ	ETF	98.37	98.37	98.35	98.35	2200.0
2014-09-29 05:30:00	QQQ	ETF	98.47	98.47	98.47	98.47	100.0
2014-09-29 06:00:00	QQQ	ETF	98.46	98.47	98.45	98.47	700.0
2014-09-29 06:30:00	QQQ	ETF	98.47	98.47	98.19	98.19	15500.0
2014-09-29 07:00:00	QQQ	ETF	98.24	98.28	98.09	98.18	22600.0
2014-09-29 07:30:00	QQQ	ETF	98.19	98.29	98.19	98.28	12660.0
2014-09-29 08:00:00	QQQ	ETF	98.3	98.3	98.19	98.2	67148.0
2014-09-29 08:30:00	QQQ	ETF	98.18	98.27	97.74	97.79	185008.0
2014-09-29 09:00:00	QQQ	ETF	97.77	97.89	97.69	97.8	329691.0
2014-09-29 09:30:00	QQQ	ETF	97.8	98.2	97.75	98.11	5232775.0
2014-09-29 10:00:00	QQQ	ETF	98.1	98.64	98.0	98.52	3819918.0
2014-09-29 10:30:00	QQQ	ETF	98.515	98.75	98.46	98.625	2451219.0
2014-09-29 11:00:00	QQQ	ETF	98.63	98.92	98.55	98.75	3110551.0
2014-09-29 11:30:00	QQQ	ETF	98.76	98.789	98.62	98.78	1019540.0
2014-09-29 12:00:00	QQQ	ETF	98.78	98.78	98.39	98.44	1594849.0
2014-09-29 12:30:00	QQQ	ETF	98.44	98.59	98.32	98.55	1097053.0

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

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