PREVIEW / stock_5min / 2014-08-19

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-08-19.parquet
  size:    5.3 MB
  rows:    352,383
  symbols: 3,571

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-08-19 04:00:00	AAPL	Stock	24.85	24.915	24.85	24.855	16216.0
2014-08-19 04:15:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 04:20:00	AAPL	Stock	24.9	24.9	24.8675	24.8675	21128.0
2014-08-19 04:25:00	AAPL	Stock	24.9125	24.9125	24.9	24.9	2000.0
2014-08-19 04:30:00	AAPL	Stock	24.9	24.92	24.9	24.92	6040.0
2014-08-19 04:55:00	AAPL	Stock	24.9175	24.9175	24.8975	24.9	2800.0
2014-08-19 05:05:00	AAPL	Stock	24.9	24.9	24.9	24.9	3064.0
2014-08-19 05:20:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 05:30:00	AAPL	Stock	24.905	24.905	24.9	24.9	1600.0
2014-08-19 05:40:00	AAPL	Stock	24.885	24.885	24.885	24.885	1008.0
2014-08-19 05:45:00	AAPL	Stock	24.885	24.9	24.885	24.9	1880.0
2014-08-19 05:55:00	AAPL	Stock	24.8975	24.9	24.8975	24.9	800.0
2014-08-19 06:00:00	AAPL	Stock	24.9	24.9	24.9	24.9	2608.0
2014-08-19 06:15:00	AAPL	Stock	24.89	24.89	24.89	24.89	1388.0
2014-08-19 06:20:00	AAPL	Stock	24.89	24.89	24.875	24.875	2004.0
2014-08-19 06:25:00	AAPL	Stock	24.875	24.8875	24.875	24.875	21200.0
2014-08-19 06:30:00	AAPL	Stock	24.8875	24.8875	24.875	24.875	1268.0
2014-08-19 06:35:00	AAPL	Stock	24.8875	24.8875	24.8875	24.8875	2800.0
2014-08-19 06:40:00	AAPL	Stock	24.8675	24.8675	24.8675	24.8675	15200.0
2014-08-19 06:45:00	AAPL	Stock	24.8675	24.875	24.865	24.875	49964.0
2014-08-19 06:50:00	AAPL	Stock	24.8625	24.8625	24.85	24.85	28000.0
2014-08-19 06:55:00	AAPL	Stock	24.8625	24.875	24.8625	24.8625	27200.0
2014-08-19 07:00:00	AAPL	Stock	24.85	24.875	24.85	24.865	18468.0
2014-08-19 07:05:00	AAPL	Stock	24.8575	24.8725	24.855	24.855	3600.0
2014-08-19 07:10:00	AAPL	Stock	24.87	24.87	24.8625	24.8625	6652.0
2014-08-19 07:15:00	AAPL	Stock	24.8575	24.8575	24.8575	24.8575	1200.0
2014-08-19 07:20:00	AAPL	Stock	24.86	24.865	24.86	24.86	10904.0
2014-08-19 07:25:00	AAPL	Stock	24.8675	24.8725	24.8675	24.8725	25600.0
2014-08-19 07:30:00	AAPL	Stock	24.8725	24.8875	24.8725	24.875	92808.0
2014-08-19 07:35:00	AAPL	Stock	24.875	24.895	24.875	24.89	41668.0
2014-08-19 07:40:00	AAPL	Stock	24.8875	24.9	24.88	24.9	89096.0
2014-08-19 07:45:00	AAPL	Stock	24.9	24.9	24.88	24.8825	19300.0
2014-08-19 07:50:00	AAPL	Stock	24.8825	24.885	24.875	24.8775	15084.0
2014-08-19 07:55:00	AAPL	Stock	24.8825	24.8975	24.875	24.8875	74600.0
2014-08-19 08:00:00	AAPL	Stock	24.8875	24.91	24.79	24.9	216448.0
2014-08-19 08:05:00	AAPL	Stock	24.9025	24.9075	24.8875	24.9	69236.0
2014-08-19 08:10:00	AAPL	Stock	24.9	24.91	24.8975	24.8975	98616.0
2014-08-19 08:15:00	AAPL	Stock	24.895	24.8975	24.8875	24.89	44620.0
2014-08-19 08:20:00	AAPL	Stock	24.8975	24.8975	24.885	24.8875	31560.0
2014-08-19 08:25:00	AAPL	Stock	24.895	24.895	24.8775	24.895	15980.0
2014-08-19 08:30:00	AAPL	Stock	24.8875	24.8975	24.8875	24.895	26696.0
2014-08-19 08:35:00	AAPL	Stock	24.8975	24.905	24.8775	24.905	114640.0
2014-08-19 08:40:00	AAPL	Stock	24.9025	24.905	24.8925	24.8975	77956.0
2014-08-19 08:45:00	AAPL	Stock	24.895	24.9	24.89	24.9	68996.0
2014-08-19 08:50:00	AAPL	Stock	24.89	24.905	24.8875	24.905	66788.0
2014-08-19 08:55:00	AAPL	Stock	24.9025	24.9075	24.8875	24.8875	78108.0
2014-08-19 09:00:00	AAPL	Stock	24.8875	24.895	24.8775	24.885	58132.0
2014-08-19 09:05:00	AAPL	Stock	24.89	24.89	24.8825	24.8875	3800.0
2014-08-19 09:10:00	AAPL	Stock	24.8875	24.8875	24.8675	24.8775	107724.0
2014-08-19 09:15:00	AAPL	Stock	24.8775	24.8775	24.8725	24.875	43300.0

> showing 50 of 352,383 rows — these rows as CSV

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