PREVIEW / stock_5min / 2018-07-16

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-16.parquet
  size:    5.4 MB
  rows:    350,879
  symbols: 2,801

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-07-16 05:05:00	AAPL	Stock	48.0	48.0	48.0	48.0	400.0
2018-07-16 05:25:00	AAPL	Stock	48.0	48.0	48.0	48.0	2400.0
2018-07-16 07:00:00	AAPL	Stock	47.92	47.9675	47.92	47.9425	55196.0
2018-07-16 07:05:00	AAPL	Stock	47.9425	47.9425	47.9425	47.9425	1200.0
2018-07-16 07:10:00	AAPL	Stock	47.9425	47.9425	47.9325	47.9325	4212.0
2018-07-16 07:15:00	AAPL	Stock	47.925	47.925	47.9	47.9	1200.0
2018-07-16 07:20:00	AAPL	Stock	47.9	47.9	47.8875	47.8875	800.0
2018-07-16 07:25:00	AAPL	Stock	47.89	47.89	47.89	47.89	7688.0
2018-07-16 07:30:00	AAPL	Stock	47.9	47.9125	47.85	47.9125	26740.0
2018-07-16 07:40:00	AAPL	Stock	47.9075	47.9075	47.9075	47.9075	1340.0
2018-07-16 07:45:00	AAPL	Stock	47.8775	47.8775	47.8775	47.8775	400.0
2018-07-16 07:50:00	AAPL	Stock	47.885	47.9125	47.885	47.91	14596.0
2018-07-16 08:00:00	AAPL	Stock	47.9425	47.9725	47.8775	47.8825	37592.0
2018-07-16 08:05:00	AAPL	Stock	47.885	47.885	47.885	47.885	800.0
2018-07-16 08:10:00	AAPL	Stock	47.885	47.8975	47.875	47.875	25652.0
2018-07-16 08:15:00	AAPL	Stock	47.885	47.9	47.885	47.9	9408.0
2018-07-16 08:20:00	AAPL	Stock	47.9	47.9025	47.9	47.9025	1264.0
2018-07-16 08:25:00	AAPL	Stock	47.915	47.915	47.905	47.905	4980.0
2018-07-16 08:30:00	AAPL	Stock	47.905	47.9122	47.9025	47.9025	4188.0
2018-07-16 08:35:00	AAPL	Stock	47.9	47.915	47.9	47.915	12724.0
2018-07-16 08:40:00	AAPL	Stock	47.9075	47.9075	47.9025	47.9025	2032.0
2018-07-16 08:45:00	AAPL	Stock	47.9025	47.9025	47.8625	47.8625	17600.0
2018-07-16 08:50:00	AAPL	Stock	47.895	47.9075	47.8625	47.87	6996.0
2018-07-16 08:55:00	AAPL	Stock	47.87	47.87	47.8625	47.8625	5240.0
2018-07-16 09:00:00	AAPL	Stock	47.875	47.875	47.865	47.875	4764.0
2018-07-16 09:05:00	AAPL	Stock	47.8875	47.8875	47.865	47.8675	4064.0
2018-07-16 09:10:00	AAPL	Stock	47.8825	47.8875	47.8825	47.8875	1600.0
2018-07-16 09:15:00	AAPL	Stock	47.8875	47.8875	47.8325	47.88	13876.0
2018-07-16 09:20:00	AAPL	Stock	47.8775	47.8875	47.8775	47.8875	2800.0
2018-07-16 09:25:00	AAPL	Stock	47.885	47.9075	47.8675	47.9075	16728.0
2018-07-16 09:30:00	AAPL	Stock	47.88	48.1375	47.88	48.0725	3329244.0
2018-07-16 09:35:00	AAPL	Stock	48.0765	48.1625	48.0715	48.1183	1576816.0
2018-07-16 09:40:00	AAPL	Stock	48.12	48.135	48.0375	48.09	1089860.0
2018-07-16 09:45:00	AAPL	Stock	48.1025	48.1138	48.0025	48.0612	1511280.0
2018-07-16 09:50:00	AAPL	Stock	48.06	48.125	48.0475	48.1125	915100.0
2018-07-16 09:55:00	AAPL	Stock	48.115	48.12	48.06	48.0925	881684.0
2018-07-16 10:00:00	AAPL	Stock	48.0925	48.1095	48.0425	48.055	812480.0
2018-07-16 10:05:00	AAPL	Stock	48.0562	48.065	47.9575	47.9875	1171088.0
2018-07-16 10:10:00	AAPL	Stock	47.9875	47.9975	47.92	47.9475	1148200.0
2018-07-16 10:15:00	AAPL	Stock	47.9475	48.005	47.9468	47.9775	545128.0
2018-07-16 10:20:00	AAPL	Stock	47.9775	47.9785	47.9275	47.935	589400.0
2018-07-16 10:25:00	AAPL	Stock	47.9375	47.9575	47.905	47.95	426944.0
2018-07-16 10:30:00	AAPL	Stock	47.9512	47.9825	47.9375	47.97	555976.0
2018-07-16 10:35:00	AAPL	Stock	47.9725	47.9875	47.9325	47.95	433856.0
2018-07-16 10:40:00	AAPL	Stock	47.9475	47.9675	47.9075	47.93	544656.0
2018-07-16 10:45:00	AAPL	Stock	47.9275	47.9375	47.8122	47.8175	1292388.0
2018-07-16 10:50:00	AAPL	Stock	47.8175	47.8425	47.7828	47.83	661228.0
2018-07-16 10:55:00	AAPL	Stock	47.83	47.8325	47.7825	47.7925	476768.0
2018-07-16 11:00:00	AAPL	Stock	47.7925	47.84	47.7875	47.8338	658128.0
2018-07-16 11:05:00	AAPL	Stock	47.8325	47.8425	47.795	47.8075	443180.0

> showing 50 of 350,879 rows — these rows as CSV

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