PREVIEW / stock_5min / 2014-07-29

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-29.parquet
  size:    5.3 MB
  rows:    351,293
  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-07-29 04:10:00	AAPL	Stock	24.755	24.755	24.755	24.755	1600.0
2014-07-29 04:20:00	AAPL	Stock	24.745	24.745	24.745	24.745	1400.0
2014-07-29 04:30:00	AAPL	Stock	24.7375	24.76	24.725	24.76	2000.0
2014-07-29 05:00:00	AAPL	Stock	24.725	24.725	24.725	24.725	3888.0
2014-07-29 05:05:00	AAPL	Stock	24.725	24.725	24.725	24.725	1920.0
2014-07-29 05:30:00	AAPL	Stock	24.725	24.725	24.725	24.725	3160.0
2014-07-29 05:55:00	AAPL	Stock	24.725	24.725	24.725	24.725	1200.0
2014-07-29 06:10:00	AAPL	Stock	24.725	24.725	24.725	24.725	800.0
2014-07-29 06:15:00	AAPL	Stock	24.725	24.725	24.705	24.705	2400.0
2014-07-29 06:20:00	AAPL	Stock	24.7125	24.725	24.7125	24.725	6800.0
2014-07-29 06:25:00	AAPL	Stock	24.755	24.7575	24.725	24.725	4512.0
2014-07-29 06:30:00	AAPL	Stock	24.7375	24.775	24.7375	24.775	18044.0
2014-07-29 06:35:00	AAPL	Stock	24.7875	24.7875	24.7525	24.7525	12800.0
2014-07-29 06:50:00	AAPL	Stock	24.7525	24.7525	24.7525	24.7525	3320.0
2014-07-29 06:55:00	AAPL	Stock	24.7525	24.7525	24.745	24.7475	14400.0
2014-07-29 07:00:00	AAPL	Stock	24.7475	24.7875	24.745	24.7825	17396.0
2014-07-29 07:05:00	AAPL	Stock	24.7825	24.7975	24.7825	24.7975	25660.0
2014-07-29 07:10:00	AAPL	Stock	24.795	24.7975	24.7875	24.7875	7556.0
2014-07-29 07:15:00	AAPL	Stock	24.7875	24.7975	24.7875	24.79	6224.0
2014-07-29 07:20:00	AAPL	Stock	24.79	24.81	24.79	24.81	19396.0
2014-07-29 07:25:00	AAPL	Stock	24.8125	24.8125	24.805	24.81	8252.0
2014-07-29 07:30:00	AAPL	Stock	24.8	24.8125	24.7875	24.8025	24784.0
2014-07-29 07:35:00	AAPL	Stock	24.8025	24.8025	24.8	24.8	8000.0
2014-07-29 07:40:00	AAPL	Stock	24.805	24.815	24.805	24.815	17280.0
2014-07-29 07:45:00	AAPL	Stock	24.8175	24.8175	24.7875	24.81	23612.0
2014-07-29 07:50:00	AAPL	Stock	24.8025	24.8075	24.7975	24.8025	10192.0
2014-07-29 07:55:00	AAPL	Stock	24.8025	24.8175	24.8025	24.8175	16856.0
2014-07-29 08:00:00	AAPL	Stock	24.815	24.8175	24.7	24.7975	246440.0
2014-07-29 08:05:00	AAPL	Stock	24.7975	24.8475	24.795	24.835	121916.0
2014-07-29 08:10:00	AAPL	Stock	24.8325	24.8625	24.8325	24.8525	211780.0
2014-07-29 08:15:00	AAPL	Stock	24.86	24.87	24.855	24.865	111588.0
2014-07-29 08:20:00	AAPL	Stock	24.865	24.8675	24.855	24.8575	72428.0
2014-07-29 08:25:00	AAPL	Stock	24.855	24.855	24.8375	24.8475	33948.0
2014-07-29 08:30:00	AAPL	Stock	24.85	24.855	24.845	24.845	167056.0
2014-07-29 08:35:00	AAPL	Stock	24.85	24.85	24.835	24.8425	48100.0
2014-07-29 08:40:00	AAPL	Stock	24.835	24.8525	24.83	24.845	72852.0
2014-07-29 08:45:00	AAPL	Stock	24.855	24.8625	24.8425	24.85	103180.0
2014-07-29 08:50:00	AAPL	Stock	24.855	24.865	24.85	24.8625	101196.0
2014-07-29 08:55:00	AAPL	Stock	24.8625	24.8625	24.85	24.85	39120.0
2014-07-29 09:00:00	AAPL	Stock	24.8425	24.85	24.84	24.84	61376.0
2014-07-29 09:05:00	AAPL	Stock	24.8375	24.8475	24.8375	24.84	47572.0
2014-07-29 09:10:00	AAPL	Stock	24.85	24.85	24.8425	24.8425	30588.0
2014-07-29 09:15:00	AAPL	Stock	24.845	24.845	24.8375	24.8425	38620.0
2014-07-29 09:20:00	AAPL	Stock	24.84	24.8425	24.8375	24.84	41536.0
2014-07-29 09:25:00	AAPL	Stock	24.84	24.845	24.825	24.8375	112780.0
2014-07-29 09:30:00	AAPL	Stock	24.8325	24.86	24.765	24.775	9254112.0
2014-07-29 09:35:00	AAPL	Stock	24.7725	24.7875	24.6875	24.69	6905240.0
2014-07-29 09:40:00	AAPL	Stock	24.6912	24.7325	24.6675	24.73	5567792.0
2014-07-29 09:45:00	AAPL	Stock	24.73	24.76	24.705	24.7275	4773364.0
2014-07-29 09:50:00	AAPL	Stock	24.7275	24.7425	24.7	24.71	2975676.0

> showing 50 of 351,293 rows — these rows as CSV

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