PREVIEW / stock_5min / 2019-06-27

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-06-27.parquet
  size:    5.7 MB
  rows:    365,868
  symbols: 2,621

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
2019-06-27 04:00:00	AAPL	Stock	50.2275	50.25	50.1875	50.25	2048.0
2019-06-27 04:05:00	AAPL	Stock	50.2825	50.305	50.28	50.305	2792.0
2019-06-27 04:30:00	AAPL	Stock	50.275	50.275	50.275	50.275	400.0
2019-06-27 04:35:00	AAPL	Stock	50.3125	50.3125	50.25	50.25	2272.0
2019-06-27 04:40:00	AAPL	Stock	50.25	50.25	50.25	50.25	800.0
2019-06-27 04:45:00	AAPL	Stock	50.25	50.25	50.22	50.22	3292.0
2019-06-27 04:55:00	AAPL	Stock	50.245	50.245	50.245	50.245	800.0
2019-06-27 05:00:00	AAPL	Stock	50.2375	50.2375	50.2375	50.2375	400.0
2019-06-27 05:05:00	AAPL	Stock	50.2	50.2	50.2	50.2	1880.0
2019-06-27 05:25:00	AAPL	Stock	50.2625	50.3075	50.2525	50.2525	2400.0
2019-06-27 05:35:00	AAPL	Stock	50.325	50.3425	50.325	50.3425	14084.0
2019-06-27 05:40:00	AAPL	Stock	50.3575	50.36	50.3175	50.3175	10800.0
2019-06-27 05:45:00	AAPL	Stock	50.3225	50.43	50.3225	50.35	11160.0
2019-06-27 05:50:00	AAPL	Stock	50.315	50.315	50.175	50.175	16940.0
2019-06-27 05:55:00	AAPL	Stock	50.1825	50.1825	50.1825	50.1825	800.0
2019-06-27 06:00:00	AAPL	Stock	50.165	50.165	50.025	50.025	18880.0
2019-06-27 06:05:00	AAPL	Stock	50.015	50.0275	50.0	50.0275	8000.0
2019-06-27 06:10:00	AAPL	Stock	50.0275	50.05	50.01	50.05	2800.0
2019-06-27 06:25:00	AAPL	Stock	50.125	50.125	50.125	50.125	800.0
2019-06-27 06:30:00	AAPL	Stock	50.1425	50.1425	50.0775	50.1375	4800.0
2019-06-27 06:35:00	AAPL	Stock	50.0875	50.0875	50.0775	50.0775	2036.0
2019-06-27 06:45:00	AAPL	Stock	50.085	50.0975	50.0425	50.0975	6392.0
2019-06-27 06:50:00	AAPL	Stock	50.0975	50.0975	50.0975	50.0975	26052.0
2019-06-27 06:55:00	AAPL	Stock	50.1	50.1175	50.1	50.1175	800.0
2019-06-27 07:00:00	AAPL	Stock	50.1025	50.1125	50.1	50.11	21592.0
2019-06-27 07:05:00	AAPL	Stock	50.11	50.1175	50.0875	50.095	31944.0
2019-06-27 07:10:00	AAPL	Stock	50.1	50.11	50.0775	50.11	6080.0
2019-06-27 07:15:00	AAPL	Stock	50.0925	50.095	50.0825	50.0825	11092.0
2019-06-27 07:20:00	AAPL	Stock	50.0875	50.1	50.0875	50.1	9428.0
2019-06-27 07:25:00	AAPL	Stock	50.0875	50.0875	50.07	50.07	8200.0
2019-06-27 07:30:00	AAPL	Stock	50.0625	50.0825	50.0075	50.0075	24092.0
2019-06-27 07:35:00	AAPL	Stock	50.0225	50.055	50.0225	50.025	7200.0
2019-06-27 07:40:00	AAPL	Stock	50.05	50.055	50.0375	50.0375	9696.0
2019-06-27 07:45:00	AAPL	Stock	50.0375	50.0525	50.0375	50.0375	6268.0
2019-06-27 07:50:00	AAPL	Stock	50.025	50.0375	50.025	50.0375	1600.0
2019-06-27 07:55:00	AAPL	Stock	50.0625	50.0625	50.0325	50.0325	10340.0
2019-06-27 08:00:00	AAPL	Stock	50.1	50.115	50.0375	50.0625	104272.0
2019-06-27 08:05:00	AAPL	Stock	50.06	50.1375	50.06	50.1375	60896.0
2019-06-27 08:10:00	AAPL	Stock	50.165	50.175	50.15	50.15	8652.0
2019-06-27 08:15:00	AAPL	Stock	50.1475	50.1725	50.13	50.13	27124.0
2019-06-27 08:20:00	AAPL	Stock	50.125	50.1475	50.125	50.1475	75332.0
2019-06-27 08:25:00	AAPL	Stock	50.1625	50.175	50.125	50.1625	54896.0
2019-06-27 08:30:00	AAPL	Stock	50.1725	50.205	50.1725	50.2	69900.0
2019-06-27 08:35:00	AAPL	Stock	50.17	50.17	50.105	50.1075	21680.0
2019-06-27 08:40:00	AAPL	Stock	50.1125	50.1125	50.1	50.1	23020.0
2019-06-27 08:45:00	AAPL	Stock	50.1125	50.15	50.1075	50.15	25376.0
2019-06-27 08:50:00	AAPL	Stock	50.1375	50.15	50.12	50.125	9760.0
2019-06-27 08:55:00	AAPL	Stock	50.125	50.1375	50.1025	50.1375	27180.0
2019-06-27 09:00:00	AAPL	Stock	50.15	50.15	50.1225	50.1225	11924.0
2019-06-27 09:05:00	AAPL	Stock	50.1225	50.1225	50.075	50.1225	17372.0

> showing 50 of 365,868 rows — these rows as CSV

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