PREVIEW / stock_5min / 2017-07-25

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-25.parquet
  size:    5.5 MB
  rows:    355,218
  symbols: 3,008

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-07-25 04:50:00	AAPL	Stock	37.9825	37.9825	37.9725	37.9725	12548.0
2017-07-25 05:05:00	AAPL	Stock	38.0225	38.0225	38.0225	38.0225	8000.0
2017-07-25 05:45:00	AAPL	Stock	38.0375	38.0475	38.0375	38.0475	3508.0
2017-07-25 06:05:00	AAPL	Stock	38.0575	38.0575	38.0575	38.0575	1736.0
2017-07-25 07:00:00	AAPL	Stock	38.05	38.05	38.05	38.05	612.0
2017-07-25 07:15:00	AAPL	Stock	38.05	38.05	38.05	38.05	2200.0
2017-07-25 07:30:00	AAPL	Stock	38.06	38.0675	38.06	38.0675	8180.0
2017-07-25 07:35:00	AAPL	Stock	38.095	38.1075	38.095	38.1075	5176.0
2017-07-25 07:40:00	AAPL	Stock	38.0975	38.0975	38.0975	38.0975	3400.0
2017-07-25 07:45:00	AAPL	Stock	38.1125	38.1125	38.1	38.1	3116.0
2017-07-25 08:00:00	AAPL	Stock	38.095	38.1125	38.055	38.0775	27928.0
2017-07-25 08:05:00	AAPL	Stock	38.095	38.095	38.095	38.095	2000.0
2017-07-25 08:10:00	AAPL	Stock	38.1	38.1	38.095	38.1	11420.0
2017-07-25 08:15:00	AAPL	Stock	38.1	38.15	38.1	38.1175	31704.0
2017-07-25 08:20:00	AAPL	Stock	38.1175	38.15	38.095	38.1425	24508.0
2017-07-25 08:25:00	AAPL	Stock	38.1	38.1025	38.1	38.1	1964.0
2017-07-25 08:30:00	AAPL	Stock	38.1	38.12	38.1	38.12	8616.0
2017-07-25 08:35:00	AAPL	Stock	38.12	38.12	38.075	38.0975	21540.0
2017-07-25 08:40:00	AAPL	Stock	38.075	38.075	38.0525	38.0525	4024.0
2017-07-25 08:45:00	AAPL	Stock	38.0675	38.0675	38.0275	38.0275	8000.0
2017-07-25 08:50:00	AAPL	Stock	38.04	38.0675	38.0225	38.0225	26376.0
2017-07-25 08:55:00	AAPL	Stock	38.015	38.015	38.0	38.0	6636.0
2017-07-25 09:00:00	AAPL	Stock	38.0025	38.025	37.9925	37.9925	18952.0
2017-07-25 09:05:00	AAPL	Stock	38.005	38.005	37.975	38.0	43640.0
2017-07-25 09:10:00	AAPL	Stock	38.0	38.0	37.9775	37.995	43356.0
2017-07-25 09:15:00	AAPL	Stock	37.9875	37.9875	37.9875	37.9875	400.0
2017-07-25 09:20:00	AAPL	Stock	37.9875	38.0	37.9375	37.9975	43812.0
2017-07-25 09:25:00	AAPL	Stock	37.975	38.075	37.975	38.06	113664.0
2017-07-25 09:30:00	AAPL	Stock	37.95	38.235	37.95	38.1902	4943320.0
2017-07-25 09:35:00	AAPL	Stock	38.19	38.2475	38.18	38.2222	2384460.0
2017-07-25 09:40:00	AAPL	Stock	38.2225	38.3575	38.2012	38.35	3281872.0
2017-07-25 09:45:00	AAPL	Stock	38.3525	38.3525	38.265	38.2775	1720860.0
2017-07-25 09:50:00	AAPL	Stock	38.2725	38.365	38.2525	38.3612	1957380.0
2017-07-25 09:55:00	AAPL	Stock	38.3625	38.4238	38.3425	38.4	1681484.0
2017-07-25 10:00:00	AAPL	Stock	38.4	38.4275	38.3575	38.3938	1490480.0
2017-07-25 10:05:00	AAPL	Stock	38.395	38.4	38.315	38.3302	1034812.0
2017-07-25 10:10:00	AAPL	Stock	38.3325	38.395	38.325	38.345	818448.0
2017-07-25 10:15:00	AAPL	Stock	38.3465	38.4075	38.3425	38.3925	895876.0
2017-07-25 10:20:00	AAPL	Stock	38.3925	38.425	38.365	38.3675	1141336.0
2017-07-25 10:25:00	AAPL	Stock	38.3675	38.3862	38.365	38.3685	470876.0
2017-07-25 10:30:00	AAPL	Stock	38.3725	38.3748	38.315	38.32	665824.0
2017-07-25 10:35:00	AAPL	Stock	38.32	38.3225	38.2825	38.295	804324.0
2017-07-25 10:40:00	AAPL	Stock	38.2975	38.336	38.295	38.33	566236.0
2017-07-25 10:45:00	AAPL	Stock	38.3312	38.3325	38.29	38.325	531556.0
2017-07-25 10:50:00	AAPL	Stock	38.325	38.3312	38.3025	38.3088	570168.0
2017-07-25 10:55:00	AAPL	Stock	38.31	38.3275	38.3013	38.3262	775696.0
2017-07-25 11:00:00	AAPL	Stock	38.3275	38.385	38.3275	38.38	901204.0
2017-07-25 11:05:00	AAPL	Stock	38.38	38.38	38.3575	38.37	403196.0
2017-07-25 11:10:00	AAPL	Stock	38.3725	38.4025	38.345	38.355	890060.0
2017-07-25 11:15:00	AAPL	Stock	38.3575	38.3708	38.31	38.3708	632548.0

> showing 50 of 355,218 rows — these rows as CSV

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