PREVIEW / stock_5min / 2017-01-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-18.parquet
  size:    5.3 MB
  rows:    348,729
  symbols: 3,127

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-01-18 04:05:00	AAPL	Stock	30.0	30.0	30.0	30.0	1200.0
2017-01-18 04:10:00	AAPL	Stock	30.0	30.0	30.0	30.0	1432.0
2017-01-18 05:40:00	AAPL	Stock	30.0	30.0325	30.0	30.0325	1876.0
2017-01-18 05:45:00	AAPL	Stock	30.0325	30.0325	30.0325	30.0325	1600.0
2017-01-18 06:20:00	AAPL	Stock	29.9775	29.9775	29.975	29.975	4052.0
2017-01-18 06:25:00	AAPL	Stock	30.0475	30.05	30.0475	30.05	3664.0
2017-01-18 06:30:00	AAPL	Stock	30.0475	30.0475	30.025	30.025	8000.0
2017-01-18 06:35:00	AAPL	Stock	30.025	30.025	30.025	30.025	3600.0
2017-01-18 06:45:00	AAPL	Stock	30.025	30.025	30.025	30.025	2400.0
2017-01-18 06:50:00	AAPL	Stock	30.0025	30.0025	30.0025	30.0025	800.0
2017-01-18 07:00:00	AAPL	Stock	30.0025	30.0025	30.0	30.0	10400.0
2017-01-18 07:05:00	AAPL	Stock	30.0	30.0	29.98	29.9825	7248.0
2017-01-18 07:15:00	AAPL	Stock	30.025	30.025	30.025	30.025	400.0
2017-01-18 07:20:00	AAPL	Stock	29.9825	29.99	29.975	29.975	10800.0
2017-01-18 07:55:00	AAPL	Stock	29.9975	30.015	29.9975	30.015	4984.0
2017-01-18 08:00:00	AAPL	Stock	30.0175	30.02	29.9975	30.02	16764.0
2017-01-18 08:05:00	AAPL	Stock	30.0025	30.0125	30.0	30.0125	11924.0
2017-01-18 08:10:00	AAPL	Stock	30.02	30.03	30.0025	30.005	10340.0
2017-01-18 08:15:00	AAPL	Stock	30.02	30.02	30.02	30.02	2000.0
2017-01-18 08:20:00	AAPL	Stock	30.03	30.03	30.0	30.0	11148.0
2017-01-18 08:25:00	AAPL	Stock	30.025	30.025	30.025	30.025	1740.0
2017-01-18 08:30:00	AAPL	Stock	30.0375	30.0375	30.0125	30.025	15200.0
2017-01-18 08:35:00	AAPL	Stock	30.025	30.035	30.025	30.035	7200.0
2017-01-18 08:40:00	AAPL	Stock	30.0375	30.0375	30.025	30.0375	6400.0
2017-01-18 08:45:00	AAPL	Stock	30.0375	30.04	30.0325	30.0325	10600.0
2017-01-18 08:50:00	AAPL	Stock	30.0275	30.03	30.025	30.025	23940.0
2017-01-18 08:55:00	AAPL	Stock	30.03	30.04	30.025	30.0275	41976.0
2017-01-18 09:00:00	AAPL	Stock	30.0325	30.0325	30.0125	30.0125	36492.0
2017-01-18 09:05:00	AAPL	Stock	30.025	30.025	30.0075	30.0125	6900.0
2017-01-18 09:10:00	AAPL	Stock	30.0125	30.0225	30.0125	30.02	16996.0
2017-01-18 09:15:00	AAPL	Stock	30.02	30.0325	30.02	30.02	6360.0
2017-01-18 09:20:00	AAPL	Stock	30.02	30.02	30.0025	30.0175	70104.0
2017-01-18 09:25:00	AAPL	Stock	30.02	30.02	30.0	30.005	41564.0
2017-01-18 09:30:00	AAPL	Stock	30.0	30.125	29.9925	30.0825	6041432.0
2017-01-18 09:35:00	AAPL	Stock	30.085	30.09	30.0	30.0625	2714872.0
2017-01-18 09:40:00	AAPL	Stock	30.0625	30.08	30.0125	30.04	2366848.0
2017-01-18 09:45:00	AAPL	Stock	30.0425	30.055	30.0	30.0375	1781760.0
2017-01-18 09:50:00	AAPL	Stock	30.0375	30.0425	30.0	30.005	1784176.0
2017-01-18 09:55:00	AAPL	Stock	30.01	30.065	29.9988	30.06	1693136.0
2017-01-18 10:00:00	AAPL	Stock	30.0625	30.065	30.0078	30.0225	1008904.0
2017-01-18 10:05:00	AAPL	Stock	30.0225	30.0312	29.9375	29.9388	2098632.0
2017-01-18 10:10:00	AAPL	Stock	29.9375	30.0188	29.9275	30.0	1372012.0
2017-01-18 10:15:00	AAPL	Stock	30.0025	30.0062	29.96	29.9825	1381888.0
2017-01-18 10:20:00	AAPL	Stock	29.9825	30.005	29.9775	29.9938	758492.0
2017-01-18 10:25:00	AAPL	Stock	29.9925	29.9925	29.9625	29.9775	811220.0
2017-01-18 10:30:00	AAPL	Stock	29.975	30.035	29.97	30.0262	1081228.0
2017-01-18 10:35:00	AAPL	Stock	30.0262	30.0275	29.9975	30.01	591224.0
2017-01-18 10:40:00	AAPL	Stock	30.0108	30.015	29.9738	29.98	961108.0
2017-01-18 10:45:00	AAPL	Stock	29.9775	29.9948	29.97	29.9938	885152.0
2017-01-18 10:50:00	AAPL	Stock	29.9925	29.9925	29.97	29.9825	758920.0

> showing 50 of 348,729 rows — these rows as CSV

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