PREVIEW / stock_5min / 2014-01-23

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-01-23.parquet
  size:    5.6 MB
  rows:    363,592
  symbols: 3,549

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-01-23 04:00:00	AAPL	Stock	19.75	19.75	19.7171	19.7171	5600.0
2014-01-23 04:50:00	AAPL	Stock	19.7382	19.7382	19.7382	19.7382	3332.0
2014-01-23 05:45:00	AAPL	Stock	19.7439	19.7439	19.7439	19.7439	2800.0
2014-01-23 05:50:00	AAPL	Stock	19.7439	19.7439	19.7439	19.7439	2800.0
2014-01-23 06:30:00	AAPL	Stock	19.7411	19.7411	19.7411	19.7411	3276.0
2014-01-23 06:45:00	AAPL	Stock	19.7357	19.7357	19.7357	19.7357	2800.0
2014-01-23 06:50:00	AAPL	Stock	19.7271	19.7271	19.7071	19.7143	18200.0
2014-01-23 06:55:00	AAPL	Stock	19.7143	19.7143	19.7143	19.7143	6664.0
2014-01-23 07:00:00	AAPL	Stock	19.6964	19.7071	19.6964	19.7071	30800.0
2014-01-23 07:05:00	AAPL	Stock	19.7018	19.7018	19.6718	19.6779	58408.0
2014-01-23 07:10:00	AAPL	Stock	19.675	19.675	19.6493	19.6493	75936.0
2014-01-23 07:15:00	AAPL	Stock	19.6589	19.6643	19.6589	19.6643	28000.0
2014-01-23 07:20:00	AAPL	Stock	19.6786	19.6807	19.6786	19.6807	5600.0
2014-01-23 07:25:00	AAPL	Stock	19.6829	19.6871	19.6611	19.6679	65240.0
2014-01-23 07:30:00	AAPL	Stock	19.6679	19.6786	19.6679	19.6743	16800.0
2014-01-23 07:35:00	AAPL	Stock	19.675	19.6821	19.675	19.6821	42000.0
2014-01-23 07:40:00	AAPL	Stock	19.6786	19.6786	19.6718	19.6718	5600.0
2014-01-23 07:45:00	AAPL	Stock	19.6786	19.6786	19.6775	19.6786	38640.0
2014-01-23 07:50:00	AAPL	Stock	19.6804	19.6811	19.6804	19.6811	14000.0
2014-01-23 07:55:00	AAPL	Stock	19.6871	19.7021	19.6871	19.7021	24752.0
2014-01-23 08:00:00	AAPL	Stock	19.6607	19.6957	19.6607	19.6957	73276.0
2014-01-23 08:05:00	AAPL	Stock	19.7082	19.7082	19.7082	19.7082	2800.0
2014-01-23 08:10:00	AAPL	Stock	19.6964	19.6964	19.6836	19.6836	11200.0
2014-01-23 08:15:00	AAPL	Stock	19.6911	19.6911	19.6875	19.6882	16100.0
2014-01-23 08:20:00	AAPL	Stock	19.6946	19.7036	19.6946	19.6982	56112.0
2014-01-23 08:25:00	AAPL	Stock	19.6979	19.6986	19.6957	19.6957	29540.0
2014-01-23 08:30:00	AAPL	Stock	19.6875	19.6882	19.6786	19.6786	69916.0
2014-01-23 08:35:00	AAPL	Stock	19.6867	19.6867	19.6732	19.6839	69300.0
2014-01-23 08:40:00	AAPL	Stock	19.6875	19.6875	19.6768	19.6786	31500.0
2014-01-23 08:45:00	AAPL	Stock	19.6739	19.675	19.6643	19.6643	128800.0
2014-01-23 08:50:00	AAPL	Stock	19.6711	19.6711	19.6436	19.6436	181860.0
2014-01-23 08:55:00	AAPL	Stock	19.6511	19.6518	19.6296	19.6418	287700.0
2014-01-23 09:00:00	AAPL	Stock	19.635	19.6375	19.6129	19.6375	268632.0
2014-01-23 09:05:00	AAPL	Stock	19.6329	19.6564	19.6329	19.65	89376.0
2014-01-23 09:10:00	AAPL	Stock	19.65	19.65	19.6482	19.6482	8960.0
2014-01-23 09:15:00	AAPL	Stock	19.6482	19.6532	19.6432	19.6432	51100.0
2014-01-23 09:20:00	AAPL	Stock	19.6496	19.6607	19.6496	19.6571	63672.0
2014-01-23 09:25:00	AAPL	Stock	19.6571	19.6636	19.6346	19.6346	158732.0
2014-01-23 09:30:00	AAPL	Stock	19.6414	19.6696	19.5754	19.6183	12086592.0
2014-01-23 09:35:00	AAPL	Stock	19.6182	19.6389	19.5968	19.5968	6970572.0
2014-01-23 09:40:00	AAPL	Stock	19.5968	19.6832	19.5961	19.6709	7866740.0
2014-01-23 09:45:00	AAPL	Stock	19.672	19.7082	19.6536	19.685	4848060.0
2014-01-23 09:50:00	AAPL	Stock	19.6832	19.7018	19.6518	19.6939	4669364.0
2014-01-23 09:55:00	AAPL	Stock	19.6914	19.7	19.6632	19.6721	2367260.0
2014-01-23 10:00:00	AAPL	Stock	19.6741	19.7082	19.6429	19.6439	3683540.0
2014-01-23 10:05:00	AAPL	Stock	19.6472	19.6532	19.5807	19.6146	5026504.0
2014-01-23 10:10:00	AAPL	Stock	19.6146	19.6146	19.5554	19.5745	4716880.0
2014-01-23 10:15:00	AAPL	Stock	19.5736	19.5946	19.5404	19.5784	3277456.0
2014-01-23 10:20:00	AAPL	Stock	19.5792	19.5911	19.5411	19.5625	3410540.0
2014-01-23 10:25:00	AAPL	Stock	19.5546	19.5643	19.5125	19.5196	3855544.0

> showing 50 of 363,592 rows — these rows as CSV

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