PREVIEW / etf_30min / 2014-11-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-25.parquet
  size:    356 KB
  rows:    12,068

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-11-25 04:00:00	SPY	ETF	207.31	207.48	207.31	207.42	21025.0
2014-11-25 04:30:00	SPY	ETF	207.5	207.54	207.41	207.49	1327.0
2014-11-25 05:00:00	SPY	ETF	207.46	207.58	207.46	207.56	22182.0
2014-11-25 05:30:00	SPY	ETF	207.51	207.54	207.45	207.47	7700.0
2014-11-25 06:00:00	SPY	ETF	207.46	207.47	207.43	207.46	7859.0
2014-11-25 06:30:00	SPY	ETF	207.5	207.52	207.41	207.41	4639.0
2014-11-25 07:00:00	SPY	ETF	207.41	207.51	207.41	207.43	8930.0
2014-11-25 07:30:00	SPY	ETF	207.42	207.54	207.41	207.48	201613.0
2014-11-25 08:00:00	SPY	ETF	207.48	207.58	207.15	207.47	246831.0
2014-11-25 08:30:00	SPY	ETF	207.48	207.79	207.48	207.63	2097147.0
2014-11-25 09:00:00	SPY	ETF	207.65	207.65	207.51	207.53	378911.0
2014-11-25 09:30:00	SPY	ETF	207.54	207.79	207.33	207.49	9926434.0
2014-11-25 10:00:00	SPY	ETF	207.49	207.5	207.04	207.33	6448016.0
2014-11-25 10:30:00	SPY	ETF	207.3301	207.36	206.96	207.02	4530820.0
2014-11-25 11:00:00	SPY	ETF	207.02	207.1	206.8	206.89	4896836.0
2014-11-25 11:30:00	SPY	ETF	206.88	207.21	206.88	207.16	4165086.0
2014-11-25 12:00:00	SPY	ETF	207.17	207.34	207.09	207.1801	3437872.0
2014-11-25 12:30:00	SPY	ETF	207.185	207.56	207.17	207.37	5754262.0
2014-11-25 13:00:00	SPY	ETF	207.37	207.51	207.305	207.46	3797375.0
2014-11-25 13:30:00	SPY	ETF	207.46	207.5	207.375	207.48	1776075.0
2014-11-25 14:00:00	SPY	ETF	207.47	207.5	207.32	207.39	2795042.0
2014-11-25 14:30:00	SPY	ETF	207.385	207.42	207.11	207.22	2368084.0
2014-11-25 15:00:00	SPY	ETF	207.21	207.47	207.2	207.41	4673802.0
2014-11-25 15:30:00	SPY	ETF	207.41	207.435	207.08	207.18	11122874.0
2014-11-25 16:00:00	SPY	ETF	207.19	207.4242	207.05	207.33	6606529.0
2014-11-25 16:30:00	SPY	ETF	207.31	207.37	207.0563	207.33	2813801.0
2014-11-25 17:00:00	SPY	ETF	207.34	207.37	207.32	207.34	61736.0
2014-11-25 17:30:00	SPY	ETF	207.34	207.35	207.31	207.33	30800.0
2014-11-25 18:00:00	SPY	ETF	207.33	207.35	207.31	207.31	13022.0
2014-11-25 18:30:00	SPY	ETF	207.32	207.36	207.3	207.35	23980.0
2014-11-25 19:00:00	SPY	ETF	207.35	207.37	207.33	207.37	8380.0
2014-11-25 19:30:00	SPY	ETF	207.37	207.4	207.35	207.37	27086.0
2014-11-25 04:00:00	QQQ	ETF	104.65	104.78	104.57	104.78	500.0
2014-11-25 04:30:00	QQQ	ETF	104.78	104.78	104.78	104.78	6500.0
2014-11-25 05:30:00	QQQ	ETF	104.82	104.82	104.79	104.81	750.0
2014-11-25 06:00:00	QQQ	ETF	104.83	104.85	104.79	104.82	40700.0
2014-11-25 06:30:00	QQQ	ETF	104.79	104.79	104.79	104.79	3850.0
2014-11-25 07:00:00	QQQ	ETF	104.83	104.83	104.82	104.83	8300.0
2014-11-25 07:30:00	QQQ	ETF	104.8	104.86	104.8	104.85	25663.0
2014-11-25 08:00:00	QQQ	ETF	104.83	104.88	104.68	104.81	28118.0
2014-11-25 08:30:00	QQQ	ETF	104.84	104.93	104.82	104.86	70013.0
2014-11-25 09:00:00	QQQ	ETF	104.86	104.89	104.81	104.84	138906.0
2014-11-25 09:30:00	QQQ	ETF	104.84	105.15	104.79	104.9601	3270253.0
2014-11-25 10:00:00	QQQ	ETF	104.96	104.989	104.57	104.96	2379730.0
2014-11-25 10:30:00	QQQ	ETF	104.96	105.031	104.83	104.84	1210127.0
2014-11-25 11:00:00	QQQ	ETF	104.84	104.898	104.72	104.82	1138085.0
2014-11-25 11:30:00	QQQ	ETF	104.82	104.94	104.81	104.89	907774.0
2014-11-25 12:00:00	QQQ	ETF	104.89	104.925	104.815	104.86	716141.0
2014-11-25 12:30:00	QQQ	ETF	104.86	104.924	104.75	104.789	828778.0
2014-11-25 13:00:00	QQQ	ETF	104.78	104.94	104.77	104.9301	593447.0

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

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