PREVIEW / etf_30min / 2014-04-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-03.parquet
  size:    327 KB
  rows:    11,141

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-04-03 04:00:00	SPY	ETF	188.76	188.97	188.76	188.97	1600.0
2014-04-03 04:30:00	SPY	ETF	188.97	188.97	188.89	188.93	4348.0
2014-04-03 05:00:00	SPY	ETF	188.89	188.94	188.87	188.88	1862.0
2014-04-03 05:30:00	SPY	ETF	188.92	188.99	188.89	188.99	12194.0
2014-04-03 06:00:00	SPY	ETF	189.01	189.1	188.98	189.02	9274.0
2014-04-03 06:30:00	SPY	ETF	189.01	189.12	189.01	189.07	3717.0
2014-04-03 07:00:00	SPY	ETF	189.04	189.04	188.99	189.04	57962.0
2014-04-03 07:30:00	SPY	ETF	189.03	189.03	188.87	188.92	58796.0
2014-04-03 08:00:00	SPY	ETF	188.96	189.05	188.72	188.87	234573.0
2014-04-03 08:30:00	SPY	ETF	188.84	188.99	188.68	188.78	835613.0
2014-04-03 09:00:00	SPY	ETF	188.79	189.24	188.78	189.17	692028.0
2014-04-03 09:30:00	SPY	ETF	189.17	189.22	188.865	189.12	8259696.0
2014-04-03 10:00:00	SPY	ETF	189.12	189.19	188.72	188.74	6237293.0
2014-04-03 10:30:00	SPY	ETF	188.74	188.8	188.51	188.789	6202540.0
2014-04-03 11:00:00	SPY	ETF	188.78	188.81	188.55	188.585	4160505.0
2014-04-03 11:30:00	SPY	ETF	188.59	188.66	188.44	188.51	4614794.0
2014-04-03 12:00:00	SPY	ETF	188.51	188.66	188.39	188.51	3384635.0
2014-04-03 12:30:00	SPY	ETF	188.505	188.51	188.26	188.35	4099052.0
2014-04-03 13:00:00	SPY	ETF	188.35	188.62	188.32	188.61	3016158.0
2014-04-03 13:30:00	SPY	ETF	188.6	188.76	188.51	188.54	5252436.0
2014-04-03 14:00:00	SPY	ETF	188.54	188.6224	188.38	188.4	3000224.0
2014-04-03 14:30:00	SPY	ETF	188.4	188.4	188.05	188.39	6625712.0
2014-04-03 15:00:00	SPY	ETF	188.39	188.665	188.35	188.65	4081824.0
2014-04-03 15:30:00	SPY	ETF	188.65	188.86	188.6	188.63	11366549.0
2014-04-03 16:00:00	SPY	ETF	188.63	188.86	188.5207	188.84	3034358.0
2014-04-03 16:30:00	SPY	ETF	188.84	188.94	188.75	188.92	1157308.0
2014-04-03 17:00:00	SPY	ETF	188.93	188.96	188.63	188.94	55198.0
2014-04-03 17:30:00	SPY	ETF	188.92	189.0	188.91	188.91	44537.0
2014-04-03 18:00:00	SPY	ETF	188.92	188.93	188.87	188.92	79414.0
2014-04-03 18:30:00	SPY	ETF	188.92	188.94	188.9	188.94	36257.0
2014-04-03 19:00:00	SPY	ETF	188.94	188.95	188.89	188.89	32580.0
2014-04-03 19:30:00	SPY	ETF	188.91	188.99	188.9	188.96	38044.0
2014-04-03 04:00:00	QQQ	ETF	89.39	89.39	89.39	89.39	2500.0
2014-04-03 06:30:00	QQQ	ETF	89.52	89.58	89.52	89.58	4269.0
2014-04-03 07:00:00	QQQ	ETF	89.51	89.51	89.51	89.51	1500.0
2014-04-03 07:30:00	QQQ	ETF	89.48	89.5	89.43	89.43	31900.0
2014-04-03 08:00:00	QQQ	ETF	89.42	89.48	89.34	89.37	50238.0
2014-04-03 08:30:00	QQQ	ETF	89.38	89.47	89.33	89.35	171145.0
2014-04-03 09:00:00	QQQ	ETF	89.33	89.56	89.33	89.55	283396.0
2014-04-03 09:30:00	QQQ	ETF	89.55	89.655	89.29	89.63	2779830.0
2014-04-03 10:00:00	QQQ	ETF	89.64	89.679	89.181	89.19	2717231.0
2014-04-03 10:30:00	QQQ	ETF	89.2	89.33	89.091	89.32	2424141.0
2014-04-03 11:00:00	QQQ	ETF	89.3274	89.34	89.11	89.11	1421610.0
2014-04-03 11:30:00	QQQ	ETF	89.12	89.19	88.95	88.9901	3373112.0
2014-04-03 12:00:00	QQQ	ETF	88.99	89.03	88.75	88.8	1831381.0
2014-04-03 12:30:00	QQQ	ETF	88.8	88.8	88.521	88.62	1746659.0
2014-04-03 13:00:00	QQQ	ETF	88.61	88.77	88.59	88.7499	1362790.0
2014-04-03 13:30:00	QQQ	ETF	88.74	88.84	88.68	88.71	1243813.0
2014-04-03 14:00:00	QQQ	ETF	88.7	88.72	88.54	88.541	932791.0
2014-04-03 14:30:00	QQQ	ETF	88.54	88.54	88.22	88.48	2811865.0

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

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