PREVIEW / stock_5min / 2018-06-18

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-18.parquet
  size:    5.7 MB
  rows:    365,046
  symbols: 2,835

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-06-18 04:00:00	AAPL	Stock	47.08	47.08	47.04	47.0625	4128.0
2018-06-18 04:05:00	AAPL	Stock	46.9525	46.9525	46.9525	46.9525	400.0
2018-06-18 05:00:00	AAPL	Stock	47.0	47.0	47.0	47.0	400.0
2018-06-18 05:05:00	AAPL	Stock	47.0	47.0	47.0	47.0	724.0
2018-06-18 05:15:00	AAPL	Stock	47.0475	47.0475	47.0425	47.0425	7200.0
2018-06-18 05:30:00	AAPL	Stock	47.045	47.045	47.0	47.0	2544.0
2018-06-18 05:35:00	AAPL	Stock	46.9625	46.9625	46.9625	46.9625	784.0
2018-06-18 05:55:00	AAPL	Stock	47.0025	47.0025	47.0025	47.0025	400.0
2018-06-18 06:00:00	AAPL	Stock	47.0	47.0	47.0	47.0	400.0
2018-06-18 06:05:00	AAPL	Stock	46.9775	46.9775	46.9775	46.9775	456.0
2018-06-18 06:15:00	AAPL	Stock	46.9425	46.965	46.9425	46.9425	2000.0
2018-06-18 06:20:00	AAPL	Stock	46.9425	46.9425	46.9425	46.9425	400.0
2018-06-18 06:25:00	AAPL	Stock	46.985	46.985	46.985	46.985	400.0
2018-06-18 06:30:00	AAPL	Stock	46.9175	46.92	46.9	46.9	7344.0
2018-06-18 06:45:00	AAPL	Stock	46.9175	46.9175	46.9025	46.9025	1280.0
2018-06-18 07:00:00	AAPL	Stock	46.935	46.9525	46.9	46.9125	32148.0
2018-06-18 07:05:00	AAPL	Stock	46.9125	46.9125	46.9025	46.9025	2360.0
2018-06-18 07:10:00	AAPL	Stock	46.92	46.9225	46.9	46.905	19124.0
2018-06-18 07:15:00	AAPL	Stock	46.9025	46.905	46.895	46.895	15584.0
2018-06-18 07:25:00	AAPL	Stock	46.9	46.91	46.9	46.91	2680.0
2018-06-18 07:30:00	AAPL	Stock	46.925	46.95	46.92	46.95	13232.0
2018-06-18 07:35:00	AAPL	Stock	46.945	46.945	46.935	46.935	4400.0
2018-06-18 07:40:00	AAPL	Stock	46.935	46.935	46.9125	46.93	30380.0
2018-06-18 07:45:00	AAPL	Stock	46.925	46.925	46.925	46.925	7960.0
2018-06-18 07:50:00	AAPL	Stock	46.9	46.9	46.875	46.875	15520.0
2018-06-18 07:55:00	AAPL	Stock	46.875	46.875	46.875	46.875	400.0
2018-06-18 08:00:00	AAPL	Stock	46.9125	46.9475	46.875	46.9	83916.0
2018-06-18 08:05:00	AAPL	Stock	46.8875	46.905	46.885	46.8875	7200.0
2018-06-18 08:10:00	AAPL	Stock	46.88	46.8825	46.88	46.88	7160.0
2018-06-18 08:15:00	AAPL	Stock	46.8875	46.9	46.855	46.855	17300.0
2018-06-18 08:20:00	AAPL	Stock	46.8625	46.8725	46.8525	46.8725	6520.0
2018-06-18 08:25:00	AAPL	Stock	46.875	46.905	46.8725	46.9	8400.0
2018-06-18 08:30:00	AAPL	Stock	46.8875	46.925	46.8875	46.8925	10140.0
2018-06-18 08:35:00	AAPL	Stock	46.915	46.915	46.89	46.89	3200.0
2018-06-18 08:40:00	AAPL	Stock	46.905	46.925	46.9	46.905	16080.0
2018-06-18 08:45:00	AAPL	Stock	46.9125	46.9325	46.9	46.93	38364.0
2018-06-18 08:50:00	AAPL	Stock	46.93	46.94	46.9075	46.94	11600.0
2018-06-18 08:55:00	AAPL	Stock	46.9425	46.9625	46.9425	46.9625	17940.0
2018-06-18 09:00:00	AAPL	Stock	46.96	46.9625	46.925	46.925	34828.0
2018-06-18 09:05:00	AAPL	Stock	46.9225	46.93	46.9032	46.9032	6200.0
2018-06-18 09:10:00	AAPL	Stock	46.9025	46.9025	46.8968	46.9	5452.0
2018-06-18 09:15:00	AAPL	Stock	46.8975	46.9275	46.8875	46.8875	11072.0
2018-06-18 09:20:00	AAPL	Stock	46.92	46.925	46.875	46.91	15564.0
2018-06-18 09:25:00	AAPL	Stock	46.91	46.9675	46.91	46.9675	66500.0
2018-06-18 09:30:00	AAPL	Stock	46.9675	46.99	46.8	46.91	3304048.0
2018-06-18 09:35:00	AAPL	Stock	46.9125	46.975	46.87	46.94	1438836.0
2018-06-18 09:40:00	AAPL	Stock	46.94	46.995	46.895	46.9775	995924.0
2018-06-18 09:45:00	AAPL	Stock	46.975	47.035	46.925	46.98	1408440.0
2018-06-18 09:50:00	AAPL	Stock	46.98	47.06	46.98	47.025	1182004.0
2018-06-18 09:55:00	AAPL	Stock	47.0225	47.0825	46.995	47.0188	1179028.0

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

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