PREVIEW / stock_5min / 2014-07-01

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-01.parquet
  size:    5.6 MB
  rows:    377,456
  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-07-01 04:05:00	AAPL	Stock	23.345	23.345	23.345	23.345	400.0
2014-07-01 04:25:00	AAPL	Stock	23.275	23.275	23.275	23.275	4000.0
2014-07-01 04:30:00	AAPL	Stock	23.275	23.275	23.275	23.275	4000.0
2014-07-01 04:50:00	AAPL	Stock	23.2925	23.2925	23.2925	23.2925	2008.0
2014-07-01 05:20:00	AAPL	Stock	23.3	23.3	23.3	23.3	632.0
2014-07-01 06:00:00	AAPL	Stock	23.3225	23.335	23.3225	23.335	3400.0
2014-07-01 06:05:00	AAPL	Stock	23.34	23.34	23.335	23.335	1200.0
2014-07-01 06:10:00	AAPL	Stock	23.3425	23.3625	23.3425	23.3625	840.0
2014-07-01 06:15:00	AAPL	Stock	23.3625	23.3625	23.34	23.34	1200.0
2014-07-01 06:25:00	AAPL	Stock	23.3625	23.3625	23.3625	23.3625	400.0
2014-07-01 06:30:00	AAPL	Stock	23.3625	23.3625	23.34	23.34	2720.0
2014-07-01 06:45:00	AAPL	Stock	23.3475	23.3475	23.3475	23.3475	800.0
2014-07-01 06:50:00	AAPL	Stock	23.345	23.345	23.335	23.335	2900.0
2014-07-01 06:55:00	AAPL	Stock	23.335	23.335	23.335	23.335	4000.0
2014-07-01 07:00:00	AAPL	Stock	23.335	23.3375	23.325	23.325	11336.0
2014-07-01 07:05:00	AAPL	Stock	23.335	23.3475	23.335	23.3475	1800.0
2014-07-01 07:10:00	AAPL	Stock	23.3475	23.3475	23.3475	23.3475	3600.0
2014-07-01 07:15:00	AAPL	Stock	23.34	23.34	23.3375	23.3375	4400.0
2014-07-01 07:20:00	AAPL	Stock	23.3375	23.3375	23.3375	23.3375	5448.0
2014-07-01 07:30:00	AAPL	Stock	23.3425	23.3425	23.3425	23.3425	3540.0
2014-07-01 07:35:00	AAPL	Stock	23.3375	23.3375	23.3375	23.3375	400.0
2014-07-01 07:40:00	AAPL	Stock	23.3375	23.3475	23.3375	23.345	4664.0
2014-07-01 07:45:00	AAPL	Stock	23.3425	23.35	23.3375	23.3375	10800.0
2014-07-01 07:50:00	AAPL	Stock	23.3425	23.3425	23.3325	23.3375	11500.0
2014-07-01 07:55:00	AAPL	Stock	23.3325	23.3325	23.3275	23.3275	12600.0
2014-07-01 08:00:00	AAPL	Stock	23.3275	23.3575	23.32	23.335	132376.0
2014-07-01 08:05:00	AAPL	Stock	23.335	23.355	23.2325	23.3525	40856.0
2014-07-01 08:10:00	AAPL	Stock	23.3525	23.3575	23.3475	23.35	17612.0
2014-07-01 08:15:00	AAPL	Stock	23.35	23.35	23.33	23.3375	42800.0
2014-07-01 08:20:00	AAPL	Stock	23.3475	23.3475	23.3375	23.3375	56928.0
2014-07-01 08:25:00	AAPL	Stock	23.345	23.36	23.34	23.34	52844.0
2014-07-01 08:30:00	AAPL	Stock	23.3375	23.3375	23.3275	23.3375	26912.0
2014-07-01 08:35:00	AAPL	Stock	23.34	23.35	23.33	23.345	24688.0
2014-07-01 08:40:00	AAPL	Stock	23.345	23.35	23.3425	23.345	20000.0
2014-07-01 08:45:00	AAPL	Stock	23.345	23.36	23.34	23.36	138016.0
2014-07-01 08:50:00	AAPL	Stock	23.355	23.36	23.3525	23.36	22368.0
2014-07-01 08:55:00	AAPL	Stock	23.36	23.3825	23.36	23.38	63080.0
2014-07-01 09:00:00	AAPL	Stock	23.38	23.4	23.3775	23.3925	106460.0
2014-07-01 09:05:00	AAPL	Stock	23.395	23.395	23.3675	23.3725	97000.0
2014-07-01 09:10:00	AAPL	Stock	23.3725	23.375	23.365	23.3725	25304.0
2014-07-01 09:15:00	AAPL	Stock	23.3725	23.3725	23.3675	23.37	62192.0
2014-07-01 09:20:00	AAPL	Stock	23.37	23.375	23.365	23.37	71592.0
2014-07-01 09:25:00	AAPL	Stock	23.365	23.39	23.3625	23.38	240584.0
2014-07-01 09:30:00	AAPL	Stock	23.38	23.3925	23.3	23.355	7857704.0
2014-07-01 09:35:00	AAPL	Stock	23.3525	23.365	23.2825	23.335	4077704.0
2014-07-01 09:40:00	AAPL	Stock	23.335	23.3875	23.335	23.37	3244692.0
2014-07-01 09:45:00	AAPL	Stock	23.3675	23.4125	23.35	23.3775	3155940.0
2014-07-01 09:50:00	AAPL	Stock	23.3775	23.445	23.372	23.41	3429680.0
2014-07-01 09:55:00	AAPL	Stock	23.41	23.435	23.3525	23.3875	2940688.0
2014-07-01 10:00:00	AAPL	Stock	23.3925	23.4025	23.375	23.3818	1976860.0

> showing 50 of 377,456 rows — these rows as CSV

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