PREVIEW / etf_30min / 2014-05-30

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-30.parquet
  size:    323 KB
  rows:    11,237

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-05-30 04:00:00	SPY	ETF	192.17	192.22	192.03	192.14	1710.0
2014-05-30 04:30:00	SPY	ETF	192.16	192.2	192.16	192.2	600.0
2014-05-30 05:00:00	SPY	ETF	192.2	192.22	192.2	192.22	319.0
2014-05-30 05:30:00	SPY	ETF	192.24	192.25	192.14	192.16	8628.0
2014-05-30 06:00:00	SPY	ETF	192.17	192.17	192.08	192.12	8381.0
2014-05-30 06:30:00	SPY	ETF	192.1	192.22	192.1	192.22	20361.0
2014-05-30 07:00:00	SPY	ETF	192.22	192.26	192.21	192.24	21506.0
2014-05-30 07:30:00	SPY	ETF	192.26	192.31	192.22	192.22	35699.0
2014-05-30 08:00:00	SPY	ETF	192.22	192.28	192.2	192.26	74638.0
2014-05-30 08:30:00	SPY	ETF	192.28	192.28	192.12	192.22	244146.0
2014-05-30 09:00:00	SPY	ETF	192.21	192.23	192.08	192.17	401365.0
2014-05-30 09:30:00	SPY	ETF	192.19	192.3	192.03	192.21	6750847.0
2014-05-30 10:00:00	SPY	ETF	192.22	192.52	192.15	192.44	6490803.0
2014-05-30 10:30:00	SPY	ETF	192.43	192.49	192.32	192.45	3101125.0
2014-05-30 11:00:00	SPY	ETF	192.45	192.54	192.35	192.39	2762883.0
2014-05-30 11:30:00	SPY	ETF	192.38	192.54	192.37	192.47	2272474.0
2014-05-30 12:00:00	SPY	ETF	192.47	192.51	192.37	192.42	2282591.0
2014-05-30 12:30:00	SPY	ETF	192.42	192.43	192.07	192.18	6899705.0
2014-05-30 13:00:00	SPY	ETF	192.18	192.3	192.11	192.24	2564310.0
2014-05-30 13:30:00	SPY	ETF	192.23	192.3	192.1	192.295	4211462.0
2014-05-30 14:00:00	SPY	ETF	192.3	192.52	192.25	192.517	3266280.0
2014-05-30 14:30:00	SPY	ETF	192.51	192.62	192.4	192.42	4142168.0
2014-05-30 15:00:00	SPY	ETF	192.42	192.5	192.31	192.43	4606654.0
2014-05-30 15:30:00	SPY	ETF	192.44	192.8	192.43	192.65	14379348.0
2014-05-30 16:00:00	SPY	ETF	192.66	192.7376	192.365	192.63	6997012.0
2014-05-30 16:30:00	SPY	ETF	192.61	192.62	192.47	192.5	1155097.0
2014-05-30 17:00:00	SPY	ETF	192.49	192.68	192.49	192.6	2219250.0
2014-05-30 17:30:00	SPY	ETF	192.58	192.82	192.58	192.72	271603.0
2014-05-30 18:00:00	SPY	ETF	192.71	192.74	192.7	192.74	21416.0
2014-05-30 18:30:00	SPY	ETF	192.74	192.74	192.72	192.74	7680.0
2014-05-30 19:00:00	SPY	ETF	192.72	192.77	192.72	192.73	16983.0
2014-05-30 19:30:00	SPY	ETF	192.73	192.78	192.73	192.78	14310.0
2014-05-30 04:00:00	QQQ	ETF	91.26	91.26	91.26	91.26	100.0
2014-05-30 06:00:00	QQQ	ETF	91.26	91.26	91.26	91.26	400.0
2014-05-30 07:00:00	QQQ	ETF	91.31	91.34	91.31	91.34	1450.0
2014-05-30 07:30:00	QQQ	ETF	91.32	91.32	91.29	91.29	6800.0
2014-05-30 08:00:00	QQQ	ETF	91.29	91.31	91.27	91.31	31820.0
2014-05-30 08:30:00	QQQ	ETF	91.31	91.31	91.23	91.26	154979.0
2014-05-30 09:00:00	QQQ	ETF	91.27	91.33	91.23	91.33	214585.0
2014-05-30 09:30:00	QQQ	ETF	91.33	91.38	91.14	91.17	4484931.0
2014-05-30 10:00:00	QQQ	ETF	91.17	91.4	91.12	91.31	2184204.0
2014-05-30 10:30:00	QQQ	ETF	91.32	91.41	91.27	91.34	1511513.0
2014-05-30 11:00:00	QQQ	ETF	91.34	91.45	91.29	91.32	1055147.0
2014-05-30 11:30:00	QQQ	ETF	91.32	91.45	91.31	91.35	700608.0
2014-05-30 12:00:00	QQQ	ETF	91.36	91.42	91.26	91.26	706897.0
2014-05-30 12:30:00	QQQ	ETF	91.26	91.27	90.92	91.01	2264032.0
2014-05-30 13:00:00	QQQ	ETF	91.01	91.08	90.88	90.971	1019101.0
2014-05-30 13:30:00	QQQ	ETF	90.97	91.01	90.83	91.0075	1059943.0
2014-05-30 14:00:00	QQQ	ETF	91.005	91.15	90.94	91.14	1098510.0
2014-05-30 14:30:00	QQQ	ETF	91.1437	91.23	91.07	91.1	1496607.0

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

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