PREVIEW / stock_5min / 2018-06-27

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-27.parquet
  size:    5.7 MB
  rows:    368,567
  symbols: 2,815

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-27 04:00:00	AAPL	Stock	45.9725	45.9725	45.7	45.75	25672.0
2018-06-27 04:05:00	AAPL	Stock	45.7	45.75	45.6875	45.75	9208.0
2018-06-27 04:10:00	AAPL	Stock	45.7375	45.7375	45.725	45.725	2400.0
2018-06-27 04:25:00	AAPL	Stock	45.7275	45.7275	45.625	45.625	2560.0
2018-06-27 04:40:00	AAPL	Stock	45.625	45.6325	45.625	45.6325	2000.0
2018-06-27 04:50:00	AAPL	Stock	45.625	45.625	45.625	45.625	6200.0
2018-06-27 04:55:00	AAPL	Stock	45.625	45.625	45.625	45.625	2160.0
2018-06-27 05:00:00	AAPL	Stock	45.7	45.7	45.7	45.7	5292.0
2018-06-27 05:20:00	AAPL	Stock	45.8075	45.8075	45.8075	45.8075	1600.0
2018-06-27 05:25:00	AAPL	Stock	45.8	45.8	45.8	45.8	400.0
2018-06-27 05:45:00	AAPL	Stock	45.8	45.8	45.8	45.8	400.0
2018-06-27 05:55:00	AAPL	Stock	45.835	45.92	45.835	45.92	12784.0
2018-06-27 06:05:00	AAPL	Stock	45.85	45.85	45.85	45.85	3872.0
2018-06-27 06:25:00	AAPL	Stock	45.8625	45.8625	45.8625	45.8625	400.0
2018-06-27 06:40:00	AAPL	Stock	45.8575	45.8625	45.8575	45.8625	1532.0
2018-06-27 06:50:00	AAPL	Stock	45.8875	45.9	45.8875	45.9	9132.0
2018-06-27 06:55:00	AAPL	Stock	45.9	45.925	45.875	45.875	17600.0
2018-06-27 07:00:00	AAPL	Stock	45.9125	45.9575	45.9125	45.95	12892.0
2018-06-27 07:05:00	AAPL	Stock	45.95	45.965	45.925	45.965	14360.0
2018-06-27 07:10:00	AAPL	Stock	45.93	45.93	45.9	45.905	3420.0
2018-06-27 07:15:00	AAPL	Stock	45.905	45.905	45.875	45.875	8108.0
2018-06-27 07:20:00	AAPL	Stock	45.8475	45.885	45.825	45.885	19208.0
2018-06-27 07:25:00	AAPL	Stock	45.875	45.875	45.85	45.8725	7000.0
2018-06-27 07:30:00	AAPL	Stock	45.825	45.8575	45.825	45.8375	6580.0
2018-06-27 07:35:00	AAPL	Stock	45.8425	45.8575	45.8375	45.8575	4400.0
2018-06-27 07:40:00	AAPL	Stock	45.825	45.87	45.8	45.845	23528.0
2018-06-27 07:45:00	AAPL	Stock	45.8375	46.255	45.8375	46.25	95440.0
2018-06-27 07:50:00	AAPL	Stock	46.2025	46.28	46.175	46.175	48640.0
2018-06-27 07:55:00	AAPL	Stock	46.175	46.22	46.1575	46.1975	13352.0
2018-06-27 08:00:00	AAPL	Stock	46.22	46.2575	45.8	46.2	103652.0
2018-06-27 08:05:00	AAPL	Stock	46.1975	46.28	46.18	46.275	34672.0
2018-06-27 08:10:00	AAPL	Stock	46.2825	46.45	46.2625	46.445	101436.0
2018-06-27 08:15:00	AAPL	Stock	46.45	46.48	46.375	46.3925	66324.0
2018-06-27 08:20:00	AAPL	Stock	46.3725	46.3725	46.2825	46.2975	17488.0
2018-06-27 08:25:00	AAPL	Stock	46.3025	46.35	46.255	46.2725	15080.0
2018-06-27 08:30:00	AAPL	Stock	46.2875	46.39	46.2875	46.39	38160.0
2018-06-27 08:35:00	AAPL	Stock	46.3725	46.44	46.325	46.44	39224.0
2018-06-27 08:40:00	AAPL	Stock	46.4375	46.4375	46.3625	46.3625	15596.0
2018-06-27 08:45:00	AAPL	Stock	46.375	46.3775	46.275	46.275	26840.0
2018-06-27 08:50:00	AAPL	Stock	46.2775	46.335	46.275	46.335	12400.0
2018-06-27 08:55:00	AAPL	Stock	46.315	46.33	46.205	46.205	29788.0
2018-06-27 09:00:00	AAPL	Stock	46.2275	46.31	46.2275	46.2875	36340.0
2018-06-27 09:05:00	AAPL	Stock	46.2875	46.3	46.25	46.25	10940.0
2018-06-27 09:10:00	AAPL	Stock	46.25	46.2975	46.25	46.2975	15188.0
2018-06-27 09:15:00	AAPL	Stock	46.2825	46.2875	46.2725	46.2875	6312.0
2018-06-27 09:20:00	AAPL	Stock	46.3	46.3375	46.2925	46.3375	17248.0
2018-06-27 09:25:00	AAPL	Stock	46.3375	46.375	46.31	46.31	8520.0
2018-06-27 09:30:00	AAPL	Stock	46.307	46.54	46.295	46.445	2820476.0
2018-06-27 09:35:00	AAPL	Stock	46.445	46.5275	46.42	46.4575	1281520.0
2018-06-27 09:40:00	AAPL	Stock	46.4575	46.5175	46.3925	46.485	1478300.0

> showing 50 of 368,567 rows — these rows as CSV

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