PREVIEW / stock_5min / 2015-01-27

all stock 5-min files

  file:    by_date/stock_5min/2015/2015-01-27.parquet
  size:    5.4 MB
  rows:    357,849
  symbols: 3,506

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
2015-01-27 04:00:00	AAPL	Stock	28.4	28.4625	28.4	28.45	3200.0
2015-01-27 04:05:00	AAPL	Stock	28.4125	28.425	28.4125	28.425	800.0
2015-01-27 04:10:00	AAPL	Stock	28.425	28.4375	28.425	28.4375	800.0
2015-01-27 04:15:00	AAPL	Stock	28.445	28.445	28.445	28.445	1600.0
2015-01-27 04:20:00	AAPL	Stock	28.445	28.445	28.4	28.4	2000.0
2015-01-27 04:45:00	AAPL	Stock	28.4575	28.4575	28.425	28.425	2800.0
2015-01-27 04:50:00	AAPL	Stock	28.4375	28.4475	28.4375	28.4375	11112.0
2015-01-27 04:55:00	AAPL	Stock	28.445	28.4475	28.4375	28.4375	3600.0
2015-01-27 05:10:00	AAPL	Stock	28.445	28.445	28.445	28.445	800.0
2015-01-27 05:15:00	AAPL	Stock	28.4275	28.4275	28.4025	28.4025	21764.0
2015-01-27 05:20:00	AAPL	Stock	28.4025	28.4025	28.375	28.375	5200.0
2015-01-27 05:30:00	AAPL	Stock	28.4	28.4025	28.4	28.4	3200.0
2015-01-27 05:35:00	AAPL	Stock	28.4125	28.425	28.4125	28.425	2000.0
2015-01-27 05:50:00	AAPL	Stock	28.3925	28.42	28.39	28.42	5400.0
2015-01-27 06:00:00	AAPL	Stock	28.3925	28.4125	28.385	28.41	7740.0
2015-01-27 06:05:00	AAPL	Stock	28.4225	28.425	28.385	28.385	2200.0
2015-01-27 06:10:00	AAPL	Stock	28.3925	28.43	28.39	28.43	3900.0
2015-01-27 06:15:00	AAPL	Stock	28.43	28.43	28.43	28.43	800.0
2015-01-27 06:20:00	AAPL	Stock	28.42	28.42	28.3925	28.3925	800.0
2015-01-27 06:25:00	AAPL	Stock	28.39	28.39	28.385	28.385	1600.0
2015-01-27 06:30:00	AAPL	Stock	28.42	28.42	28.375	28.375	2800.0
2015-01-27 06:35:00	AAPL	Stock	28.3975	28.4225	28.3975	28.4	7328.0
2015-01-27 06:40:00	AAPL	Stock	28.38	28.38	28.3375	28.34	4168.0
2015-01-27 06:45:00	AAPL	Stock	28.345	28.3975	28.3375	28.3975	6140.0
2015-01-27 06:55:00	AAPL	Stock	28.37	28.3725	28.37	28.3725	1988.0
2015-01-27 07:00:00	AAPL	Stock	28.3725	28.3725	28.305	28.305	26788.0
2015-01-27 07:05:00	AAPL	Stock	28.325	28.375	28.325	28.375	52996.0
2015-01-27 07:10:00	AAPL	Stock	28.395	28.4125	28.375	28.3925	60928.0
2015-01-27 07:15:00	AAPL	Stock	28.415	28.4175	28.3875	28.3875	13488.0
2015-01-27 07:20:00	AAPL	Stock	28.395	28.4	28.395	28.4	1600.0
2015-01-27 07:25:00	AAPL	Stock	28.3775	28.41	28.375	28.38	12892.0
2015-01-27 07:30:00	AAPL	Stock	28.3825	28.4	28.34	28.34	12132.0
2015-01-27 07:35:00	AAPL	Stock	28.3375	28.3375	28.2775	28.3025	75916.0
2015-01-27 07:40:00	AAPL	Stock	28.3175	28.345	28.315	28.315	39432.0
2015-01-27 07:45:00	AAPL	Stock	28.315	28.315	28.2	28.2525	224064.0
2015-01-27 07:50:00	AAPL	Stock	28.2725	28.2825	28.2425	28.275	59420.0
2015-01-27 07:55:00	AAPL	Stock	28.275	28.2925	28.24	28.24	55992.0
2015-01-27 08:00:00	AAPL	Stock	28.24	28.42	28.1925	28.1975	766448.0
2015-01-27 08:05:00	AAPL	Stock	28.2	28.2	28.1025	28.115	281252.0
2015-01-27 08:10:00	AAPL	Stock	28.1125	28.15	28.085	28.1475	171704.0
2015-01-27 08:15:00	AAPL	Stock	28.1425	28.275	28.1275	28.205	201204.0
2015-01-27 08:20:00	AAPL	Stock	28.215	28.23	28.1625	28.1625	155092.0
2015-01-27 08:25:00	AAPL	Stock	28.17	28.1725	28.1	28.1	152764.0
2015-01-27 08:30:00	AAPL	Stock	28.0975	28.1	28.005	28.075	448328.0
2015-01-27 08:35:00	AAPL	Stock	28.075	28.0975	28.0325	28.0375	351044.0
2015-01-27 08:40:00	AAPL	Stock	28.0375	28.0875	28.03	28.0625	230380.0
2015-01-27 08:45:00	AAPL	Stock	28.065	28.14	28.065	28.1275	190400.0
2015-01-27 08:50:00	AAPL	Stock	28.125	28.135	28.11	28.125	95716.0
2015-01-27 08:55:00	AAPL	Stock	28.125	28.1375	28.1	28.1375	117656.0
2015-01-27 09:00:00	AAPL	Stock	28.13	28.15	28.1225	28.125	89056.0

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

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