PREVIEW / stock_5min / 2017-05-01

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-01.parquet
  size:    5.4 MB
  rows:    350,674
  symbols: 3,052

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-05-01 04:05:00	AAPL	Stock	36.0025	36.0025	36.0025	36.0025	400.0
2017-05-01 06:05:00	AAPL	Stock	36.035	36.035	36.035	36.035	400.0
2017-05-01 06:10:00	AAPL	Stock	36.035	36.04	36.035	36.04	3700.0
2017-05-01 06:40:00	AAPL	Stock	36.0325	36.035	36.0325	36.035	8380.0
2017-05-01 07:00:00	AAPL	Stock	36.0575	36.06	36.0475	36.06	7800.0
2017-05-01 07:05:00	AAPL	Stock	36.0625	36.0625	36.0575	36.0575	4400.0
2017-05-01 07:10:00	AAPL	Stock	36.0575	36.0725	36.05	36.05	13784.0
2017-05-01 07:15:00	AAPL	Stock	36.075	36.1025	36.0725	36.0975	9200.0
2017-05-01 07:20:00	AAPL	Stock	36.08	36.1	36.08	36.1	4000.0
2017-05-01 07:25:00	AAPL	Stock	36.1	36.1125	36.1	36.1125	9500.0
2017-05-01 07:30:00	AAPL	Stock	36.0875	36.1	36.0875	36.1	5900.0
2017-05-01 07:35:00	AAPL	Stock	36.11	36.12	36.1	36.12	11884.0
2017-05-01 07:40:00	AAPL	Stock	36.1125	36.1125	36.1	36.1	3676.0
2017-05-01 07:45:00	AAPL	Stock	36.0875	36.095	36.0775	36.095	8328.0
2017-05-01 07:50:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	2400.0
2017-05-01 07:55:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	6876.0
2017-05-01 08:00:00	AAPL	Stock	36.075	36.1175	36.0625	36.1	80348.0
2017-05-01 08:05:00	AAPL	Stock	36.105	36.1075	36.095	36.105	17368.0
2017-05-01 08:10:00	AAPL	Stock	36.1025	36.1075	36.0875	36.0925	24360.0
2017-05-01 08:15:00	AAPL	Stock	36.11	36.12	36.11	36.1125	12480.0
2017-05-01 08:20:00	AAPL	Stock	36.11	36.1175	36.11	36.11	7312.0
2017-05-01 08:25:00	AAPL	Stock	36.115	36.1375	35.9125	36.135	56556.0
2017-05-01 08:30:00	AAPL	Stock	36.135	36.145	36.11	36.125	44552.0
2017-05-01 08:35:00	AAPL	Stock	36.125	36.1775	36.125	36.1775	50532.0
2017-05-01 08:40:00	AAPL	Stock	36.1925	36.1925	36.1525	36.1525	21912.0
2017-05-01 08:45:00	AAPL	Stock	36.16	36.175	36.1525	36.175	24380.0
2017-05-01 08:50:00	AAPL	Stock	36.1675	36.175	36.155	36.17	34508.0
2017-05-01 08:55:00	AAPL	Stock	36.155	36.16	36.15	36.155	27876.0
2017-05-01 09:00:00	AAPL	Stock	36.1675	36.19	36.165	36.1875	52340.0
2017-05-01 09:05:00	AAPL	Stock	36.1925	36.2025	36.1775	36.2025	25620.0
2017-05-01 09:10:00	AAPL	Stock	36.2025	36.2025	36.1875	36.1975	59180.0
2017-05-01 09:15:00	AAPL	Stock	36.1975	36.2275	36.1975	36.205	101004.0
2017-05-01 09:20:00	AAPL	Stock	36.22	36.23	36.2	36.2125	94852.0
2017-05-01 09:25:00	AAPL	Stock	36.2025	36.25	36.1975	36.25	221988.0
2017-05-01 09:30:00	AAPL	Stock	36.275	36.3375	36.24	36.3147	5971548.0
2017-05-01 09:35:00	AAPL	Stock	36.3125	36.3825	36.3025	36.3425	3535980.0
2017-05-01 09:40:00	AAPL	Stock	36.3415	36.3475	36.2675	36.3225	2360828.0
2017-05-01 09:45:00	AAPL	Stock	36.325	36.3725	36.32	36.3658	2267008.0
2017-05-01 09:50:00	AAPL	Stock	36.37	36.4375	36.36	36.4375	3019556.0
2017-05-01 09:55:00	AAPL	Stock	36.435	36.4675	36.4275	36.4475	2413076.0
2017-05-01 10:00:00	AAPL	Stock	36.4475	36.4825	36.43	36.465	1871316.0
2017-05-01 10:05:00	AAPL	Stock	36.4625	36.4925	36.4425	36.445	1579112.0
2017-05-01 10:10:00	AAPL	Stock	36.445	36.455	36.3925	36.4175	2069484.0
2017-05-01 10:15:00	AAPL	Stock	36.4175	36.465	36.4125	36.4487	1635908.0
2017-05-01 10:20:00	AAPL	Stock	36.4487	36.4575	36.4225	36.4315	1060732.0
2017-05-01 10:25:00	AAPL	Stock	36.4318	36.4325	36.4125	36.4235	966260.0
2017-05-01 10:30:00	AAPL	Stock	36.4248	36.4825	36.42	36.4688	1247896.0
2017-05-01 10:35:00	AAPL	Stock	36.47	36.4775	36.4525	36.4675	984620.0
2017-05-01 10:40:00	AAPL	Stock	36.4652	36.475	36.4475	36.4575	973908.0
2017-05-01 10:45:00	AAPL	Stock	36.458	36.4988	36.455	36.4945	1401016.0

> showing 50 of 350,674 rows — these rows as CSV

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