PREVIEW / stock_5min / 2018-05-24

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-24.parquet
  size:    5.5 MB
  rows:    359,012
  symbols: 2,825

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-05-24 04:00:00	AAPL	Stock	47.1725	47.2375	47.1725	47.2375	4152.0
2018-05-24 04:40:00	AAPL	Stock	47.225	47.225	47.225	47.225	2000.0
2018-05-24 04:45:00	AAPL	Stock	47.245	47.255	47.245	47.25	8700.0
2018-05-24 04:55:00	AAPL	Stock	47.225	47.225	47.225	47.225	480.0
2018-05-24 05:00:00	AAPL	Stock	47.235	47.235	47.235	47.235	4384.0
2018-05-24 05:05:00	AAPL	Stock	47.235	47.235	47.235	47.235	1200.0
2018-05-24 05:15:00	AAPL	Stock	47.25	47.25	47.25	47.25	400.0
2018-05-24 05:30:00	AAPL	Stock	47.2	47.2	47.19	47.19	3644.0
2018-05-24 05:50:00	AAPL	Stock	47.2	47.2375	47.2	47.2375	13844.0
2018-05-24 06:00:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-05-24 06:10:00	AAPL	Stock	47.25	47.2525	47.25	47.25	3276.0
2018-05-24 06:15:00	AAPL	Stock	47.25	47.25	47.25	47.25	3352.0
2018-05-24 06:35:00	AAPL	Stock	47.2175	47.2175	47.2125	47.2125	3552.0
2018-05-24 06:40:00	AAPL	Stock	47.2	47.2	47.2	47.2	11832.0
2018-05-24 06:55:00	AAPL	Stock	47.195	47.2125	47.195	47.2125	6000.0
2018-05-24 07:00:00	AAPL	Stock	47.19	47.2	47.19	47.2	4000.0
2018-05-24 07:05:00	AAPL	Stock	47.1825	47.1975	47.1825	47.1825	9800.0
2018-05-24 07:10:00	AAPL	Stock	47.175	47.175	47.175	47.175	3196.0
2018-05-24 07:15:00	AAPL	Stock	47.1825	47.1825	47.165	47.165	8904.0
2018-05-24 07:20:00	AAPL	Stock	47.165	47.165	47.1525	47.1525	1000.0
2018-05-24 07:25:00	AAPL	Stock	47.1525	47.1525	47.15	47.15	4400.0
2018-05-24 07:30:00	AAPL	Stock	47.165	47.185	47.165	47.185	13920.0
2018-05-24 07:35:00	AAPL	Stock	47.1675	47.175	47.1375	47.15	15972.0
2018-05-24 07:40:00	AAPL	Stock	47.15	47.17	47.1275	47.17	11160.0
2018-05-24 07:45:00	AAPL	Stock	47.1625	47.1625	47.15	47.15	5424.0
2018-05-24 07:50:00	AAPL	Stock	47.1375	47.1825	47.13	47.17	34744.0
2018-05-24 07:55:00	AAPL	Stock	47.1825	47.195	47.1825	47.195	12908.0
2018-05-24 08:00:00	AAPL	Stock	47.2	47.21	47.1375	47.1625	81444.0
2018-05-24 08:05:00	AAPL	Stock	47.1525	47.1525	47.115	47.115	17204.0
2018-05-24 08:10:00	AAPL	Stock	47.115	47.15	47.115	47.15	5868.0
2018-05-24 08:15:00	AAPL	Stock	47.15	47.2	47.1375	47.175	16304.0
2018-05-24 08:20:00	AAPL	Stock	47.1625	47.1625	47.1375	47.15	13200.0
2018-05-24 08:25:00	AAPL	Stock	47.1275	47.1275	47.0875	47.0875	23744.0
2018-05-24 08:30:00	AAPL	Stock	47.1075	47.125	47.1	47.125	7188.0
2018-05-24 08:35:00	AAPL	Stock	47.125	47.135	47.1225	47.1275	6240.0
2018-05-24 08:40:00	AAPL	Stock	47.125	47.14	47.11	47.14	11040.0
2018-05-24 08:45:00	AAPL	Stock	47.1375	47.17	47.1275	47.16	24284.0
2018-05-24 08:50:00	AAPL	Stock	47.1525	47.1625	47.15	47.15	12692.0
2018-05-24 08:55:00	AAPL	Stock	47.15	47.1625	47.1475	47.1625	24360.0
2018-05-24 09:00:00	AAPL	Stock	47.14	47.15	47.1375	47.1475	33216.0
2018-05-24 09:05:00	AAPL	Stock	47.14	47.15	47.1375	47.15	21068.0
2018-05-24 09:10:00	AAPL	Stock	47.145	47.15	47.145	47.15	3060.0
2018-05-24 09:15:00	AAPL	Stock	47.15	47.15	47.1275	47.1275	1500.0
2018-05-24 09:20:00	AAPL	Stock	47.16	47.16	47.125	47.155	3776.0
2018-05-24 09:25:00	AAPL	Stock	47.1525	47.215	47.15	47.1875	119164.0
2018-05-24 09:30:00	AAPL	Stock	47.1925	47.21	47.0025	47.135	3220140.0
2018-05-24 09:35:00	AAPL	Stock	47.13	47.185	47.1075	47.1575	1125160.0
2018-05-24 09:40:00	AAPL	Stock	47.1575	47.1968	47.035	47.0575	1408980.0
2018-05-24 09:45:00	AAPL	Stock	47.06	47.0825	46.8875	46.895	1808748.0
2018-05-24 09:50:00	AAPL	Stock	46.8975	46.9	46.77	46.785	2349476.0

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

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