PREVIEW / stock_5min / 2016-07-14

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-07-14.parquet
  size:    5.4 MB
  rows:    357,991
  symbols: 3,287

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
2016-07-14 04:00:00	AAPL	Stock	24.2425	24.3625	24.2425	24.3625	3000.0
2016-07-14 04:30:00	AAPL	Stock	24.35	24.35	24.35	24.35	772.0
2016-07-14 04:40:00	AAPL	Stock	24.35	24.35	24.35	24.35	1440.0
2016-07-14 04:45:00	AAPL	Stock	24.34	24.34	24.34	24.34	800.0
2016-07-14 04:50:00	AAPL	Stock	24.34	24.34	24.34	24.34	400.0
2016-07-14 04:55:00	AAPL	Stock	24.35	24.35	24.35	24.35	1196.0
2016-07-14 05:00:00	AAPL	Stock	24.35	24.35	24.35	24.35	720.0
2016-07-14 05:15:00	AAPL	Stock	24.34	24.34	24.34	24.34	2356.0
2016-07-14 05:30:00	AAPL	Stock	24.34	24.35	24.34	24.35	2000.0
2016-07-14 05:40:00	AAPL	Stock	24.3625	24.3625	24.3625	24.3625	1580.0
2016-07-14 05:50:00	AAPL	Stock	24.3625	24.3625	24.3625	24.3625	800.0
2016-07-14 06:00:00	AAPL	Stock	24.3625	24.3625	24.3625	24.3625	1600.0
2016-07-14 06:05:00	AAPL	Stock	24.41	24.41	24.3775	24.3775	3408.0
2016-07-14 06:35:00	AAPL	Stock	24.38	24.38	24.3625	24.3625	3960.0
2016-07-14 06:45:00	AAPL	Stock	24.375	24.3825	24.375	24.3825	3200.0
2016-07-14 06:55:00	AAPL	Stock	24.375	24.375	24.375	24.375	400.0
2016-07-14 07:00:00	AAPL	Stock	24.3925	24.3925	24.35	24.3525	54176.0
2016-07-14 07:05:00	AAPL	Stock	24.3525	24.3525	24.3425	24.3425	4188.0
2016-07-14 07:10:00	AAPL	Stock	24.35	24.3725	24.35	24.3725	1600.0
2016-07-14 07:15:00	AAPL	Stock	24.3725	24.3725	24.3725	24.3725	5096.0
2016-07-14 07:25:00	AAPL	Stock	24.365	24.3725	24.365	24.37	6612.0
2016-07-14 07:35:00	AAPL	Stock	24.3725	24.375	24.3725	24.375	14000.0
2016-07-14 07:40:00	AAPL	Stock	24.3875	24.3875	24.3775	24.3775	16740.0
2016-07-14 07:45:00	AAPL	Stock	24.3875	24.3875	24.375	24.375	6400.0
2016-07-14 07:50:00	AAPL	Stock	24.355	24.355	24.35	24.355	1800.0
2016-07-14 07:55:00	AAPL	Stock	24.3625	24.3675	24.355	24.3675	6800.0
2016-07-14 08:00:00	AAPL	Stock	24.375	24.375	24.3575	24.3575	36228.0
2016-07-14 08:05:00	AAPL	Stock	24.35	24.35	24.34	24.34	26048.0
2016-07-14 08:10:00	AAPL	Stock	24.3375	24.34	24.325	24.34	15520.0
2016-07-14 08:15:00	AAPL	Stock	24.3475	24.35	24.34	24.34	8452.0
2016-07-14 08:20:00	AAPL	Stock	24.335	24.3425	24.3325	24.335	13244.0
2016-07-14 08:25:00	AAPL	Stock	24.33	24.33	24.3275	24.33	10400.0
2016-07-14 08:30:00	AAPL	Stock	24.325	24.325	24.31	24.31	46320.0
2016-07-14 08:35:00	AAPL	Stock	24.315	24.3225	24.31	24.3225	6600.0
2016-07-14 08:40:00	AAPL	Stock	24.3175	24.3175	24.3125	24.3125	8668.0
2016-07-14 08:45:00	AAPL	Stock	24.3175	24.3425	24.3175	24.325	29964.0
2016-07-14 08:50:00	AAPL	Stock	24.3325	24.3475	24.3325	24.3475	22332.0
2016-07-14 08:55:00	AAPL	Stock	24.35	24.35	24.345	24.345	25324.0
2016-07-14 09:00:00	AAPL	Stock	24.33	24.3375	24.3125	24.3275	26472.0
2016-07-14 09:05:00	AAPL	Stock	24.3275	24.3375	24.3175	24.325	14400.0
2016-07-14 09:10:00	AAPL	Stock	24.33	24.34	24.3275	24.3275	6940.0
2016-07-14 09:15:00	AAPL	Stock	24.34	24.3425	24.325	24.335	9492.0
2016-07-14 09:20:00	AAPL	Stock	24.33	24.33	24.325	24.325	4904.0
2016-07-14 09:25:00	AAPL	Stock	24.335	24.3575	24.33	24.34	84492.0
2016-07-14 09:30:00	AAPL	Stock	24.35	24.375	24.33	24.345	3678264.0
2016-07-14 09:35:00	AAPL	Stock	24.3425	24.3988	24.34	24.3912	3886324.0
2016-07-14 09:40:00	AAPL	Stock	24.394	24.405	24.375	24.3925	4365880.0
2016-07-14 09:45:00	AAPL	Stock	24.3947	24.4237	24.3875	24.4163	3234084.0
2016-07-14 09:50:00	AAPL	Stock	24.4175	24.4475	24.4128	24.4188	2705204.0
2016-07-14 09:55:00	AAPL	Stock	24.42	24.435	24.405	24.4225	1977604.0

> showing 50 of 357,991 rows — these rows as CSV

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