PREVIEW / stock_5min / 2017-04-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-20.parquet
  size:    5.4 MB
  rows:    352,657
  symbols: 3,062

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-20 04:00:00	AAPL	Stock	35.25	35.25	35.25	35.25	4000.0
2017-04-20 04:15:00	AAPL	Stock	35.3	35.3	35.3	35.3	4700.0
2017-04-20 04:30:00	AAPL	Stock	35.2975	35.2975	35.2975	35.2975	400.0
2017-04-20 04:45:00	AAPL	Stock	35.3	35.325	35.3	35.325	6732.0
2017-04-20 04:50:00	AAPL	Stock	35.325	35.325	35.325	35.325	2468.0
2017-04-20 04:55:00	AAPL	Stock	35.325	35.35	35.325	35.35	2424.0
2017-04-20 05:10:00	AAPL	Stock	35.345	35.35	35.345	35.35	1600.0
2017-04-20 05:20:00	AAPL	Stock	35.3475	35.3475	35.3475	35.3475	2000.0
2017-04-20 05:25:00	AAPL	Stock	35.35	35.35	35.35	35.35	2800.0
2017-04-20 05:35:00	AAPL	Stock	35.325	35.325	35.325	35.325	960.0
2017-04-20 05:40:00	AAPL	Stock	35.325	35.325	35.325	35.325	2000.0
2017-04-20 05:50:00	AAPL	Stock	35.3425	35.345	35.325	35.345	3708.0
2017-04-20 06:10:00	AAPL	Stock	35.3425	35.3425	35.3425	35.3425	408.0
2017-04-20 06:35:00	AAPL	Stock	35.3	35.3	35.3	35.3	7752.0
2017-04-20 07:05:00	AAPL	Stock	35.3125	35.3125	35.3125	35.3125	1200.0
2017-04-20 07:10:00	AAPL	Stock	35.3	35.3	35.2825	35.2825	4672.0
2017-04-20 07:25:00	AAPL	Stock	35.3	35.325	35.3	35.305	14744.0
2017-04-20 07:30:00	AAPL	Stock	35.335	35.345	35.335	35.345	7000.0
2017-04-20 07:35:00	AAPL	Stock	35.3375	35.3375	35.3225	35.325	5880.0
2017-04-20 07:40:00	AAPL	Stock	35.325	35.325	35.325	35.325	1000.0
2017-04-20 07:45:00	AAPL	Stock	35.325	35.325	35.325	35.325	800.0
2017-04-20 07:55:00	AAPL	Stock	35.325	35.325	35.325	35.325	2000.0
2017-04-20 08:00:00	AAPL	Stock	35.325	35.325	35.3025	35.3125	13488.0
2017-04-20 08:05:00	AAPL	Stock	35.325	35.325	35.325	35.325	11644.0
2017-04-20 08:10:00	AAPL	Stock	35.325	35.33	35.325	35.325	2804.0
2017-04-20 08:15:00	AAPL	Stock	35.3125	35.3325	35.3125	35.325	8376.0
2017-04-20 08:20:00	AAPL	Stock	35.325	35.3325	35.325	35.3325	10000.0
2017-04-20 08:25:00	AAPL	Stock	35.3225	35.3225	35.3125	35.3225	4104.0
2017-04-20 08:30:00	AAPL	Stock	35.3175	35.32	35.3175	35.32	3320.0
2017-04-20 08:35:00	AAPL	Stock	35.32	35.32	35.3125	35.3125	1200.0
2017-04-20 08:40:00	AAPL	Stock	35.32	35.3325	35.3125	35.3125	7240.0
2017-04-20 08:45:00	AAPL	Stock	35.325	35.325	35.3125	35.325	8960.0
2017-04-20 08:50:00	AAPL	Stock	35.3125	35.3125	35.2875	35.2875	10764.0
2017-04-20 08:55:00	AAPL	Stock	35.295	35.315	35.295	35.315	5564.0
2017-04-20 09:00:00	AAPL	Stock	35.305	35.305	35.3	35.3	16752.0
2017-04-20 09:05:00	AAPL	Stock	35.3	35.3125	35.2875	35.2875	7456.0
2017-04-20 09:10:00	AAPL	Stock	35.29	35.29	35.275	35.2825	27096.0
2017-04-20 09:15:00	AAPL	Stock	35.2775	35.29	35.2775	35.29	31288.0
2017-04-20 09:20:00	AAPL	Stock	35.2825	35.2975	35.28	35.2975	8208.0
2017-04-20 09:25:00	AAPL	Stock	35.2875	35.3	35.2875	35.3	3540.0
2017-04-20 09:30:00	AAPL	Stock	35.3025	35.41	35.29	35.405	3832524.0
2017-04-20 09:35:00	AAPL	Stock	35.405	35.4438	35.4025	35.4162	2232880.0
2017-04-20 09:40:00	AAPL	Stock	35.4175	35.4275	35.3738	35.4135	2285056.0
2017-04-20 09:45:00	AAPL	Stock	35.4138	35.435	35.3828	35.388	1548816.0
2017-04-20 09:50:00	AAPL	Stock	35.389	35.45	35.3862	35.4125	1220852.0
2017-04-20 09:55:00	AAPL	Stock	35.4125	35.4125	35.3825	35.4052	1156468.0
2017-04-20 10:00:00	AAPL	Stock	35.4068	35.445	35.406	35.43	1054352.0
2017-04-20 10:05:00	AAPL	Stock	35.4325	35.465	35.41	35.455	907228.0
2017-04-20 10:10:00	AAPL	Stock	35.4525	35.475	35.44	35.45	1553460.0
2017-04-20 10:15:00	AAPL	Stock	35.45	35.46	35.42	35.4275	754008.0

> showing 50 of 352,657 rows — these rows as CSV

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