PREVIEW / stock_5min / 2018-03-19

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-19.parquet
  size:    5.6 MB
  rows:    362,707
  symbols: 2,883

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-03-19 04:00:00	AAPL	Stock	44.25	44.25	44.235	44.235	2220.0
2018-03-19 04:15:00	AAPL	Stock	44.1975	44.1975	44.175	44.175	1436.0
2018-03-19 04:25:00	AAPL	Stock	44.05	44.05	44.0325	44.0325	2000.0
2018-03-19 04:30:00	AAPL	Stock	43.95	43.95	43.825	43.835	7180.0
2018-03-19 04:35:00	AAPL	Stock	43.8	43.9375	43.8	43.8425	7980.0
2018-03-19 04:40:00	AAPL	Stock	43.8425	43.8425	43.8325	43.8325	3376.0
2018-03-19 04:45:00	AAPL	Stock	43.8375	43.8725	43.825	43.8725	5600.0
2018-03-19 04:50:00	AAPL	Stock	43.8725	43.8725	43.8725	43.8725	800.0
2018-03-19 05:15:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	4000.0
2018-03-19 05:35:00	AAPL	Stock	43.9825	43.9825	43.9825	43.9825	1880.0
2018-03-19 05:40:00	AAPL	Stock	43.945	43.945	43.9125	43.9125	1784.0
2018-03-19 05:45:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	1200.0
2018-03-19 06:25:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	600.0
2018-03-19 06:30:00	AAPL	Stock	43.8775	43.8775	43.8775	43.8775	800.0
2018-03-19 06:55:00	AAPL	Stock	43.9525	43.9575	43.9525	43.9575	4644.0
2018-03-19 07:00:00	AAPL	Stock	43.9675	44.0775	43.95	44.04	83664.0
2018-03-19 07:05:00	AAPL	Stock	44.05	44.05	44.0	44.005	46140.0
2018-03-19 07:10:00	AAPL	Stock	43.98	43.9925	43.95	43.9675	26280.0
2018-03-19 07:15:00	AAPL	Stock	43.9375	43.975	43.9375	43.975	17812.0
2018-03-19 07:20:00	AAPL	Stock	43.9575	44.05	43.9575	44.05	23184.0
2018-03-19 07:25:00	AAPL	Stock	44.05	44.05	43.9775	43.9775	22272.0
2018-03-19 07:30:00	AAPL	Stock	44.005	44.0375	44.0	44.0	13220.0
2018-03-19 07:35:00	AAPL	Stock	44.01	44.015	44.0025	44.0125	9472.0
2018-03-19 07:40:00	AAPL	Stock	44.05	44.15	44.01	44.15	41804.0
2018-03-19 07:45:00	AAPL	Stock	44.16	44.175	44.13	44.1625	6448.0
2018-03-19 07:50:00	AAPL	Stock	44.1575	44.1625	44.1275	44.1275	11400.0
2018-03-19 07:55:00	AAPL	Stock	44.1375	44.215	44.1325	44.175	22120.0
2018-03-19 08:00:00	AAPL	Stock	44.005	44.275	43.96	44.25	121740.0
2018-03-19 08:05:00	AAPL	Stock	44.25	44.3575	44.25	44.35	110120.0
2018-03-19 08:10:00	AAPL	Stock	44.35	44.36	44.3075	44.36	31680.0
2018-03-19 08:15:00	AAPL	Stock	44.32	44.32	44.295	44.3	23880.0
2018-03-19 08:20:00	AAPL	Stock	44.3	44.33	44.2925	44.2925	24904.0
2018-03-19 08:25:00	AAPL	Stock	44.3	44.325	44.295	44.3125	11880.0
2018-03-19 08:30:00	AAPL	Stock	44.3225	44.3225	44.2925	44.2925	14600.0
2018-03-19 08:35:00	AAPL	Stock	44.3	44.3	44.28	44.2875	10000.0
2018-03-19 08:40:00	AAPL	Stock	44.2875	44.3	44.2525	44.2775	35668.0
2018-03-19 08:45:00	AAPL	Stock	44.2775	44.2975	44.2775	44.2875	4508.0
2018-03-19 08:50:00	AAPL	Stock	44.295	44.33	44.295	44.33	32900.0
2018-03-19 08:55:00	AAPL	Stock	44.33	44.33	44.2875	44.3075	48384.0
2018-03-19 09:00:00	AAPL	Stock	44.305	44.3125	44.2575	44.27	16500.0
2018-03-19 09:05:00	AAPL	Stock	44.2575	44.2675	44.2025	44.2125	61420.0
2018-03-19 09:10:00	AAPL	Stock	44.215	44.2725	44.2125	44.2675	26836.0
2018-03-19 09:15:00	AAPL	Stock	44.2725	44.3325	44.2725	44.3325	13312.0
2018-03-19 09:20:00	AAPL	Stock	44.33	44.3625	44.2925	44.2925	63092.0
2018-03-19 09:25:00	AAPL	Stock	44.3	44.34	44.3	44.305	20576.0
2018-03-19 09:30:00	AAPL	Stock	44.3425	44.3675	44.11	44.214	4610596.0
2018-03-19 09:35:00	AAPL	Stock	44.21	44.2575	44.0725	44.165	2185940.0
2018-03-19 09:40:00	AAPL	Stock	44.163	44.1775	44.0925	44.1347	1590520.0
2018-03-19 09:45:00	AAPL	Stock	44.13	44.195	44.1	44.19	1798940.0
2018-03-19 09:50:00	AAPL	Stock	44.192	44.273	44.1875	44.2425	1474188.0

> showing 50 of 362,707 rows — these rows as CSV

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