PREVIEW / etf_30min / 2014-07-09

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-09.parquet
  size:    341 KB
  rows:    11,834

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-07-09 04:00:00	SPY	ETF	196.5	196.59	196.47	196.58	2720.0
2014-07-09 04:30:00	SPY	ETF	196.52	196.52	196.48	196.48	680.0
2014-07-09 05:00:00	SPY	ETF	196.44	196.51	196.4	196.42	2958.0
2014-07-09 05:30:00	SPY	ETF	196.51	196.53	196.41	196.52	7543.0
2014-07-09 06:00:00	SPY	ETF	196.54	196.66	196.54	196.64	18753.0
2014-07-09 06:30:00	SPY	ETF	196.59	196.59	196.51	196.57	9973.0
2014-07-09 07:00:00	SPY	ETF	196.57	196.66	196.56	196.64	158565.0
2014-07-09 07:30:00	SPY	ETF	196.6	196.75	196.6	196.75	122645.0
2014-07-09 08:00:00	SPY	ETF	196.74	196.87	196.66	196.82	284461.0
2014-07-09 08:30:00	SPY	ETF	196.81	196.82	196.7	196.7	325912.0
2014-07-09 09:00:00	SPY	ETF	196.7	196.87	196.69	196.73	599485.0
2014-07-09 09:30:00	SPY	ETF	196.73	197.0	196.43	196.46	9430938.0
2014-07-09 10:00:00	SPY	ETF	196.47	196.69	196.31	196.68	7015956.0
2014-07-09 10:30:00	SPY	ETF	196.68	196.99	196.58	196.81	5288121.0
2014-07-09 11:00:00	SPY	ETF	196.815	196.87	196.53	196.79	3388497.0
2014-07-09 11:30:00	SPY	ETF	196.78	196.79	196.57	196.66	2585199.0
2014-07-09 12:00:00	SPY	ETF	196.66	196.78	196.61	196.69	2089078.0
2014-07-09 12:30:00	SPY	ETF	196.7	196.78	196.63	196.7645	1557947.0
2014-07-09 13:00:00	SPY	ETF	196.765	196.87	196.7	196.76	1505134.0
2014-07-09 13:30:00	SPY	ETF	196.77	196.88	196.75	196.81	2265058.0
2014-07-09 14:00:00	SPY	ETF	196.815	197.19	196.44	197.07	10646913.0
2014-07-09 14:30:00	SPY	ETF	197.09	197.16	196.92	197.035	5095546.0
2014-07-09 15:00:00	SPY	ETF	197.039	197.295	197.02	197.11	5298694.0
2014-07-09 15:30:00	SPY	ETF	197.12	197.28	197.0	197.13	9182661.0
2014-07-09 16:00:00	SPY	ETF	197.12	197.25	196.2143	197.2	4633938.0
2014-07-09 16:30:00	SPY	ETF	197.19	197.24	196.2143	197.23	872022.0
2014-07-09 17:00:00	SPY	ETF	197.22	197.25	197.2	197.22	88949.0
2014-07-09 17:30:00	SPY	ETF	197.22	197.22	197.16	197.2	11116.0
2014-07-09 18:00:00	SPY	ETF	197.2	197.23	197.19	197.2	39722.0
2014-07-09 18:30:00	SPY	ETF	197.21	197.21	197.15	197.15	7760.0
2014-07-09 19:00:00	SPY	ETF	197.17	197.19	197.15	197.17	4241.0
2014-07-09 19:30:00	SPY	ETF	197.16	197.17	197.15	197.16	6964.0
2014-07-09 07:00:00	QQQ	ETF	94.49	94.49	94.49	94.49	2400.0
2014-07-09 07:30:00	QQQ	ETF	94.49	94.51	94.49	94.51	4820.0
2014-07-09 08:00:00	QQQ	ETF	94.505	94.57	94.505	94.55	69910.0
2014-07-09 08:30:00	QQQ	ETF	94.55	94.55	94.51	94.51	42470.0
2014-07-09 09:00:00	QQQ	ETF	94.52	94.61	94.29	94.51	382799.0
2014-07-09 09:30:00	QQQ	ETF	94.51	94.78	94.335	94.35	5026769.0
2014-07-09 10:00:00	QQQ	ETF	94.35	94.54	94.24	94.54	2119070.0
2014-07-09 10:30:00	QQQ	ETF	94.54	94.85	94.48	94.76	2416841.0
2014-07-09 11:00:00	QQQ	ETF	94.77	94.84	94.62	94.8284	1386181.0
2014-07-09 11:30:00	QQQ	ETF	94.82	94.82	94.62	94.74	668352.0
2014-07-09 12:00:00	QQQ	ETF	94.74	94.82	94.685	94.78	910403.0
2014-07-09 12:30:00	QQQ	ETF	94.8	94.82	94.74	94.7927	343662.0
2014-07-09 13:00:00	QQQ	ETF	94.798	94.86	94.75	94.79	737280.0
2014-07-09 13:30:00	QQQ	ETF	94.79	94.89	94.78	94.81	712938.0
2014-07-09 14:00:00	QQQ	ETF	94.81	95.0	94.551	94.938	3476572.0
2014-07-09 14:30:00	QQQ	ETF	94.935	94.99	94.842	94.91	1157088.0
2014-07-09 15:00:00	QQQ	ETF	94.915	95.055	94.89	94.945	1125478.0
2014-07-09 15:30:00	QQQ	ETF	94.945	95.065	94.89	94.97	2984717.0

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

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