PREVIEW / stock_5min / 2018-09-24

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-09-24.parquet
  size:    5.6 MB
  rows:    359,814
  symbols: 2,792

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-09-24 04:00:00	AAPL	Stock	54.4125	54.4125	54.375	54.375	4324.0
2018-09-24 04:45:00	AAPL	Stock	54.175	54.175	54.175	54.175	464.0
2018-09-24 04:50:00	AAPL	Stock	54.175	54.175	54.175	54.175	800.0
2018-09-24 05:30:00	AAPL	Stock	54.15	54.15	54.15	54.15	692.0
2018-09-24 05:40:00	AAPL	Stock	54.175	54.175	54.15	54.15	4400.0
2018-09-24 06:20:00	AAPL	Stock	54.2075	54.2075	54.2075	54.2075	400.0
2018-09-24 06:30:00	AAPL	Stock	54.1925	54.1925	54.1875	54.1875	3872.0
2018-09-24 06:40:00	AAPL	Stock	54.1875	54.1875	54.1875	54.1875	1848.0
2018-09-24 06:55:00	AAPL	Stock	54.1875	54.2075	54.1875	54.2075	2400.0
2018-09-24 07:00:00	AAPL	Stock	54.1825	54.22	54.125	54.1875	29376.0
2018-09-24 07:05:00	AAPL	Stock	54.17	54.2	54.17	54.2	2388.0
2018-09-24 07:10:00	AAPL	Stock	54.1875	54.22	54.1875	54.2	3848.0
2018-09-24 07:15:00	AAPL	Stock	54.1975	54.1975	54.14	54.14	40040.0
2018-09-24 07:20:00	AAPL	Stock	54.16	54.1625	54.115	54.1225	31608.0
2018-09-24 07:25:00	AAPL	Stock	54.1225	54.175	54.115	54.1625	14176.0
2018-09-24 07:30:00	AAPL	Stock	54.185	54.2	54.175	54.1975	2892.0
2018-09-24 07:35:00	AAPL	Stock	54.1675	54.22	54.1675	54.22	2596.0
2018-09-24 07:40:00	AAPL	Stock	54.22	54.295	54.2075	54.295	12040.0
2018-09-24 07:45:00	AAPL	Stock	54.25	54.2875	54.25	54.255	4400.0
2018-09-24 07:50:00	AAPL	Stock	54.245	54.25	54.2425	54.25	5728.0
2018-09-24 07:55:00	AAPL	Stock	54.245	54.2475	54.205	54.215	6136.0
2018-09-24 08:00:00	AAPL	Stock	54.2175	54.29	54.1275	54.275	134156.0
2018-09-24 08:05:00	AAPL	Stock	54.2525	54.2675	54.225	54.25	50036.0
2018-09-24 08:10:00	AAPL	Stock	54.25	54.2625	54.24	54.25	40312.0
2018-09-24 08:15:00	AAPL	Stock	54.2325	54.25	54.205	54.205	36828.0
2018-09-24 08:20:00	AAPL	Stock	54.225	54.2375	54.2025	54.2375	14800.0
2018-09-24 08:25:00	AAPL	Stock	54.2275	54.24	54.2125	54.2125	5448.0
2018-09-24 08:30:00	AAPL	Stock	54.2075	54.25	54.205	54.2325	11400.0
2018-09-24 08:35:00	AAPL	Stock	54.25	54.2525	54.23	54.25	6000.0
2018-09-24 08:40:00	AAPL	Stock	54.26	54.2975	54.25	54.2975	14244.0
2018-09-24 08:45:00	AAPL	Stock	54.295	54.335	54.295	54.325	33804.0
2018-09-24 08:50:00	AAPL	Stock	54.325	54.335	54.28	54.2925	15400.0
2018-09-24 08:55:00	AAPL	Stock	54.2925	54.2975	54.25	54.2525	53484.0
2018-09-24 09:00:00	AAPL	Stock	54.255	54.28	54.25	54.2575	21844.0
2018-09-24 09:05:00	AAPL	Stock	54.2625	54.265	54.2125	54.25	106412.0
2018-09-24 09:10:00	AAPL	Stock	54.2475	54.25	54.21	54.25	28448.0
2018-09-24 09:15:00	AAPL	Stock	54.2625	54.3125	54.2625	54.265	40268.0
2018-09-24 09:20:00	AAPL	Stock	54.2625	54.3125	54.2525	54.3125	25624.0
2018-09-24 09:25:00	AAPL	Stock	54.32	54.4625	54.14	54.14	162648.0
2018-09-24 09:30:00	AAPL	Stock	54.2425	54.375	54.1575	54.34	4033388.0
2018-09-24 09:35:00	AAPL	Stock	54.345	54.595	54.3425	54.56	2876336.0
2018-09-24 09:40:00	AAPL	Stock	54.5725	54.665	54.51	54.65	1868800.0
2018-09-24 09:45:00	AAPL	Stock	54.6602	54.7075	54.4875	54.5475	2213564.0
2018-09-24 09:50:00	AAPL	Stock	54.5475	54.576	54.5125	54.55	1056108.0
2018-09-24 09:55:00	AAPL	Stock	54.5488	54.6275	54.395	54.4825	2045884.0
2018-09-24 10:00:00	AAPL	Stock	54.4825	54.5225	54.3425	54.435	1393000.0
2018-09-24 10:05:00	AAPL	Stock	54.4375	54.4775	54.3888	54.4675	1111868.0
2018-09-24 10:10:00	AAPL	Stock	54.4675	54.4675	54.295	54.34	1552208.0
2018-09-24 10:15:00	AAPL	Stock	54.34	54.3975	54.3275	54.36	1089648.0
2018-09-24 10:20:00	AAPL	Stock	54.362	54.415	54.295	54.375	871452.0

> showing 50 of 359,814 rows — these rows as CSV

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