PREVIEW / etf_30min / 2014-06-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-10.parquet
  size:    321 KB
  rows:    11,317

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-06-10 04:00:00	SPY	ETF	195.4	195.4	195.1	195.23	51957.0
2014-06-10 04:30:00	SPY	ETF	195.32	195.32	195.29	195.29	529.0
2014-06-10 05:00:00	SPY	ETF	195.29	195.29	195.29	195.29	813.0
2014-06-10 05:30:00	SPY	ETF	195.36	195.36	195.22	195.25	4497.0
2014-06-10 06:00:00	SPY	ETF	195.25	195.25	195.17	195.25	10668.0
2014-06-10 06:30:00	SPY	ETF	195.27	195.34	195.24	195.31	5737.0
2014-06-10 07:00:00	SPY	ETF	195.33	195.34	195.15	195.24	27821.0
2014-06-10 07:30:00	SPY	ETF	195.19	195.25	195.17	195.21	110005.0
2014-06-10 08:00:00	SPY	ETF	195.31	195.31	195.11	195.18	148935.0
2014-06-10 08:30:00	SPY	ETF	195.18	195.26	195.18	195.2	200473.0
2014-06-10 09:00:00	SPY	ETF	195.2	195.34	195.2	195.34	326364.0
2014-06-10 09:30:00	SPY	ETF	195.33	195.47	195.17	195.25	6492052.0
2014-06-10 10:00:00	SPY	ETF	195.24	195.42	194.92	195.35	5644047.0
2014-06-10 10:30:00	SPY	ETF	195.36	195.49	195.19	195.44	4605742.0
2014-06-10 11:00:00	SPY	ETF	195.44	195.47	195.3	195.3699	4024622.0
2014-06-10 11:30:00	SPY	ETF	195.37	195.445	195.29	195.33	2666444.0
2014-06-10 12:00:00	SPY	ETF	195.32	195.33	195.13	195.31	2653693.0
2014-06-10 12:30:00	SPY	ETF	195.305	195.34	195.19	195.28	2036633.0
2014-06-10 13:00:00	SPY	ETF	195.285	195.31	195.14	195.2	2267296.0
2014-06-10 13:30:00	SPY	ETF	195.2	195.42	195.19	195.38	2519879.0
2014-06-10 14:00:00	SPY	ETF	195.38	195.49	195.325	195.44	3282064.0
2014-06-10 14:30:00	SPY	ETF	195.44	195.445	195.32	195.35	3034407.0
2014-06-10 15:00:00	SPY	ETF	195.345	195.55	195.33	195.48	3917275.0
2014-06-10 15:30:00	SPY	ETF	195.48	195.6	195.4	195.6	6862718.0
2014-06-10 16:00:00	SPY	ETF	195.61	195.67	195.4186	195.4186	2047441.0
2014-06-10 16:30:00	SPY	ETF	195.65	195.72	195.2049	195.72	1259447.0
2014-06-10 17:00:00	SPY	ETF	195.73	195.75	195.56	195.67	1041015.0
2014-06-10 17:30:00	SPY	ETF	195.67	195.7	195.64	195.64	35352.0
2014-06-10 18:00:00	SPY	ETF	195.64	195.65	195.55	195.55	97600.0
2014-06-10 18:30:00	SPY	ETF	195.55	195.58	195.54	195.55	21080.0
2014-06-10 19:00:00	SPY	ETF	195.55	195.55	195.53	195.55	5700.0
2014-06-10 19:30:00	SPY	ETF	195.55	195.55	195.5	195.5	16889.0
2014-06-10 04:00:00	QQQ	ETF	92.56	93.37	92.52	93.25	51978.0
2014-06-10 06:00:00	QQQ	ETF	92.64	92.64	92.58	92.58	2500.0
2014-06-10 07:30:00	QQQ	ETF	92.59	92.63	92.57	92.57	17800.0
2014-06-10 08:00:00	QQQ	ETF	92.56	92.59	92.53	92.56	23500.0
2014-06-10 08:30:00	QQQ	ETF	92.57	92.6	92.55	92.56	12200.0
2014-06-10 09:00:00	QQQ	ETF	92.57	92.67	92.57	92.67	94089.0
2014-06-10 09:30:00	QQQ	ETF	92.67	92.91	92.64	92.72	4662160.0
2014-06-10 10:00:00	QQQ	ETF	92.72	92.89	92.56	92.87	2260257.0
2014-06-10 10:30:00	QQQ	ETF	92.87	92.93	92.695	92.8799	1357694.0
2014-06-10 11:00:00	QQQ	ETF	92.88	92.96	92.81	92.84	972552.0
2014-06-10 11:30:00	QQQ	ETF	92.85	92.92	92.785	92.859	916565.0
2014-06-10 12:00:00	QQQ	ETF	92.85	92.8601	92.715	92.8099	759866.0
2014-06-10 12:30:00	QQQ	ETF	92.81	92.81	92.66	92.77	679205.0
2014-06-10 13:00:00	QQQ	ETF	92.765	92.82	92.68	92.75	733017.0
2014-06-10 13:30:00	QQQ	ETF	92.74	92.88	92.74	92.85	789124.0
2014-06-10 14:00:00	QQQ	ETF	92.85	92.91	92.8	92.87	1151681.0
2014-06-10 14:30:00	QQQ	ETF	92.87	92.88	92.8	92.81	586866.0
2014-06-10 15:00:00	QQQ	ETF	92.815	92.89	92.81	92.865	746783.0

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

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