PREVIEW / stock_5min / 2018-04-05

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-05.parquet
  size:    5.5 MB
  rows:    356,155
  symbols: 2,845

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-04-05 04:00:00	AAPL	Stock	43.2525	43.2525	43.2525	43.2525	2528.0
2018-04-05 04:05:00	AAPL	Stock	43.1575	43.1575	43.1575	43.1575	2000.0
2018-04-05 04:10:00	AAPL	Stock	43.1575	43.2	43.1575	43.2	15000.0
2018-04-05 04:20:00	AAPL	Stock	43.2	43.2	43.1375	43.1375	3808.0
2018-04-05 04:45:00	AAPL	Stock	43.13	43.13	43.13	43.13	800.0
2018-04-05 05:30:00	AAPL	Stock	43.145	43.15	43.145	43.1475	16800.0
2018-04-05 05:50:00	AAPL	Stock	43.125	43.125	43.11	43.125	3412.0
2018-04-05 05:55:00	AAPL	Stock	43.125	43.15	43.125	43.15	8212.0
2018-04-05 06:00:00	AAPL	Stock	43.1475	43.1475	43.1475	43.1475	3940.0
2018-04-05 06:05:00	AAPL	Stock	43.1225	43.1225	43.1	43.1	4136.0
2018-04-05 06:10:00	AAPL	Stock	43.1225	43.1225	43.1225	43.1225	2868.0
2018-04-05 06:15:00	AAPL	Stock	43.1475	43.1475	43.1475	43.1475	3996.0
2018-04-05 06:20:00	AAPL	Stock	43.15	43.15	43.15	43.15	4000.0
2018-04-05 06:45:00	AAPL	Stock	43.1375	43.1375	43.125	43.125	3412.0
2018-04-05 06:50:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-04-05 06:55:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-04-05 07:00:00	AAPL	Stock	43.1225	43.175	43.1225	43.175	33120.0
2018-04-05 07:05:00	AAPL	Stock	43.185	43.2125	43.185	43.1875	14812.0
2018-04-05 07:15:00	AAPL	Stock	43.1975	43.2375	43.1975	43.2375	11928.0
2018-04-05 07:20:00	AAPL	Stock	43.2375	43.25	43.2225	43.25	51164.0
2018-04-05 07:25:00	AAPL	Stock	43.2625	43.295	43.255	43.295	11380.0
2018-04-05 07:30:00	AAPL	Stock	43.2975	43.3	43.2575	43.2825	52620.0
2018-04-05 07:35:00	AAPL	Stock	43.255	43.2625	43.255	43.2625	8120.0
2018-04-05 07:40:00	AAPL	Stock	43.2725	43.2725	43.22	43.22	18336.0
2018-04-05 07:45:00	AAPL	Stock	43.215	43.22	43.1825	43.2	20348.0
2018-04-05 07:50:00	AAPL	Stock	43.2	43.215	43.2	43.215	800.0
2018-04-05 07:55:00	AAPL	Stock	43.22	43.22	43.2	43.21	7264.0
2018-04-05 08:00:00	AAPL	Stock	43.12	43.28	43.12	43.1725	60320.0
2018-04-05 08:05:00	AAPL	Stock	43.1725	43.1875	43.1725	43.1875	17528.0
2018-04-05 08:10:00	AAPL	Stock	43.215	43.2375	43.2	43.225	46048.0
2018-04-05 08:15:00	AAPL	Stock	43.2325	43.255	43.2125	43.255	27764.0
2018-04-05 08:20:00	AAPL	Stock	43.26	43.2625	43.225	43.2465	45824.0
2018-04-05 08:25:00	AAPL	Stock	43.2375	43.2425	43.15	43.15	18580.0
2018-04-05 08:30:00	AAPL	Stock	43.15	43.2225	43.1375	43.2225	24672.0
2018-04-05 08:35:00	AAPL	Stock	43.18	43.22	43.18	43.22	45480.0
2018-04-05 08:40:00	AAPL	Stock	43.2445	43.25	43.2325	43.2375	28380.0
2018-04-05 08:45:00	AAPL	Stock	43.2495	43.2575	43.225	43.225	50320.0
2018-04-05 08:50:00	AAPL	Stock	43.215	43.2522	43.215	43.24	29032.0
2018-04-05 08:55:00	AAPL	Stock	43.2375	43.2525	43.23	43.245	18700.0
2018-04-05 09:00:00	AAPL	Stock	43.2375	43.249	43.225	43.249	15912.0
2018-04-05 09:05:00	AAPL	Stock	43.2425	43.25	43.2375	43.2375	33120.0
2018-04-05 09:10:00	AAPL	Stock	43.2375	43.2375	43.2025	43.205	44060.0
2018-04-05 09:15:00	AAPL	Stock	43.195	43.225	43.1875	43.1875	35500.0
2018-04-05 09:20:00	AAPL	Stock	43.2	43.21	43.2	43.2	14200.0
2018-04-05 09:25:00	AAPL	Stock	43.1875	43.19	43.1075	43.15	50304.0
2018-04-05 09:30:00	AAPL	Stock	43.145	43.3675	43.02	43.322	5017900.0
2018-04-05 09:35:00	AAPL	Stock	43.33	43.3462	43.235	43.2625	2646268.0
2018-04-05 09:40:00	AAPL	Stock	43.265	43.39	43.24	43.3478	2672424.0
2018-04-05 09:45:00	AAPL	Stock	43.345	43.3625	43.15	43.205	2772568.0
2018-04-05 09:50:00	AAPL	Stock	43.2075	43.2575	43.15	43.25	1560916.0

> showing 50 of 356,155 rows — these rows as CSV

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