PREVIEW / etf_30min / 2014-07-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-11.parquet
  size:    326 KB
  rows:    11,458

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-11 04:00:00	SPY	ETF	196.75	196.79	196.75	196.79	5081.0
2014-07-11 04:30:00	SPY	ETF	196.67	196.71	196.67	196.71	2210.0
2014-07-11 05:00:00	SPY	ETF	196.69	196.7	196.65	196.65	1700.0
2014-07-11 05:30:00	SPY	ETF	196.61	196.65	196.59	196.65	4303.0
2014-07-11 06:00:00	SPY	ETF	196.65	196.7	196.65	196.7	3100.0
2014-07-11 06:30:00	SPY	ETF	196.71	196.72	196.43	196.47	40421.0
2014-07-11 07:00:00	SPY	ETF	196.49	196.63	196.49	196.59	93482.0
2014-07-11 07:30:00	SPY	ETF	196.62	196.67	196.6	196.67	49614.0
2014-07-11 08:00:00	SPY	ETF	196.65	196.68	196.4	196.46	258736.0
2014-07-11 08:30:00	SPY	ETF	196.47	196.5	196.2	196.23	829444.0
2014-07-11 09:00:00	SPY	ETF	196.22	196.35	196.18	196.22	283007.0
2014-07-11 09:30:00	SPY	ETF	196.22	196.47	195.78	196.08	10294587.0
2014-07-11 10:00:00	SPY	ETF	196.09	196.46	195.9	196.35	6005147.0
2014-07-11 10:30:00	SPY	ETF	196.35	196.38	196.01	196.16	4091839.0
2014-07-11 11:00:00	SPY	ETF	196.17	196.245	195.91	196.05	3373220.0
2014-07-11 11:30:00	SPY	ETF	196.05	196.28	196.02	196.06	3852246.0
2014-07-11 12:00:00	SPY	ETF	196.065	196.14	195.98	196.06	2611246.0
2014-07-11 12:30:00	SPY	ETF	196.06	196.205	196.02	196.165	2380953.0
2014-07-11 13:00:00	SPY	ETF	196.165	196.44	196.165	196.41	3244146.0
2014-07-11 13:30:00	SPY	ETF	196.41	196.42	196.2901	196.35	1597983.0
2014-07-11 14:00:00	SPY	ETF	196.35	196.57	196.35	196.53	3054051.0
2014-07-11 14:30:00	SPY	ETF	196.54	196.62	196.47	196.48	2767526.0
2014-07-11 15:00:00	SPY	ETF	196.48	196.65	196.42	196.63	3250155.0
2014-07-11 15:30:00	SPY	ETF	196.63	196.75	196.54	196.59	8219274.0
2014-07-11 16:00:00	SPY	ETF	196.61	196.75	196.0	196.7	3077418.0
2014-07-11 16:30:00	SPY	ETF	196.7	196.74	196.66	196.74	2971952.0
2014-07-11 17:00:00	SPY	ETF	196.74	196.75	196.65	196.65	545187.0
2014-07-11 17:30:00	SPY	ETF	196.66	196.71	196.61	196.64	794259.0
2014-07-11 18:00:00	SPY	ETF	196.7	196.72	196.69	196.69	1977.0
2014-07-11 19:00:00	SPY	ETF	196.67	196.7	196.65	196.7	2802.0
2014-07-11 19:30:00	SPY	ETF	196.7	196.7	196.67	196.7	6397.0
2014-07-11 04:00:00	QQQ	ETF	94.88	95.04	94.88	95.04	2500.0
2014-07-11 05:00:00	QQQ	ETF	94.94	94.94	94.94	94.94	100.0
2014-07-11 06:00:00	QQQ	ETF	94.9	94.9	94.89	94.9	700.0
2014-07-11 07:00:00	QQQ	ETF	94.9	94.93	94.85	94.85	26700.0
2014-07-11 07:30:00	QQQ	ETF	94.96	94.98	94.95	94.96	11150.0
2014-07-11 08:00:00	QQQ	ETF	94.96	94.96	94.89	94.9	35452.0
2014-07-11 08:30:00	QQQ	ETF	94.91	94.91	94.78	94.79	115687.0
2014-07-11 09:00:00	QQQ	ETF	94.78	94.88	94.77	94.87	119710.0
2014-07-11 09:30:00	QQQ	ETF	94.87	95.03	94.61	94.87	3898580.0
2014-07-11 10:00:00	QQQ	ETF	94.87	95.07	94.7881	94.96	2060105.0
2014-07-11 10:30:00	QQQ	ETF	94.97	95.04	94.84	95.02	1298112.0
2014-07-11 11:00:00	QQQ	ETF	95.02	95.07	94.8373	94.92	1324082.0
2014-07-11 11:30:00	QQQ	ETF	94.93	95.02	94.88	94.9099	1198889.0
2014-07-11 12:00:00	QQQ	ETF	94.9	94.97	94.8801	94.93	405964.0
2014-07-11 12:30:00	QQQ	ETF	94.93	94.98	94.89	94.95	498608.0
2014-07-11 13:00:00	QQQ	ETF	94.9623	95.23	94.9601	95.191	1513842.0
2014-07-11 13:30:00	QQQ	ETF	95.195	95.2	95.13	95.15	783864.0
2014-07-11 14:00:00	QQQ	ETF	95.16	95.23	95.14	95.2	807217.0
2014-07-11 14:30:00	QQQ	ETF	95.19	95.26	95.155	95.17	789901.0

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

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