PREVIEW / stock_5min / 2018-07-11

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-11.parquet
  size:    5.5 MB
  rows:    354,066
  symbols: 2,816

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-07-11 04:00:00	AAPL	Stock	47.15	47.15	47.15	47.15	2000.0
2018-07-11 04:05:00	AAPL	Stock	47.15	47.15	47.15	47.15	5600.0
2018-07-11 04:10:00	AAPL	Stock	47.15	47.15	47.15	47.15	1668.0
2018-07-11 04:25:00	AAPL	Stock	47.125	47.125	47.125	47.125	400.0
2018-07-11 04:45:00	AAPL	Stock	47.125	47.125	47.125	47.125	800.0
2018-07-11 04:50:00	AAPL	Stock	47.1025	47.1025	47.08	47.08	5680.0
2018-07-11 04:55:00	AAPL	Stock	47.015	47.015	47.0025	47.0025	5812.0
2018-07-11 05:15:00	AAPL	Stock	47.0075	47.0075	47.0075	47.0075	400.0
2018-07-11 05:35:00	AAPL	Stock	47.0625	47.0625	47.0625	47.0625	3840.0
2018-07-11 05:45:00	AAPL	Stock	47.0625	47.0625	47.0575	47.0575	2300.0
2018-07-11 05:55:00	AAPL	Stock	47.0575	47.0625	47.0575	47.0625	9500.0
2018-07-11 06:15:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	800.0
2018-07-11 06:20:00	AAPL	Stock	47.145	47.1725	47.145	47.1725	14400.0
2018-07-11 06:35:00	AAPL	Stock	47.1625	47.1625	47.1625	47.1625	400.0
2018-07-11 06:45:00	AAPL	Stock	47.1375	47.1375	47.1375	47.1375	416.0
2018-07-11 07:00:00	AAPL	Stock	47.1475	47.225	47.1475	47.2125	25216.0
2018-07-11 07:05:00	AAPL	Stock	47.21	47.2175	47.21	47.2175	800.0
2018-07-11 07:10:00	AAPL	Stock	47.225	47.2325	47.2125	47.2125	4600.0
2018-07-11 07:15:00	AAPL	Stock	47.235	47.235	47.1875	47.19	12720.0
2018-07-11 07:20:00	AAPL	Stock	47.1875	47.1875	47.1875	47.1875	2000.0
2018-07-11 07:25:00	AAPL	Stock	47.185	47.185	47.15	47.15	11940.0
2018-07-11 07:30:00	AAPL	Stock	47.155	47.1675	47.15	47.15	12360.0
2018-07-11 07:35:00	AAPL	Stock	47.17	47.1875	47.1675	47.185	27856.0
2018-07-11 07:40:00	AAPL	Stock	47.1625	47.175	47.1375	47.175	13532.0
2018-07-11 07:45:00	AAPL	Stock	47.1875	47.1875	47.1875	47.1875	400.0
2018-07-11 07:50:00	AAPL	Stock	47.175	47.1875	47.175	47.1875	1200.0
2018-07-11 07:55:00	AAPL	Stock	47.1875	47.1875	47.1875	47.1875	1800.0
2018-07-11 08:00:00	AAPL	Stock	47.2072	47.2175	47.1625	47.1875	47888.0
2018-07-11 08:05:00	AAPL	Stock	47.1875	47.2425	47.185	47.24	98544.0
2018-07-11 08:10:00	AAPL	Stock	47.2375	47.2875	47.2275	47.2525	30712.0
2018-07-11 08:15:00	AAPL	Stock	47.255	47.2575	47.215	47.215	86136.0
2018-07-11 08:20:00	AAPL	Stock	47.205	47.205	47.175	47.175	33916.0
2018-07-11 08:25:00	AAPL	Stock	47.185	47.2125	47.175	47.1875	90172.0
2018-07-11 08:30:00	AAPL	Stock	47.1875	47.2325	47.1475	47.2275	93384.0
2018-07-11 08:35:00	AAPL	Stock	47.2275	47.2375	47.2025	47.2225	28668.0
2018-07-11 08:40:00	AAPL	Stock	47.2	47.2	47.15	47.15	24520.0
2018-07-11 08:45:00	AAPL	Stock	47.1625	47.17	47.1375	47.17	31680.0
2018-07-11 08:50:00	AAPL	Stock	47.165	47.1725	47.155	47.1575	18288.0
2018-07-11 08:55:00	AAPL	Stock	47.1675	47.175	47.1125	47.13	116728.0
2018-07-11 09:00:00	AAPL	Stock	47.1375	47.1625	47.1	47.1	57196.0
2018-07-11 09:05:00	AAPL	Stock	47.1225	47.125	47.1025	47.1125	23040.0
2018-07-11 09:10:00	AAPL	Stock	47.12	47.12	47.0975	47.1025	21084.0
2018-07-11 09:15:00	AAPL	Stock	47.1025	47.1175	47.1025	47.1125	27628.0
2018-07-11 09:20:00	AAPL	Stock	47.11	47.12	47.095	47.105	29000.0
2018-07-11 09:25:00	AAPL	Stock	47.105	47.1775	47.0875	47.1075	47392.0
2018-07-11 09:30:00	AAPL	Stock	47.125	47.445	47.075	47.4225	3419776.0
2018-07-11 09:35:00	AAPL	Stock	47.4325	47.4425	47.315	47.3225	1063996.0
2018-07-11 09:40:00	AAPL	Stock	47.325	47.39	47.2775	47.28	1123488.0
2018-07-11 09:45:00	AAPL	Stock	47.2775	47.35	47.2225	47.32	1738164.0
2018-07-11 09:50:00	AAPL	Stock	47.3175	47.33	47.2425	47.2475	1017904.0

> showing 50 of 354,066 rows — these rows as CSV

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