PREVIEW / stock_5min / 2019-09-17

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-09-17.parquet
  size:    5.7 MB
  rows:    361,333
  symbols: 2,546

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
2019-09-17 04:00:00	AAPL	Stock	54.975	54.975	54.975	54.975	400.0
2019-09-17 04:10:00	AAPL	Stock	54.975	54.975	54.975	54.975	400.0
2019-09-17 04:30:00	AAPL	Stock	54.9525	54.9525	54.9025	54.9025	2108.0
2019-09-17 04:40:00	AAPL	Stock	54.8625	54.8625	54.8625	54.8625	400.0
2019-09-17 04:45:00	AAPL	Stock	54.9075	54.9075	54.9075	54.9075	400.0
2019-09-17 05:00:00	AAPL	Stock	54.8975	54.8975	54.8975	54.8975	400.0
2019-09-17 05:05:00	AAPL	Stock	54.915	54.915	54.915	54.915	528.0
2019-09-17 05:15:00	AAPL	Stock	54.9325	54.9325	54.9325	54.9325	400.0
2019-09-17 05:20:00	AAPL	Stock	54.99	54.99	54.99	54.99	3840.0
2019-09-17 05:55:00	AAPL	Stock	54.85	54.85	54.85	54.85	2000.0
2019-09-17 06:00:00	AAPL	Stock	54.8375	54.8375	54.8275	54.8275	1200.0
2019-09-17 06:40:00	AAPL	Stock	54.825	54.825	54.825	54.825	712.0
2019-09-17 06:45:00	AAPL	Stock	54.8575	54.8575	54.8575	54.8575	400.0
2019-09-17 06:50:00	AAPL	Stock	54.8	54.8	54.8	54.8	400.0
2019-09-17 07:00:00	AAPL	Stock	54.845	54.8875	54.8375	54.8475	30236.0
2019-09-17 07:05:00	AAPL	Stock	54.8375	54.8375	54.8375	54.8375	400.0
2019-09-17 07:10:00	AAPL	Stock	54.845	54.845	54.825	54.825	3600.0
2019-09-17 07:20:00	AAPL	Stock	54.875	54.8925	54.875	54.8925	3280.0
2019-09-17 07:30:00	AAPL	Stock	54.9275	54.9275	54.9275	54.9275	3920.0
2019-09-17 07:35:00	AAPL	Stock	54.95	54.95	54.95	54.95	800.0
2019-09-17 07:40:00	AAPL	Stock	54.9725	55.0425	54.9725	55.0425	6400.0
2019-09-17 07:45:00	AAPL	Stock	55.0	55.0	55.0	55.0	3200.0
2019-09-17 07:50:00	AAPL	Stock	55.0325	55.0325	55.0025	55.0025	3224.0
2019-09-17 07:55:00	AAPL	Stock	55.0125	55.0125	55.0125	55.0125	1000.0
2019-09-17 08:00:00	AAPL	Stock	54.8495	55.045	54.8225	54.9825	145592.0
2019-09-17 08:05:00	AAPL	Stock	54.9825	55.025	54.92	54.925	15496.0
2019-09-17 08:10:00	AAPL	Stock	54.94	54.94	54.93	54.93	1200.0
2019-09-17 08:15:00	AAPL	Stock	54.975	54.975	54.955	54.9725	56500.0
2019-09-17 08:20:00	AAPL	Stock	54.965	54.965	54.955	54.955	2800.0
2019-09-17 08:25:00	AAPL	Stock	54.93	54.93	54.93	54.93	600.0
2019-09-17 08:30:00	AAPL	Stock	54.94	54.94	54.8875	54.8875	12220.0
2019-09-17 08:35:00	AAPL	Stock	54.8875	54.9125	54.8525	54.9125	21480.0
2019-09-17 08:40:00	AAPL	Stock	54.9125	54.9125	54.8875	54.9	6984.0
2019-09-17 08:45:00	AAPL	Stock	54.9225	54.9625	54.9225	54.9525	23000.0
2019-09-17 08:50:00	AAPL	Stock	54.9525	54.9625	54.9275	54.9275	2924.0
2019-09-17 08:55:00	AAPL	Stock	54.95	54.9975	54.95	54.9975	8252.0
2019-09-17 09:00:00	AAPL	Stock	54.995	55.02	54.96	54.9725	32768.0
2019-09-17 09:05:00	AAPL	Stock	54.99	54.99	54.93	54.9375	23672.0
2019-09-17 09:10:00	AAPL	Stock	54.95	54.96	54.925	54.96	24828.0
2019-09-17 09:15:00	AAPL	Stock	54.9475	54.995	54.945	54.995	10556.0
2019-09-17 09:20:00	AAPL	Stock	54.975	54.9925	54.94	54.95	10912.0
2019-09-17 09:25:00	AAPL	Stock	54.95	54.995	54.95	54.995	27268.0
2019-09-17 09:30:00	AAPL	Stock	54.9675	55.0125	54.7925	54.825	2394016.0
2019-09-17 09:35:00	AAPL	Stock	54.825	54.945	54.78	54.9448	1431192.0
2019-09-17 09:40:00	AAPL	Stock	54.9415	55.1475	54.9325	55.053	2228796.0
2019-09-17 09:45:00	AAPL	Stock	55.0575	55.0675	54.9225	55.045	1627980.0
2019-09-17 09:50:00	AAPL	Stock	55.0475	55.0712	54.8	54.855	1554760.0
2019-09-17 09:55:00	AAPL	Stock	54.86	54.915	54.8025	54.8525	1407648.0
2019-09-17 10:00:00	AAPL	Stock	54.8525	54.9125	54.8125	54.8725	1035436.0
2019-09-17 10:05:00	AAPL	Stock	54.87	54.905	54.8375	54.87	522672.0

> showing 50 of 361,333 rows — these rows as CSV

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