PREVIEW / stock_5min / 2017-03-09

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-09.parquet
  size:    5.5 MB
  rows:    359,760
  symbols: 3,091

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
2017-03-09 04:00:00	AAPL	Stock	34.81	34.81	34.81	34.81	1196.0
2017-03-09 04:15:00	AAPL	Stock	34.8275	34.8275	34.825	34.825	1500.0
2017-03-09 05:15:00	AAPL	Stock	34.7625	34.7625	34.7575	34.7575	2356.0
2017-03-09 06:05:00	AAPL	Stock	34.6775	34.6775	34.665	34.665	5860.0
2017-03-09 06:30:00	AAPL	Stock	34.675	34.675	34.675	34.675	4000.0
2017-03-09 06:35:00	AAPL	Stock	34.6425	34.6425	34.6425	34.6425	1656.0
2017-03-09 06:45:00	AAPL	Stock	34.675	34.675	34.675	34.675	4400.0
2017-03-09 06:50:00	AAPL	Stock	34.6475	34.6475	34.6475	34.6475	576.0
2017-03-09 07:00:00	AAPL	Stock	34.675	34.675	34.675	34.675	400.0
2017-03-09 07:05:00	AAPL	Stock	34.6625	34.6625	34.6475	34.6475	17412.0
2017-03-09 07:10:00	AAPL	Stock	34.67	34.67	34.6625	34.6625	1600.0
2017-03-09 07:15:00	AAPL	Stock	34.67	34.67	34.6325	34.6325	21796.0
2017-03-09 07:20:00	AAPL	Stock	34.6375	34.6625	34.6375	34.65	17540.0
2017-03-09 07:25:00	AAPL	Stock	34.65	34.6625	34.65	34.65	5156.0
2017-03-09 07:30:00	AAPL	Stock	34.65	34.6525	34.65	34.6525	1744.0
2017-03-09 07:35:00	AAPL	Stock	34.6525	34.6525	34.6525	34.6525	2944.0
2017-03-09 07:40:00	AAPL	Stock	34.665	34.6725	34.665	34.6725	3800.0
2017-03-09 07:45:00	AAPL	Stock	34.6625	34.6625	34.6625	34.6625	400.0
2017-03-09 07:50:00	AAPL	Stock	34.65	34.6675	34.65	34.6675	5600.0
2017-03-09 07:55:00	AAPL	Stock	34.6525	34.6525	34.6525	34.6525	1000.0
2017-03-09 08:00:00	AAPL	Stock	34.65	34.6725	34.6125	34.62	65216.0
2017-03-09 08:05:00	AAPL	Stock	34.62	34.6475	34.6125	34.6375	26320.0
2017-03-09 08:10:00	AAPL	Stock	34.6275	34.645	34.6125	34.6125	36360.0
2017-03-09 08:15:00	AAPL	Stock	34.615	34.62	34.605	34.6125	50812.0
2017-03-09 08:20:00	AAPL	Stock	34.6225	34.6375	34.6125	34.6375	17600.0
2017-03-09 08:25:00	AAPL	Stock	34.6375	34.6375	34.61	34.625	23916.0
2017-03-09 08:30:00	AAPL	Stock	34.6175	34.625	34.615	34.625	30204.0
2017-03-09 08:35:00	AAPL	Stock	34.625	34.65	34.625	34.6375	71856.0
2017-03-09 08:40:00	AAPL	Stock	34.66	34.675	34.65	34.675	26324.0
2017-03-09 08:45:00	AAPL	Stock	34.6725	34.6775	34.6625	34.6725	28836.0
2017-03-09 08:50:00	AAPL	Stock	34.6775	34.695	34.67	34.6875	10912.0
2017-03-09 08:55:00	AAPL	Stock	34.67	34.705	34.67	34.7	16444.0
2017-03-09 09:00:00	AAPL	Stock	34.7	34.7025	34.6875	34.695	28720.0
2017-03-09 09:05:00	AAPL	Stock	34.6925	34.6975	34.67	34.695	23252.0
2017-03-09 09:10:00	AAPL	Stock	34.68	34.695	34.67	34.695	12592.0
2017-03-09 09:15:00	AAPL	Stock	34.685	34.6875	34.6575	34.6575	34604.0
2017-03-09 09:20:00	AAPL	Stock	34.675	34.675	34.6625	34.6625	1600.0
2017-03-09 09:25:00	AAPL	Stock	34.6725	34.685	34.67	34.685	27820.0
2017-03-09 09:30:00	AAPL	Stock	34.685	34.6975	34.2625	34.3775	9210408.0
2017-03-09 09:35:00	AAPL	Stock	34.38	34.4975	34.3675	34.465	4515144.0
2017-03-09 09:40:00	AAPL	Stock	34.4725	34.5325	34.465	34.5075	2967156.0
2017-03-09 09:45:00	AAPL	Stock	34.5088	34.6125	34.505	34.5875	2542696.0
2017-03-09 09:50:00	AAPL	Stock	34.5875	34.62	34.5585	34.575	1639884.0
2017-03-09 09:55:00	AAPL	Stock	34.5737	34.615	34.545	34.61	1700156.0
2017-03-09 10:00:00	AAPL	Stock	34.6075	34.6788	34.6075	34.66	1861100.0
2017-03-09 10:05:00	AAPL	Stock	34.66	34.665	34.6125	34.635	1302812.0
2017-03-09 10:10:00	AAPL	Stock	34.635	34.6525	34.5975	34.6075	1443184.0
2017-03-09 10:15:00	AAPL	Stock	34.6088	34.6325	34.59	34.6132	1128604.0
2017-03-09 10:20:00	AAPL	Stock	34.6125	34.6325	34.6	34.6112	804260.0
2017-03-09 10:25:00	AAPL	Stock	34.6125	34.6225	34.5875	34.6175	714792.0

> showing 50 of 359,760 rows — these rows as CSV

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