PREVIEW / stock_5min / 2019-10-15

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-10-15.parquet
  size:    5.6 MB
  rows:    352,430
  symbols: 2,500

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-10-15 04:10:00	AAPL	Stock	59.3125	59.3375	59.3125	59.3375	4320.0
2019-10-15 04:25:00	AAPL	Stock	59.3125	59.3125	59.3125	59.3125	1600.0
2019-10-15 04:45:00	AAPL	Stock	59.335	59.3525	59.3125	59.3125	10352.0
2019-10-15 04:50:00	AAPL	Stock	59.3	59.3	59.2625	59.2625	2492.0
2019-10-15 05:05:00	AAPL	Stock	59.2725	59.2725	59.2725	59.2725	400.0
2019-10-15 05:45:00	AAPL	Stock	59.25	59.25	59.25	59.25	400.0
2019-10-15 05:50:00	AAPL	Stock	59.25	59.2525	59.25	59.2525	2328.0
2019-10-15 06:20:00	AAPL	Stock	59.25	59.255	59.125	59.125	24504.0
2019-10-15 06:25:00	AAPL	Stock	59.0575	59.1275	59.05	59.1275	8000.0
2019-10-15 06:50:00	AAPL	Stock	59.1675	59.1675	59.1675	59.1675	400.0
2019-10-15 06:55:00	AAPL	Stock	59.1425	59.1425	59.1425	59.1425	400.0
2019-10-15 07:00:00	AAPL	Stock	59.2	59.2525	59.155	59.2475	49572.0
2019-10-15 07:05:00	AAPL	Stock	59.25	59.275	59.21	59.215	14136.0
2019-10-15 07:10:00	AAPL	Stock	59.21	59.2125	59.15	59.1525	23740.0
2019-10-15 07:15:00	AAPL	Stock	59.16	59.16	59.16	59.16	960.0
2019-10-15 07:20:00	AAPL	Stock	59.175	59.175	59.17	59.17	4400.0
2019-10-15 07:25:00	AAPL	Stock	59.175	59.2075	59.175	59.2075	5216.0
2019-10-15 07:30:00	AAPL	Stock	59.21	59.21	59.195	59.195	6688.0
2019-10-15 07:35:00	AAPL	Stock	59.1675	59.18	59.15	59.18	6740.0
2019-10-15 07:40:00	AAPL	Stock	59.17	59.17	59.1475	59.1475	12500.0
2019-10-15 07:45:00	AAPL	Stock	59.1725	59.1725	59.1375	59.1375	2824.0
2019-10-15 07:50:00	AAPL	Stock	59.13	59.2375	59.13	59.21	42076.0
2019-10-15 07:55:00	AAPL	Stock	59.165	59.1825	59.1275	59.18	14892.0
2019-10-15 08:00:00	AAPL	Stock	59.2575	59.2575	59.13	59.1625	103196.0
2019-10-15 08:05:00	AAPL	Stock	59.1725	59.1875	59.1725	59.18	24424.0
2019-10-15 08:10:00	AAPL	Stock	59.1625	59.1975	59.1625	59.1975	5600.0
2019-10-15 08:15:00	AAPL	Stock	59.195	59.195	59.195	59.195	1600.0
2019-10-15 08:20:00	AAPL	Stock	59.195	59.195	59.1875	59.1875	800.0
2019-10-15 08:25:00	AAPL	Stock	59.19	59.1925	59.1675	59.1675	7752.0
2019-10-15 08:30:00	AAPL	Stock	59.17	59.1875	59.1575	59.1595	29308.0
2019-10-15 08:35:00	AAPL	Stock	59.1575	59.175	59.13	59.1365	8628.0
2019-10-15 08:40:00	AAPL	Stock	59.1325	59.15	59.13	59.145	11200.0
2019-10-15 08:45:00	AAPL	Stock	59.1425	59.15	59.08	59.1025	23604.0
2019-10-15 08:50:00	AAPL	Stock	59.0878	59.1115	59.0878	59.1	4600.0
2019-10-15 08:55:00	AAPL	Stock	59.0975	59.1125	59.0875	59.11	18364.0
2019-10-15 09:00:00	AAPL	Stock	59.11	59.125	59.1	59.125	18572.0
2019-10-15 09:05:00	AAPL	Stock	59.1325	59.16	59.125	59.125	26776.0
2019-10-15 09:10:00	AAPL	Stock	59.1375	59.1875	59.1375	59.1825	8800.0
2019-10-15 09:15:00	AAPL	Stock	59.17	59.1875	59.165	59.1725	34640.0
2019-10-15 09:20:00	AAPL	Stock	59.15	59.16	59.13	59.155	24676.0
2019-10-15 09:25:00	AAPL	Stock	59.1475	59.1725	59.0825	59.0825	67744.0
2019-10-15 09:30:00	AAPL	Stock	59.0975	59.245	59.0125	59.1888	4007468.0
2019-10-15 09:35:00	AAPL	Stock	59.185	59.2225	59.1075	59.2	1167540.0
2019-10-15 09:40:00	AAPL	Stock	59.2042	59.3075	59.195	59.274	1626932.0
2019-10-15 09:45:00	AAPL	Stock	59.2725	59.2975	59.1875	59.275	1024736.0
2019-10-15 09:50:00	AAPL	Stock	59.2775	59.3025	59.2225	59.2345	887344.0
2019-10-15 09:55:00	AAPL	Stock	59.2388	59.2725	59.1825	59.19	953744.0
2019-10-15 10:00:00	AAPL	Stock	59.1925	59.2475	59.1825	59.1982	861620.0
2019-10-15 10:05:00	AAPL	Stock	59.1975	59.205	59.0925	59.18	1525876.0
2019-10-15 10:10:00	AAPL	Stock	59.1798	59.2375	59.17	59.2275	947808.0

> showing 50 of 352,430 rows — these rows as CSV

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