PREVIEW / stock_5min / 2017-06-16

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-16.parquet
  size:    5.4 MB
  rows:    354,820
  symbols: 3,022

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
2017-06-16 04:00:00	AAPL	Stock	36.175	36.175	36.11	36.11	13492.0
2017-06-16 04:05:00	AAPL	Stock	36.125	36.125	36.125	36.125	4000.0
2017-06-16 04:10:00	AAPL	Stock	36.15	36.15	36.15	36.15	11560.0
2017-06-16 04:20:00	AAPL	Stock	36.19	36.19	36.19	36.19	3820.0
2017-06-16 06:05:00	AAPL	Stock	36.125	36.125	36.125	36.125	400.0
2017-06-16 06:10:00	AAPL	Stock	36.1125	36.1125	36.1125	36.1125	400.0
2017-06-16 06:15:00	AAPL	Stock	36.1125	36.1125	36.1125	36.1125	1276.0
2017-06-16 06:20:00	AAPL	Stock	36.115	36.1475	36.115	36.1475	4000.0
2017-06-16 06:30:00	AAPL	Stock	36.15	36.15	36.15	36.15	1200.0
2017-06-16 06:45:00	AAPL	Stock	36.1625	36.1625	36.125	36.125	800.0
2017-06-16 07:00:00	AAPL	Stock	36.1375	36.1625	36.1375	36.1625	7100.0
2017-06-16 07:10:00	AAPL	Stock	36.155	36.155	36.155	36.155	1200.0
2017-06-16 07:30:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	400.0
2017-06-16 07:35:00	AAPL	Stock	36.145	36.145	36.145	36.145	400.0
2017-06-16 07:40:00	AAPL	Stock	36.1425	36.1425	36.1425	36.1425	4800.0
2017-06-16 07:50:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	2000.0
2017-06-16 07:55:00	AAPL	Stock	36.14	36.14	36.14	36.14	2800.0
2017-06-16 08:00:00	AAPL	Stock	36.1275	36.145	36.09	36.09	36220.0
2017-06-16 08:05:00	AAPL	Stock	36.075	36.1	36.075	36.1	49144.0
2017-06-16 08:10:00	AAPL	Stock	36.1	36.1175	36.1	36.1	16400.0
2017-06-16 08:15:00	AAPL	Stock	36.1025	36.1125	36.1025	36.1075	12808.0
2017-06-16 08:20:00	AAPL	Stock	36.1075	36.1075	36.1075	36.1075	1600.0
2017-06-16 08:25:00	AAPL	Stock	36.0925	36.12	36.0925	36.1	1860.0
2017-06-16 08:30:00	AAPL	Stock	36.12	36.12	36.085	36.085	6024.0
2017-06-16 08:35:00	AAPL	Stock	36.0775	36.0775	36.0675	36.075	9936.0
2017-06-16 08:40:00	AAPL	Stock	36.0625	36.065	36.0375	36.0475	9600.0
2017-06-16 08:45:00	AAPL	Stock	36.0425	36.05	35.9575	36.0	42876.0
2017-06-16 08:50:00	AAPL	Stock	36.025	36.025	35.975	35.975	10112.0
2017-06-16 08:55:00	AAPL	Stock	36.0025	36.0025	35.975	35.9775	5472.0
2017-06-16 09:00:00	AAPL	Stock	35.98	35.98	35.98	35.98	8400.0
2017-06-16 09:05:00	AAPL	Stock	35.9875	36.03	35.9875	36.03	8720.0
2017-06-16 09:10:00	AAPL	Stock	36.03	36.0375	35.985	35.985	13396.0
2017-06-16 09:15:00	AAPL	Stock	36.0	36.0	35.92	35.96	20692.0
2017-06-16 09:20:00	AAPL	Stock	35.9625	35.9625	35.9175	35.925	46176.0
2017-06-16 09:25:00	AAPL	Stock	35.9375	35.9625	35.9	35.935	72928.0
2017-06-16 09:30:00	AAPL	Stock	35.9525	36.005	35.8375	35.8875	35801052.0
2017-06-16 09:35:00	AAPL	Stock	35.8875	35.9625	35.86	35.935	1775288.0
2017-06-16 09:40:00	AAPL	Stock	35.93	35.9825	35.9	35.945	1759524.0
2017-06-16 09:45:00	AAPL	Stock	35.9475	36.0375	35.9275	36.0212	2208980.0
2017-06-16 09:50:00	AAPL	Stock	36.02	36.0725	35.96	36.0625	1836464.0
2017-06-16 09:55:00	AAPL	Stock	36.065	36.125	36.06	36.0912	1861824.0
2017-06-16 10:00:00	AAPL	Stock	36.0875	36.095	35.9925	36.035	1766380.0
2017-06-16 10:05:00	AAPL	Stock	36.0328	36.0425	35.985	36.0198	1300016.0
2017-06-16 10:10:00	AAPL	Stock	36.01	36.0275	35.9462	35.9775	1165412.0
2017-06-16 10:15:00	AAPL	Stock	35.9775	35.99	35.8825	35.8875	1491372.0
2017-06-16 10:20:00	AAPL	Stock	35.89	35.9325	35.86	35.86	1257688.0
2017-06-16 10:25:00	AAPL	Stock	35.86	35.93	35.8425	35.92	1394952.0
2017-06-16 10:30:00	AAPL	Stock	35.9175	35.95	35.8825	35.884	995468.0
2017-06-16 10:35:00	AAPL	Stock	35.8845	35.9312	35.8725	35.915	804624.0
2017-06-16 10:40:00	AAPL	Stock	35.9135	35.9323	35.8925	35.9025	849160.0

> showing 50 of 354,820 rows — these rows as CSV

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