PREVIEW / stock_5min / 2020-01-10

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-01-10.parquet
  size:    6.0 MB
  rows:    369,361
  symbols: 2,470

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
2020-01-10 04:00:00	AAPL	Stock	77.805	77.9475	77.805	77.9475	14392.0
2020-01-10 04:05:00	AAPL	Stock	77.875	77.9	77.875	77.875	5164.0
2020-01-10 04:20:00	AAPL	Stock	77.9	77.9	77.8875	77.8875	3520.0
2020-01-10 04:25:00	AAPL	Stock	77.845	77.9425	77.845	77.9425	3020.0
2020-01-10 04:30:00	AAPL	Stock	77.9125	77.9325	77.9125	77.9325	1236.0
2020-01-10 04:35:00	AAPL	Stock	77.9625	77.975	77.9625	77.975	7412.0
2020-01-10 04:45:00	AAPL	Stock	77.95	77.955	77.95	77.95	2420.0
2020-01-10 04:50:00	AAPL	Stock	77.9375	77.9375	77.9375	77.9375	2000.0
2020-01-10 04:55:00	AAPL	Stock	77.97	77.97	77.97	77.97	400.0
2020-01-10 05:00:00	AAPL	Stock	77.975	77.975	77.97	77.975	6692.0
2020-01-10 05:05:00	AAPL	Stock	77.95	77.95	77.94	77.94	2976.0
2020-01-10 05:10:00	AAPL	Stock	77.9225	77.95	77.9225	77.95	2544.0
2020-01-10 05:20:00	AAPL	Stock	77.9525	77.9925	77.9525	77.9925	5232.0
2020-01-10 05:25:00	AAPL	Stock	77.985	77.985	77.975	77.975	7616.0
2020-01-10 05:30:00	AAPL	Stock	77.9525	77.9525	77.95	77.95	1000.0
2020-01-10 05:35:00	AAPL	Stock	77.9675	77.9675	77.9675	77.9675	2800.0
2020-01-10 05:40:00	AAPL	Stock	77.96	77.96	77.96	77.96	1600.0
2020-01-10 06:05:00	AAPL	Stock	77.9425	77.96	77.9425	77.96	9700.0
2020-01-10 06:10:00	AAPL	Stock	77.8925	77.8925	77.8825	77.8825	9796.0
2020-01-10 06:15:00	AAPL	Stock	77.9175	77.9175	77.9175	77.9175	400.0
2020-01-10 06:20:00	AAPL	Stock	77.925	77.925	77.925	77.925	2000.0
2020-01-10 06:25:00	AAPL	Stock	77.9475	77.96	77.9475	77.96	2000.0
2020-01-10 06:35:00	AAPL	Stock	77.9075	77.9075	77.875	77.875	18336.0
2020-01-10 06:40:00	AAPL	Stock	77.875	77.9	77.8725	77.9	6420.0
2020-01-10 06:45:00	AAPL	Stock	77.9075	77.9075	77.9075	77.9075	400.0
2020-01-10 06:50:00	AAPL	Stock	77.9075	77.9075	77.9075	77.9075	5200.0
2020-01-10 06:55:00	AAPL	Stock	77.8875	77.8875	77.8875	77.8875	400.0
2020-01-10 07:00:00	AAPL	Stock	77.925	78.0125	77.78	77.925	242596.0
2020-01-10 07:05:00	AAPL	Stock	77.92	77.9475	77.895	77.9075	37884.0
2020-01-10 07:10:00	AAPL	Stock	77.93	77.95	77.915	77.95	18916.0
2020-01-10 07:15:00	AAPL	Stock	77.9275	77.9775	77.925	77.9625	19928.0
2020-01-10 07:20:00	AAPL	Stock	77.925	77.97	77.925	77.9375	27144.0
2020-01-10 07:25:00	AAPL	Stock	77.935	77.975	77.935	77.9525	21748.0
2020-01-10 07:30:00	AAPL	Stock	77.975	77.995	77.9525	77.9775	43564.0
2020-01-10 07:35:00	AAPL	Stock	77.9775	78.03	77.9775	78.02	35976.0
2020-01-10 07:40:00	AAPL	Stock	78.02	78.06	78.0025	78.06	31352.0
2020-01-10 07:45:00	AAPL	Stock	78.045	78.0875	78.035	78.075	37552.0
2020-01-10 07:50:00	AAPL	Stock	78.0875	78.0875	78.0125	78.025	51948.0
2020-01-10 07:55:00	AAPL	Stock	78.0225	78.0475	78.0225	78.0475	32208.0
2020-01-10 08:00:00	AAPL	Stock	78.045	78.085	77.8875	78.005	206408.0
2020-01-10 08:05:00	AAPL	Stock	78.005	78.0225	77.955	77.955	97432.0
2020-01-10 08:10:00	AAPL	Stock	77.9675	77.98	77.9175	77.925	83116.0
2020-01-10 08:15:00	AAPL	Stock	77.925	77.975	77.91	77.94	66132.0
2020-01-10 08:20:00	AAPL	Stock	77.935	77.9725	77.81	77.8375	128504.0
2020-01-10 08:25:00	AAPL	Stock	77.8475	77.895	77.8125	77.875	101440.0
2020-01-10 08:30:00	AAPL	Stock	77.875	77.9375	77.7975	77.915	159724.0
2020-01-10 08:35:00	AAPL	Stock	77.915	77.915	77.6875	77.7125	248500.0
2020-01-10 08:40:00	AAPL	Stock	77.6875	77.715	77.605	77.61	128412.0
2020-01-10 08:45:00	AAPL	Stock	77.625	77.75	77.625	77.75	99928.0
2020-01-10 08:50:00	AAPL	Stock	77.7375	77.81	77.71	77.795	89200.0

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

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