PREVIEW / stock_5min / 2019-04-05

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-04-05.parquet
  size:    5.6 MB
  rows:    357,269
  symbols: 2,651

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-04-05 04:00:00	AAPL	Stock	49.05	49.17	49.05	49.17	2132.0
2019-04-05 04:25:00	AAPL	Stock	49.075	49.075	49.075	49.075	400.0
2019-04-05 04:45:00	AAPL	Stock	49.075	49.075	49.075	49.075	400.0
2019-04-05 04:50:00	AAPL	Stock	49.075	49.075	49.075	49.075	800.0
2019-04-05 04:55:00	AAPL	Stock	49.075	49.075	49.075	49.075	400.0
2019-04-05 05:15:00	AAPL	Stock	49.075	49.075	49.075	49.075	400.0
2019-04-05 05:25:00	AAPL	Stock	49.075	49.075	49.075	49.075	3148.0
2019-04-05 05:35:00	AAPL	Stock	49.1125	49.205	49.1125	49.205	4668.0
2019-04-05 05:55:00	AAPL	Stock	49.075	49.075	49.075	49.075	2000.0
2019-04-05 06:10:00	AAPL	Stock	49.02	49.02	49.02	49.02	400.0
2019-04-05 07:00:00	AAPL	Stock	49.0625	49.0625	49.025	49.025	4756.0
2019-04-05 07:05:00	AAPL	Stock	49.04	49.0475	49.04	49.0475	4788.0
2019-04-05 07:10:00	AAPL	Stock	49.0375	49.0375	49.02	49.02	26264.0
2019-04-05 07:15:00	AAPL	Stock	49.025	49.035	49.0225	49.0275	9324.0
2019-04-05 07:20:00	AAPL	Stock	49.025	49.0275	49.0125	49.0275	17124.0
2019-04-05 07:25:00	AAPL	Stock	49.005	49.0275	49.0	49.0275	14360.0
2019-04-05 07:30:00	AAPL	Stock	49.025	49.025	49.0	49.0	4356.0
2019-04-05 07:35:00	AAPL	Stock	49.0125	49.0125	49.0125	49.0125	2000.0
2019-04-05 07:40:00	AAPL	Stock	49.0125	49.0125	49.005	49.0125	2016.0
2019-04-05 07:50:00	AAPL	Stock	49.0025	49.015	49.0025	49.015	2800.0
2019-04-05 07:55:00	AAPL	Stock	49.0175	49.0175	49.0175	49.0175	1600.0
2019-04-05 08:00:00	AAPL	Stock	49.06	49.06	49.0	49.035	18088.0
2019-04-05 08:05:00	AAPL	Stock	49.025	49.025	49.0	49.0	26548.0
2019-04-05 08:10:00	AAPL	Stock	48.98	48.98	48.98	48.98	400.0
2019-04-05 08:15:00	AAPL	Stock	49.0125	49.024	49.0	49.024	6400.0
2019-04-05 08:25:00	AAPL	Stock	49.015	49.0375	49.015	49.0325	13656.0
2019-04-05 08:30:00	AAPL	Stock	49.0325	49.115	49.0325	49.1125	39544.0
2019-04-05 08:35:00	AAPL	Stock	49.12	49.175	49.12	49.15	34084.0
2019-04-05 08:40:00	AAPL	Stock	49.1475	49.15	49.115	49.15	16564.0
2019-04-05 08:45:00	AAPL	Stock	49.125	49.1375	49.1125	49.1375	6756.0
2019-04-05 08:50:00	AAPL	Stock	49.1125	49.1375	49.0875	49.1175	8808.0
2019-04-05 08:55:00	AAPL	Stock	49.145	49.145	49.1025	49.1225	19260.0
2019-04-05 09:00:00	AAPL	Stock	49.1028	49.15	49.1002	49.1268	13500.0
2019-04-05 09:05:00	AAPL	Stock	49.1375	49.14	49.113	49.113	9068.0
2019-04-05 09:10:00	AAPL	Stock	49.1275	49.13	49.1	49.1112	21092.0
2019-04-05 09:15:00	AAPL	Stock	49.111	49.15	49.111	49.15	14616.0
2019-04-05 09:20:00	AAPL	Stock	49.1625	49.1725	49.15	49.1525	16292.0
2019-04-05 09:25:00	AAPL	Stock	49.15	49.1725	49.0925	49.1025	9256.0
2019-04-05 09:30:00	AAPL	Stock	49.1125	49.154	48.9825	49.1262	4110948.0
2019-04-05 09:35:00	AAPL	Stock	49.1275	49.275	49.0788	49.0875	3301656.0
2019-04-05 09:40:00	AAPL	Stock	49.095	49.1962	49.0	49.1425	2205516.0
2019-04-05 09:45:00	AAPL	Stock	49.1425	49.2075	49.115	49.13	1252064.0
2019-04-05 09:50:00	AAPL	Stock	49.13	49.1875	49.05	49.125	1407508.0
2019-04-05 09:55:00	AAPL	Stock	49.1295	49.1875	49.0928	49.1525	1605868.0
2019-04-05 10:00:00	AAPL	Stock	49.155	49.205	49.1275	49.16	1263828.0
2019-04-05 10:05:00	AAPL	Stock	49.1625	49.1925	49.1275	49.1675	1000184.0
2019-04-05 10:10:00	AAPL	Stock	49.1675	49.1948	49.1	49.1575	922872.0
2019-04-05 10:15:00	AAPL	Stock	49.165	49.1888	49.14	49.1475	722812.0
2019-04-05 10:20:00	AAPL	Stock	49.1525	49.1675	49.0575	49.0988	842804.0
2019-04-05 10:25:00	AAPL	Stock	49.1	49.1075	49.0325	49.0962	1171736.0

> showing 50 of 357,269 rows — these rows as CSV

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