PREVIEW / stock_5min / 2012-11-07

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-11-07.parquet
  size:    5.0 MB
  rows:    331,827
  symbols: 3,471

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
2012-11-07 04:00:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	5600.0
2012-11-07 04:05:00	AAPL	Stock	20.7857	20.7857	20.7857	20.7857	5600.0
2012-11-07 06:05:00	AAPL	Stock	20.8036	20.8036	20.8036	20.8036	5600.0
2012-11-07 06:15:00	AAPL	Stock	20.7857	20.7857	20.75	20.75	47600.0
2012-11-07 06:20:00	AAPL	Stock	20.75	20.75	20.75	20.75	2800.0
2012-11-07 06:25:00	AAPL	Stock	20.7179	20.7214	20.7179	20.7214	51380.0
2012-11-07 06:30:00	AAPL	Stock	20.7214	20.7214	20.7214	20.7214	21280.0
2012-11-07 06:45:00	AAPL	Stock	20.7364	20.7375	20.7364	20.7375	5600.0
2012-11-07 06:50:00	AAPL	Stock	20.75	20.75	20.75	20.75	2800.0
2012-11-07 07:00:00	AAPL	Stock	20.7479	20.7479	20.7479	20.7479	5040.0
2012-11-07 07:05:00	AAPL	Stock	20.7214	20.7214	20.6786	20.6786	42980.0
2012-11-07 07:10:00	AAPL	Stock	20.6939	20.7143	20.6786	20.6786	58296.0
2012-11-07 07:15:00	AAPL	Stock	20.6786	20.6786	20.6607	20.6696	14812.0
2012-11-07 07:20:00	AAPL	Stock	20.6614	20.6696	20.6071	20.6075	225988.0
2012-11-07 07:25:00	AAPL	Stock	20.6075	20.6179	20.5821	20.6179	124656.0
2012-11-07 07:30:00	AAPL	Stock	20.6143	20.6179	20.5893	20.6071	160832.0
2012-11-07 07:35:00	AAPL	Stock	20.6071	20.6143	20.5836	20.5843	122416.0
2012-11-07 07:40:00	AAPL	Stock	20.5839	20.5968	20.5836	20.5968	34888.0
2012-11-07 07:45:00	AAPL	Stock	20.5893	20.6071	20.5875	20.5968	138236.0
2012-11-07 07:50:00	AAPL	Stock	20.5968	20.6	20.5964	20.5964	44800.0
2012-11-07 07:55:00	AAPL	Stock	20.6054	20.6071	20.6054	20.6071	19684.0
2012-11-07 08:00:00	AAPL	Stock	20.6071	20.6854	20.5482	20.5704	622776.0
2012-11-07 08:05:00	AAPL	Stock	20.5607	20.5657	20.5093	20.5268	551208.0
2012-11-07 08:10:00	AAPL	Stock	20.5268	20.5418	20.4893	20.4893	504700.0
2012-11-07 08:15:00	AAPL	Stock	20.4893	20.5232	20.48	20.4818	686084.0
2012-11-07 08:20:00	AAPL	Stock	20.4786	20.4889	20.4411	20.4768	737828.0
2012-11-07 08:25:00	AAPL	Stock	20.4796	20.5064	20.4668	20.4839	445508.0
2012-11-07 08:30:00	AAPL	Stock	20.4836	20.5089	20.4821	20.5089	166180.0
2012-11-07 08:35:00	AAPL	Stock	20.5075	20.5296	20.5018	20.5179	320628.0
2012-11-07 08:40:00	AAPL	Stock	20.5111	20.5225	20.4943	20.4943	157584.0
2012-11-07 08:45:00	AAPL	Stock	20.5018	20.5107	20.4943	20.5107	106680.0
2012-11-07 08:50:00	AAPL	Stock	20.5007	20.5196	20.5004	20.5107	100380.0
2012-11-07 08:55:00	AAPL	Stock	20.5043	20.51	20.4643	20.4818	519372.0
2012-11-07 09:00:00	AAPL	Stock	20.4814	20.4814	20.4557	20.4621	323316.0
2012-11-07 09:05:00	AAPL	Stock	20.4643	20.4739	20.4636	20.4711	192136.0
2012-11-07 09:10:00	AAPL	Stock	20.4671	20.5089	20.4671	20.5032	385616.0
2012-11-07 09:15:00	AAPL	Stock	20.5025	20.5286	20.4971	20.525	444696.0
2012-11-07 09:20:00	AAPL	Stock	20.5179	20.5336	20.5139	20.5175	217000.0
2012-11-07 09:25:00	AAPL	Stock	20.5143	20.5246	20.4839	20.49	321440.0
2012-11-07 09:30:00	AAPL	Stock	20.4979	20.5193	20.4036	20.4171	25810008.0
2012-11-07 09:35:00	AAPL	Stock	20.4211	20.4743	20.3782	20.3864	19110952.0
2012-11-07 09:40:00	AAPL	Stock	20.3929	20.4154	20.2625	20.2968	27080732.0
2012-11-07 09:45:00	AAPL	Stock	20.3029	20.3561	20.28	20.3304	17477320.0
2012-11-07 09:50:00	AAPL	Stock	20.3287	20.3854	20.3168	20.3764	12149396.0
2012-11-07 09:55:00	AAPL	Stock	20.3786	20.4207	20.3254	20.3289	11703300.0
2012-11-07 10:00:00	AAPL	Stock	20.3314	20.3714	20.3214	20.3561	7564116.0
2012-11-07 10:05:00	AAPL	Stock	20.349	20.3607	20.2879	20.2925	8921332.0
2012-11-07 10:10:00	AAPL	Stock	20.2921	20.3179	20.2418	20.2811	14208096.0
2012-11-07 10:15:00	AAPL	Stock	20.2799	20.2875	20.2	20.2089	12572196.0
2012-11-07 10:20:00	AAPL	Stock	20.2129	20.2366	20.1943	20.2147	12742072.0

> showing 50 of 331,827 rows — these rows as CSV

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