PREVIEW / stock_5min / 2018-04-17

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-17.parquet
  size:    5.6 MB
  rows:    358,667
  symbols: 2,853

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-04-17 04:00:00	AAPL	Stock	44.1275	44.2525	44.1275	44.2525	15200.0
2018-04-17 04:05:00	AAPL	Stock	44.2675	44.3	44.2675	44.3	10756.0
2018-04-17 04:10:00	AAPL	Stock	44.295	44.295	44.295	44.295	400.0
2018-04-17 04:15:00	AAPL	Stock	44.295	44.295	44.295	44.295	2444.0
2018-04-17 04:25:00	AAPL	Stock	44.2325	44.2325	44.23	44.23	2040.0
2018-04-17 04:30:00	AAPL	Stock	44.165	44.165	44.165	44.165	588.0
2018-04-17 05:45:00	AAPL	Stock	44.15	44.15	44.15	44.15	400.0
2018-04-17 05:55:00	AAPL	Stock	44.2125	44.25	44.2125	44.25	6976.0
2018-04-17 06:10:00	AAPL	Stock	44.27	44.275	44.27	44.275	7524.0
2018-04-17 06:25:00	AAPL	Stock	44.2075	44.2075	44.2075	44.2075	400.0
2018-04-17 06:30:00	AAPL	Stock	44.2625	44.2625	44.2625	44.2625	4000.0
2018-04-17 06:35:00	AAPL	Stock	44.195	44.25	44.195	44.25	1600.0
2018-04-17 06:40:00	AAPL	Stock	44.2025	44.2025	44.2	44.2	1200.0
2018-04-17 06:55:00	AAPL	Stock	44.2475	44.25	44.2475	44.25	4800.0
2018-04-17 07:00:00	AAPL	Stock	44.2	44.25	44.1575	44.2125	25844.0
2018-04-17 07:05:00	AAPL	Stock	44.195	44.195	44.175	44.175	5200.0
2018-04-17 07:10:00	AAPL	Stock	44.195	44.195	44.17	44.17	10420.0
2018-04-17 07:20:00	AAPL	Stock	44.195	44.1975	44.195	44.1975	3660.0
2018-04-17 07:25:00	AAPL	Stock	44.195	44.195	44.1875	44.1875	4320.0
2018-04-17 07:30:00	AAPL	Stock	44.1875	44.1875	44.1875	44.1875	9200.0
2018-04-17 07:35:00	AAPL	Stock	44.1925	44.215	44.1925	44.21	12784.0
2018-04-17 07:40:00	AAPL	Stock	44.205	44.2125	44.205	44.2125	5200.0
2018-04-17 07:55:00	AAPL	Stock	44.2325	44.2325	44.23	44.23	3240.0
2018-04-17 08:00:00	AAPL	Stock	44.17	44.25	44.17	44.2425	47892.0
2018-04-17 08:05:00	AAPL	Stock	44.2475	44.2625	44.2375	44.25	36360.0
2018-04-17 08:10:00	AAPL	Stock	44.2375	44.25	44.235	44.235	3200.0
2018-04-17 08:15:00	AAPL	Stock	44.2375	44.245	44.2275	44.2275	13392.0
2018-04-17 08:20:00	AAPL	Stock	44.245	44.245	44.235	44.2375	4880.0
2018-04-17 08:25:00	AAPL	Stock	44.245	44.245	44.1925	44.1925	19504.0
2018-04-17 08:30:00	AAPL	Stock	44.21	44.2175	44.195	44.21	12800.0
2018-04-17 08:35:00	AAPL	Stock	44.2125	44.215	44.1975	44.215	30776.0
2018-04-17 08:40:00	AAPL	Stock	44.225	44.2275	44.225	44.225	5768.0
2018-04-17 08:45:00	AAPL	Stock	44.22	44.225	44.215	44.225	9704.0
2018-04-17 08:50:00	AAPL	Stock	44.2325	44.2325	44.215	44.22	10320.0
2018-04-17 08:55:00	AAPL	Stock	44.2225	44.2225	44.18	44.18	24468.0
2018-04-17 09:00:00	AAPL	Stock	44.175	44.1975	44.1725	44.1975	13936.0
2018-04-17 09:05:00	AAPL	Stock	44.1975	44.2325	44.195	44.225	18736.0
2018-04-17 09:10:00	AAPL	Stock	44.2175	44.2375	44.2175	44.2375	15132.0
2018-04-17 09:15:00	AAPL	Stock	44.2325	44.2375	44.2175	44.225	21204.0
2018-04-17 09:20:00	AAPL	Stock	44.225	44.225	44.195	44.195	20576.0
2018-04-17 09:25:00	AAPL	Stock	44.1875	44.1875	44.105	44.105	50296.0
2018-04-17 09:30:00	AAPL	Stock	44.105	44.31	44.1025	44.2075	4338592.0
2018-04-17 09:35:00	AAPL	Stock	44.2075	44.3225	44.1875	44.31	2295208.0
2018-04-17 09:40:00	AAPL	Stock	44.31	44.345	44.2575	44.2925	1590540.0
2018-04-17 09:45:00	AAPL	Stock	44.2975	44.3	44.2248	44.2625	1795884.0
2018-04-17 09:50:00	AAPL	Stock	44.263	44.2775	44.225	44.26	1301996.0
2018-04-17 09:55:00	AAPL	Stock	44.265	44.3	44.2375	44.2475	1398048.0
2018-04-17 10:00:00	AAPL	Stock	44.2495	44.3325	44.2425	44.3112	1735684.0
2018-04-17 10:05:00	AAPL	Stock	44.31	44.3575	44.2675	44.281	1488860.0
2018-04-17 10:10:00	AAPL	Stock	44.2825	44.355	44.2825	44.3172	1171236.0

> showing 50 of 358,667 rows — these rows as CSV

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