PREVIEW / stock_5min / 2017-04-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-18.parquet
  size:    5.3 MB
  rows:    348,526
  symbols: 3,050

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-04-18 04:30:00	AAPL	Stock	35.4075	35.4075	35.4075	35.4075	720.0
2017-04-18 04:40:00	AAPL	Stock	35.42	35.42	35.42	35.42	1360.0
2017-04-18 04:50:00	AAPL	Stock	35.4075	35.4075	35.4075	35.4075	880.0
2017-04-18 05:05:00	AAPL	Stock	35.3925	35.3925	35.38	35.38	3200.0
2017-04-18 05:35:00	AAPL	Stock	35.3675	35.3675	35.3675	35.3675	1312.0
2017-04-18 05:40:00	AAPL	Stock	35.355	35.355	35.355	35.355	400.0
2017-04-18 05:55:00	AAPL	Stock	35.3625	35.3625	35.35	35.35	7180.0
2017-04-18 06:00:00	AAPL	Stock	35.385	35.3975	35.3375	35.3375	14784.0
2017-04-18 06:05:00	AAPL	Stock	35.35	35.35	35.35	35.35	800.0
2017-04-18 06:25:00	AAPL	Stock	35.3375	35.3375	35.325	35.33	4860.0
2017-04-18 06:30:00	AAPL	Stock	35.365	35.365	35.365	35.365	520.0
2017-04-18 06:35:00	AAPL	Stock	35.37	35.37	35.35	35.35	5600.0
2017-04-18 07:00:00	AAPL	Stock	35.375	35.375	35.375	35.375	2400.0
2017-04-18 07:05:00	AAPL	Stock	35.36	35.385	35.36	35.375	9900.0
2017-04-18 07:10:00	AAPL	Stock	35.3825	35.3975	35.3825	35.39	9400.0
2017-04-18 07:15:00	AAPL	Stock	35.3875	35.4	35.3875	35.395	8000.0
2017-04-18 07:20:00	AAPL	Stock	35.395	35.395	35.395	35.395	400.0
2017-04-18 07:25:00	AAPL	Stock	35.4	35.4	35.4	35.4	14324.0
2017-04-18 07:30:00	AAPL	Stock	35.4	35.4	35.4	35.4	2000.0
2017-04-18 07:35:00	AAPL	Stock	35.4	35.4	35.4	35.4	1800.0
2017-04-18 07:40:00	AAPL	Stock	35.4	35.4	35.375	35.375	10484.0
2017-04-18 07:45:00	AAPL	Stock	35.3975	35.4	35.3975	35.4	4952.0
2017-04-18 07:50:00	AAPL	Stock	35.4	35.4	35.4	35.4	1200.0
2017-04-18 07:55:00	AAPL	Stock	35.4	35.4	35.4	35.4	400.0
2017-04-18 08:00:00	AAPL	Stock	35.375	35.4	35.375	35.4	20700.0
2017-04-18 08:05:00	AAPL	Stock	35.3875	35.3875	35.3875	35.3875	8000.0
2017-04-18 08:10:00	AAPL	Stock	35.39	35.39	35.39	35.39	1200.0
2017-04-18 08:15:00	AAPL	Stock	35.4	35.4	35.39	35.4	4432.0
2017-04-18 08:20:00	AAPL	Stock	35.3925	35.3925	35.38	35.38	8628.0
2017-04-18 08:25:00	AAPL	Stock	35.3875	35.3875	35.38	35.3875	7132.0
2017-04-18 08:30:00	AAPL	Stock	35.3875	35.3875	35.38	35.38	14400.0
2017-04-18 08:35:00	AAPL	Stock	35.38	35.385	35.3775	35.385	4620.0
2017-04-18 08:40:00	AAPL	Stock	35.3775	35.3775	35.375	35.375	15112.0
2017-04-18 08:45:00	AAPL	Stock	35.375	35.375	35.375	35.375	736.0
2017-04-18 08:50:00	AAPL	Stock	35.385	35.3875	35.385	35.3875	3800.0
2017-04-18 08:55:00	AAPL	Stock	35.3875	35.39	35.3875	35.39	18852.0
2017-04-18 09:00:00	AAPL	Stock	35.3925	35.3925	35.385	35.385	6176.0
2017-04-18 09:05:00	AAPL	Stock	35.385	35.3925	35.3825	35.3825	1840.0
2017-04-18 09:10:00	AAPL	Stock	35.3775	35.3775	35.365	35.3725	12932.0
2017-04-18 09:15:00	AAPL	Stock	35.365	35.365	35.36	35.36	1876.0
2017-04-18 09:20:00	AAPL	Stock	35.375	35.375	35.375	35.375	7800.0
2017-04-18 09:25:00	AAPL	Stock	35.37	35.37	35.3175	35.3575	43680.0
2017-04-18 09:30:00	AAPL	Stock	35.36	35.42	35.3025	35.4075	2942492.0
2017-04-18 09:35:00	AAPL	Stock	35.405	35.44	35.39	35.43	1189412.0
2017-04-18 09:40:00	AAPL	Stock	35.4275	35.4475	35.3525	35.4	1350044.0
2017-04-18 09:45:00	AAPL	Stock	35.4	35.4225	35.375	35.3868	1043424.0
2017-04-18 09:50:00	AAPL	Stock	35.3858	35.4225	35.3738	35.3975	1110276.0
2017-04-18 09:55:00	AAPL	Stock	35.4	35.4925	35.4	35.485	1260440.0
2017-04-18 10:00:00	AAPL	Stock	35.485	35.49	35.452	35.4588	968236.0
2017-04-18 10:05:00	AAPL	Stock	35.4625	35.4725	35.4275	35.4425	933696.0

> showing 50 of 348,526 rows — these rows as CSV

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