PREVIEW / etf_30min / 2014-06-27

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-27.parquet
  size:    320 KB
  rows:    11,129

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-27 04:00:00	SPY	ETF	195.2	195.21	195.11	195.11	807.0
2014-06-27 04:30:00	SPY	ETF	195.29	195.29	195.29	195.29	600.0
2014-06-27 05:30:00	SPY	ETF	195.04	195.04	195.01	195.01	1625.0
2014-06-27 06:00:00	SPY	ETF	195.0	195.08	195.0	195.0	40300.0
2014-06-27 06:30:00	SPY	ETF	194.95	195.0	194.8	194.91	7052.0
2014-06-27 07:00:00	SPY	ETF	194.91	194.98	194.86	194.9	24742.0
2014-06-27 07:30:00	SPY	ETF	194.88	195.0	194.86	194.99	129618.0
2014-06-27 08:00:00	SPY	ETF	194.97	195.05	194.9	194.93	103019.0
2014-06-27 08:30:00	SPY	ETF	194.94	194.98	194.85	194.89	84483.0
2014-06-27 09:00:00	SPY	ETF	194.9	194.98	194.76	194.98	748217.0
2014-06-27 09:30:00	SPY	ETF	194.98	195.37	194.98	195.25	8535326.0
2014-06-27 10:00:00	SPY	ETF	195.24	195.34	195.0	195.28	4829340.0
2014-06-27 10:30:00	SPY	ETF	195.28	195.43	195.205	195.33	3236842.0
2014-06-27 11:00:00	SPY	ETF	195.34	195.51	195.26	195.38	2935002.0
2014-06-27 11:30:00	SPY	ETF	195.38	195.45	195.31	195.42	1867882.0
2014-06-27 12:00:00	SPY	ETF	195.42	195.45	195.3	195.32	1465848.0
2014-06-27 12:30:00	SPY	ETF	195.32	195.38	195.22	195.295	2046962.0
2014-06-27 13:00:00	SPY	ETF	195.295	195.295	194.885	195.02	3868317.0
2014-06-27 13:30:00	SPY	ETF	195.025	195.17	194.95	195.125	2217689.0
2014-06-27 14:00:00	SPY	ETF	195.14	195.37	195.11	195.26	2276568.0
2014-06-27 14:30:00	SPY	ETF	195.265	195.39	195.08	195.08	2003176.0
2014-06-27 15:00:00	SPY	ETF	195.085	195.46	195.08	195.41	3305829.0
2014-06-27 15:30:00	SPY	ETF	195.42	195.88	195.41	195.8	17823696.0
2014-06-27 16:00:00	SPY	ETF	195.82	195.9	195.6	195.71	10119698.0
2014-06-27 16:30:00	SPY	ETF	195.7	195.8107	195.59	195.64	1987701.0
2014-06-27 17:00:00	SPY	ETF	195.64	195.67	195.62	195.64	98036.0
2014-06-27 17:30:00	SPY	ETF	195.64	195.81	195.62	195.77	184661.0
2014-06-27 18:00:00	SPY	ETF	195.77	195.77	195.62	195.74	113921.0
2014-06-27 19:00:00	SPY	ETF	195.7	195.7	195.7	195.7	494.0
2014-06-27 19:30:00	SPY	ETF	195.67	195.72	195.67	195.7	7271.0
2014-06-27 04:30:00	QQQ	ETF	93.23	93.23	93.23	93.23	100.0
2014-06-27 06:00:00	QQQ	ETF	93.2	93.2	93.2	93.2	100.0
2014-06-27 08:00:00	QQQ	ETF	93.21	93.21	93.15	93.16	23675.0
2014-06-27 08:30:00	QQQ	ETF	93.16	93.18	93.12	93.16	33977.0
2014-06-27 09:00:00	QQQ	ETF	93.17	93.22	93.13	93.21	342083.0
2014-06-27 09:30:00	QQQ	ETF	93.21	93.47	93.19	93.36	3063350.0
2014-06-27 10:00:00	QQQ	ETF	93.36	93.43	93.22	93.38	1338980.0
2014-06-27 10:30:00	QQQ	ETF	93.38	93.43	93.3	93.35	827051.0
2014-06-27 11:00:00	QQQ	ETF	93.36	93.45	93.36	93.41	858943.0
2014-06-27 11:30:00	QQQ	ETF	93.42	93.51	93.37	93.48	903418.0
2014-06-27 12:00:00	QQQ	ETF	93.49	93.5	93.43	93.45	512524.0
2014-06-27 12:30:00	QQQ	ETF	93.45	93.4899	93.41	93.48	706198.0
2014-06-27 13:00:00	QQQ	ETF	93.47	93.48	93.22	93.305	2099738.0
2014-06-27 13:30:00	QQQ	ETF	93.31	93.43	93.27	93.41	1514888.0
2014-06-27 14:00:00	QQQ	ETF	93.408	93.52	93.39	93.4814	918504.0
2014-06-27 14:30:00	QQQ	ETF	93.49	93.6	93.4474	93.45	993094.0
2014-06-27 15:00:00	QQQ	ETF	93.4456	93.65	93.44	93.62	1312606.0
2014-06-27 15:30:00	QQQ	ETF	93.62	93.765	93.62	93.73	4650868.0
2014-06-27 16:00:00	QQQ	ETF	93.72	93.8	93.4	93.68	1718395.0
2014-06-27 16:30:00	QQQ	ETF	93.67	93.69	93.64	93.65	18170.0

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

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