PREVIEW / stock_30min / 2014-10-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-03.parquet
  size:    1.6 MB
  rows:    82,278
  symbols: 3,576

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-10-03 04:00:00	AAPL	Stock	24.8125	24.83	24.75	24.83	27200.0
2014-10-03 04:30:00	AAPL	Stock	24.8125	24.85	24.8125	24.85	17704.0
2014-10-03 05:00:00	AAPL	Stock	24.85	24.875	24.85	24.875	25400.0
2014-10-03 05:30:00	AAPL	Stock	24.875	24.9125	24.79	24.79	49440.0
2014-10-03 06:00:00	AAPL	Stock	24.79	24.86	24.7875	24.86	49852.0
2014-10-03 06:30:00	AAPL	Stock	24.8625	24.8725	24.815	24.825	31404.0
2014-10-03 07:00:00	AAPL	Stock	24.825	24.8875	24.825	24.8875	63824.0
2014-10-03 07:30:00	AAPL	Stock	24.8875	24.9125	24.8375	24.8775	180700.0
2014-10-03 08:00:00	AAPL	Stock	24.88	24.975	24.8	24.92	1396744.0
2014-10-03 08:30:00	AAPL	Stock	24.915	24.9375	24.8575	24.8675	901136.0
2014-10-03 09:00:00	AAPL	Stock	24.865	24.92	24.8375	24.855	945788.0
2014-10-03 09:30:00	AAPL	Stock	24.8525	24.955	24.76	24.92	30591524.0
2014-10-03 10:00:00	AAPL	Stock	24.9225	25.0525	24.8938	24.9318	20913024.0
2014-10-03 10:30:00	AAPL	Stock	24.93	24.9725	24.845	24.955	12542864.0
2014-10-03 11:00:00	AAPL	Stock	24.9525	24.9675	24.8575	24.9237	7790168.0
2014-10-03 11:30:00	AAPL	Stock	24.9275	24.945	24.8525	24.885	6471268.0
2014-10-03 12:00:00	AAPL	Stock	24.8862	24.9575	24.875	24.955	6558388.0
2014-10-03 12:30:00	AAPL	Stock	24.9575	24.9875	24.915	24.965	9459260.0
2014-10-03 13:00:00	AAPL	Stock	24.965	24.9925	24.9478	24.9775	7871984.0
2014-10-03 13:30:00	AAPL	Stock	24.975	24.995	24.95	24.9562	7382968.0
2014-10-03 14:00:00	AAPL	Stock	24.96	24.9918	24.9538	24.965	6599256.0
2014-10-03 14:30:00	AAPL	Stock	24.9662	24.9875	24.9525	24.9725	6568612.0
2014-10-03 15:00:00	AAPL	Stock	24.9725	24.9975	24.9625	24.9675	8432064.0
2014-10-03 15:30:00	AAPL	Stock	24.9675	24.985	24.89	24.9025	19321300.0
2014-10-03 16:00:00	AAPL	Stock	24.905	24.9788	24.89	24.924	10231852.0
2014-10-03 16:30:00	AAPL	Stock	24.905	24.9275	24.9025	24.9175	305808.0
2014-10-03 17:00:00	AAPL	Stock	24.905	24.965	24.9025	24.9225	37808.0
2014-10-03 17:30:00	AAPL	Stock	24.925	24.925	24.905	24.915	42588.0
2014-10-03 18:00:00	AAPL	Stock	24.92	24.9225	24.905	24.9225	55688.0
2014-10-03 18:30:00	AAPL	Stock	24.9225	24.925	24.915	24.925	11052.0
2014-10-03 19:00:00	AAPL	Stock	24.925	24.925	24.91	24.91	11096.0
2014-10-03 19:30:00	AAPL	Stock	24.9075	24.915	24.8975	24.915	66160.0
2014-10-03 07:30:00	MSFT	Stock	46.12	46.17	46.11	46.15	10126.0
2014-10-03 08:00:00	MSFT	Stock	46.13	46.15	45.76	45.76	222550.0
2014-10-03 08:30:00	MSFT	Stock	46.13	46.13	46.09	46.1	7531.0
2014-10-03 09:00:00	MSFT	Stock	46.05	46.09	45.91	45.92	27691.0
2014-10-03 09:30:00	MSFT	Stock	45.98	46.02	45.61	45.959	3655446.0
2014-10-03 10:00:00	MSFT	Stock	45.96	46.09	45.92	45.955	2401856.0
2014-10-03 10:30:00	MSFT	Stock	45.96	46.005	45.9	45.99	2403960.0
2014-10-03 11:00:00	MSFT	Stock	45.99	46.01	45.88	45.957	2900013.0
2014-10-03 11:30:00	MSFT	Stock	45.96	45.99	45.79	45.82	1685113.0
2014-10-03 12:00:00	MSFT	Stock	45.82	45.87	45.79	45.87	1410333.0
2014-10-03 12:30:00	MSFT	Stock	45.87	46.05	45.86	46.024	1318827.0
2014-10-03 13:00:00	MSFT	Stock	46.02	46.04	45.94	45.975	1160190.0
2014-10-03 13:30:00	MSFT	Stock	45.975	46.055	45.96	46.04	1184807.0
2014-10-03 14:00:00	MSFT	Stock	46.04	46.22	46.04	46.196	1633957.0
2014-10-03 14:30:00	MSFT	Stock	46.19	46.265	46.16	46.23	1513093.0
2014-10-03 15:00:00	MSFT	Stock	46.22	46.3	46.19	46.21	1902266.0
2014-10-03 15:30:00	MSFT	Stock	46.21	46.23	46.06	46.07	4573905.0
2014-10-03 16:00:00	MSFT	Stock	46.09	46.15	46.021	46.05	3230762.0

> showing 50 of 82,278 rows — these rows as CSV

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