PREVIEW / stock_5min / 2018-08-06

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-06.parquet
  size:    5.4 MB
  rows:    347,132
  symbols: 2,804

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
2018-08-06 04:00:00	AAPL	Stock	52.0175	52.05	52.0175	52.05	1576.0
2018-08-06 04:20:00	AAPL	Stock	52.06	52.06	52.06	52.06	720.0
2018-08-06 04:25:00	AAPL	Stock	52.0475	52.0475	52.0475	52.0475	1200.0
2018-08-06 04:50:00	AAPL	Stock	52.0	52.0	51.9975	51.9975	2536.0
2018-08-06 04:55:00	AAPL	Stock	51.925	51.925	51.925	51.925	2000.0
2018-08-06 05:00:00	AAPL	Stock	51.92	51.92	51.92	51.92	400.0
2018-08-06 05:15:00	AAPL	Stock	51.9475	51.95	51.9475	51.95	2000.0
2018-08-06 05:20:00	AAPL	Stock	51.9	51.9375	51.8875	51.9375	9692.0
2018-08-06 05:45:00	AAPL	Stock	51.99	51.99	51.99	51.99	2608.0
2018-08-06 05:50:00	AAPL	Stock	51.99	52.0	51.99	52.0	2164.0
2018-08-06 06:10:00	AAPL	Stock	52.0	52.0	52.0	52.0	400.0
2018-08-06 06:30:00	AAPL	Stock	52.025	52.05	52.0	52.0	20308.0
2018-08-06 07:00:00	AAPL	Stock	52.03	52.0775	52.0225	52.0625	46596.0
2018-08-06 07:05:00	AAPL	Stock	52.05	52.0575	52.05	52.05	19908.0
2018-08-06 07:10:00	AAPL	Stock	52.0575	52.0625	52.0275	52.0275	15136.0
2018-08-06 07:15:00	AAPL	Stock	52.0475	52.0475	52.0475	52.0475	6360.0
2018-08-06 07:20:00	AAPL	Stock	52.03	52.0675	52.03	52.0675	10140.0
2018-08-06 07:25:00	AAPL	Stock	52.05	52.05	52.05	52.05	488.0
2018-08-06 07:30:00	AAPL	Stock	52.05	52.0775	52.05	52.0625	9912.0
2018-08-06 07:35:00	AAPL	Stock	52.0625	52.0625	52.05	52.05	13600.0
2018-08-06 07:40:00	AAPL	Stock	52.05	52.05	52.0325	52.0325	13992.0
2018-08-06 07:50:00	AAPL	Stock	52.0325	52.055	52.0325	52.05	12332.0
2018-08-06 07:55:00	AAPL	Stock	52.0375	52.0475	52.02	52.0425	10676.0
2018-08-06 08:00:00	AAPL	Stock	52.075	52.0775	51.9975	52.045	99712.0
2018-08-06 08:05:00	AAPL	Stock	52.045	52.06	52.0275	52.0375	71816.0
2018-08-06 08:10:00	AAPL	Stock	52.035	52.0575	52.035	52.05	21200.0
2018-08-06 08:15:00	AAPL	Stock	52.0375	52.0475	52.025	52.025	25908.0
2018-08-06 08:20:00	AAPL	Stock	52.035	52.0375	52.025	52.0375	10592.0
2018-08-06 08:25:00	AAPL	Stock	52.0275	52.0425	52.0125	52.0125	20992.0
2018-08-06 08:30:00	AAPL	Stock	52.0125	52.0275	52.005	52.015	24316.0
2018-08-06 08:35:00	AAPL	Stock	52.025	52.025	51.985	51.985	51416.0
2018-08-06 08:40:00	AAPL	Stock	52.0	52.0	51.9675	51.97	35380.0
2018-08-06 08:45:00	AAPL	Stock	51.9775	51.9775	51.965	51.965	11156.0
2018-08-06 08:50:00	AAPL	Stock	51.965	51.9725	51.9575	51.9725	12476.0
2018-08-06 08:55:00	AAPL	Stock	51.9725	51.9875	51.9725	51.98	35028.0
2018-08-06 09:00:00	AAPL	Stock	51.975	51.9775	51.95	51.9775	12944.0
2018-08-06 09:05:00	AAPL	Stock	51.9775	51.9775	51.975	51.975	1612.0
2018-08-06 09:10:00	AAPL	Stock	51.9875	52.015	51.985	52.015	28528.0
2018-08-06 09:15:00	AAPL	Stock	51.995	52.0175	51.995	52.015	11384.0
2018-08-06 09:20:00	AAPL	Stock	52.0	52.015	51.965	52.0	29620.0
2018-08-06 09:25:00	AAPL	Stock	52.0	52.0	51.975	51.975	22188.0
2018-08-06 09:30:00	AAPL	Stock	51.9825	52.26	51.955	52.2408	4886612.0
2018-08-06 09:35:00	AAPL	Stock	52.2375	52.2425	51.8775	51.9665	4122860.0
2018-08-06 09:40:00	AAPL	Stock	51.9692	52.15	51.94	52.045	3108104.0
2018-08-06 09:45:00	AAPL	Stock	52.0525	52.065	51.975	52.0425	1967940.0
2018-08-06 09:50:00	AAPL	Stock	52.04	52.1148	52.0075	52.055	1932336.0
2018-08-06 09:55:00	AAPL	Stock	52.0525	52.1225	52.0175	52.05	1569716.0
2018-08-06 10:00:00	AAPL	Stock	52.05	52.0725	52.0162	52.0688	1047912.0
2018-08-06 10:05:00	AAPL	Stock	52.0688	52.0725	51.9795	52.0075	1573852.0
2018-08-06 10:10:00	AAPL	Stock	52.0055	52.0275	51.96	51.9975	1157332.0

> showing 50 of 347,132 rows — these rows as CSV

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