PREVIEW / stock_5min / 2019-07-17

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-17.parquet
  size:    5.6 MB
  rows:    353,967
  symbols: 2,558

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
2019-07-17 04:05:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	400.0
2019-07-17 05:50:00	AAPL	Stock	51.175	51.22	51.175	51.22	1360.0
2019-07-17 06:15:00	AAPL	Stock	51.1975	51.1975	51.1875	51.1875	1600.0
2019-07-17 06:20:00	AAPL	Stock	51.175	51.175	51.175	51.175	1120.0
2019-07-17 06:30:00	AAPL	Stock	51.175	51.175	51.175	51.175	400.0
2019-07-17 06:45:00	AAPL	Stock	51.175	51.175	51.175	51.175	732.0
2019-07-17 06:55:00	AAPL	Stock	51.1325	51.175	51.1325	51.175	8744.0
2019-07-17 07:00:00	AAPL	Stock	51.225	51.2325	51.175	51.175	11592.0
2019-07-17 07:05:00	AAPL	Stock	51.175	51.21	51.15	51.15	5200.0
2019-07-17 07:10:00	AAPL	Stock	51.15	51.175	51.15	51.175	2584.0
2019-07-17 07:15:00	AAPL	Stock	51.175	51.175	51.175	51.175	400.0
2019-07-17 07:20:00	AAPL	Stock	51.175	51.175	51.175	51.175	800.0
2019-07-17 07:25:00	AAPL	Stock	51.1625	51.1625	51.1625	51.1625	2000.0
2019-07-17 07:30:00	AAPL	Stock	51.15	51.15	51.1325	51.15	10348.0
2019-07-17 07:35:00	AAPL	Stock	51.1375	51.14	51.125	51.125	16384.0
2019-07-17 07:40:00	AAPL	Stock	51.105	51.125	51.1025	51.125	2400.0
2019-07-17 07:45:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	800.0
2019-07-17 07:50:00	AAPL	Stock	51.145	51.1475	51.145	51.1475	4400.0
2019-07-17 07:55:00	AAPL	Stock	51.16	51.1625	51.16	51.1625	2400.0
2019-07-17 08:00:00	AAPL	Stock	51.1875	51.225	51.0775	51.155	41820.0
2019-07-17 08:05:00	AAPL	Stock	51.155	51.165	51.155	51.155	3440.0
2019-07-17 08:10:00	AAPL	Stock	51.1625	51.165	51.1625	51.1625	16720.0
2019-07-17 08:15:00	AAPL	Stock	51.155	51.1575	51.125	51.145	3540.0
2019-07-17 08:20:00	AAPL	Stock	51.1625	51.1625	51.125	51.1325	10172.0
2019-07-17 08:25:00	AAPL	Stock	51.135	51.165	51.125	51.125	9084.0
2019-07-17 08:30:00	AAPL	Stock	51.1325	51.1325	51.0	51.004	40284.0
2019-07-17 08:35:00	AAPL	Stock	51.0325	51.0575	51.0275	51.0575	2800.0
2019-07-17 08:40:00	AAPL	Stock	51.0375	51.0375	51.0375	51.0375	1600.0
2019-07-17 08:45:00	AAPL	Stock	51.0525	51.085	51.0375	51.085	14000.0
2019-07-17 08:50:00	AAPL	Stock	51.0675	51.0675	51.065	51.065	4280.0
2019-07-17 08:55:00	AAPL	Stock	51.065	51.065	51.0175	51.0175	22572.0
2019-07-17 09:00:00	AAPL	Stock	51.025	51.065	51.025	51.065	16228.0
2019-07-17 09:05:00	AAPL	Stock	51.03	51.03	51.025	51.03	2000.0
2019-07-17 09:10:00	AAPL	Stock	51.025	51.03	51.025	51.03	2768.0
2019-07-17 09:20:00	AAPL	Stock	51.015	51.05	51.015	51.05	13712.0
2019-07-17 09:25:00	AAPL	Stock	51.05	51.075	50.9575	51.0575	68288.0
2019-07-17 09:30:00	AAPL	Stock	51.0125	51.11	50.915	51.005	3059552.0
2019-07-17 09:35:00	AAPL	Stock	50.9978	51.11	50.9625	51.0972	1255628.0
2019-07-17 09:40:00	AAPL	Stock	51.095	51.1475	51.0525	51.095	1316020.0
2019-07-17 09:45:00	AAPL	Stock	51.1	51.1375	51.0325	51.102	945152.0
2019-07-17 09:50:00	AAPL	Stock	51.1025	51.1625	51.095	51.1225	742132.0
2019-07-17 09:55:00	AAPL	Stock	51.1225	51.165	51.085	51.1325	655372.0
2019-07-17 10:00:00	AAPL	Stock	51.13	51.1525	51.1	51.1125	439556.0
2019-07-17 10:05:00	AAPL	Stock	51.11	51.1312	51.0075	51.01	588956.0
2019-07-17 10:10:00	AAPL	Stock	51.01	51.0525	51.0	51.0042	654600.0
2019-07-17 10:15:00	AAPL	Stock	51.0025	51.1025	50.995	51.0525	862892.0
2019-07-17 10:20:00	AAPL	Stock	51.05	51.1225	51.045	51.0725	522604.0
2019-07-17 10:25:00	AAPL	Stock	51.0725	51.12	51.0725	51.075	351880.0
2019-07-17 10:30:00	AAPL	Stock	51.075	51.1475	51.0575	51.1287	588976.0
2019-07-17 10:35:00	AAPL	Stock	51.1287	51.19	51.1287	51.1525	781524.0

> showing 50 of 353,967 rows — these rows as CSV

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