PREVIEW / stock_5min / 2019-04-17

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-04-17.parquet
  size:    5.7 MB
  rows:    358,422
  symbols: 2,634

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-04-17 04:00:00	AAPL	Stock	49.725	49.725	49.6725	49.7	14000.0
2019-04-17 04:10:00	AAPL	Stock	49.695	49.725	49.6925	49.725	12600.0
2019-04-17 04:50:00	AAPL	Stock	49.745	49.745	49.745	49.745	400.0
2019-04-17 05:00:00	AAPL	Stock	49.75	49.75	49.75	49.75	3836.0
2019-04-17 05:35:00	AAPL	Stock	49.775	49.775	49.775	49.775	3812.0
2019-04-17 05:45:00	AAPL	Stock	49.78	49.78	49.78	49.78	800.0
2019-04-17 05:50:00	AAPL	Stock	49.78	49.78	49.78	49.78	800.0
2019-04-17 05:55:00	AAPL	Stock	49.795	49.825	49.795	49.825	7936.0
2019-04-17 06:00:00	AAPL	Stock	49.85	49.875	49.85	49.87	12848.0
2019-04-17 06:15:00	AAPL	Stock	49.8775	49.8775	49.8775	49.8775	3608.0
2019-04-17 06:20:00	AAPL	Stock	49.8575	49.8575	49.8575	49.8575	400.0
2019-04-17 06:30:00	AAPL	Stock	49.85	49.85	49.85	49.85	2000.0
2019-04-17 06:35:00	AAPL	Stock	49.8325	49.8325	49.8125	49.8125	2148.0
2019-04-17 06:55:00	AAPL	Stock	49.8725	49.8725	49.8725	49.8725	2000.0
2019-04-17 07:00:00	AAPL	Stock	49.8175	49.875	49.8125	49.8675	7652.0
2019-04-17 07:05:00	AAPL	Stock	49.8275	49.855	49.8275	49.855	4944.0
2019-04-17 07:10:00	AAPL	Stock	49.8375	49.8825	49.8375	49.875	14260.0
2019-04-17 07:15:00	AAPL	Stock	49.9	49.9175	49.87	49.9175	20660.0
2019-04-17 07:20:00	AAPL	Stock	49.925	49.925	49.9175	49.9175	7072.0
2019-04-17 07:25:00	AAPL	Stock	49.9175	50.0	49.9175	49.9475	38104.0
2019-04-17 07:30:00	AAPL	Stock	49.975	50.01	49.975	50.0	12120.0
2019-04-17 07:35:00	AAPL	Stock	50.0	50.0025	49.9625	50.0	18400.0
2019-04-17 07:40:00	AAPL	Stock	49.9625	49.9875	49.9625	49.985	8228.0
2019-04-17 07:45:00	AAPL	Stock	49.985	49.985	49.985	49.985	1696.0
2019-04-17 07:50:00	AAPL	Stock	50.0	50.0	49.9675	49.9675	8468.0
2019-04-17 07:55:00	AAPL	Stock	49.9675	49.9675	49.8925	49.8925	8816.0
2019-04-17 08:00:00	AAPL	Stock	49.86	50.025	49.8175	49.9775	69424.0
2019-04-17 08:05:00	AAPL	Stock	49.97	49.995	49.965	49.995	12916.0
2019-04-17 08:10:00	AAPL	Stock	49.99	50.04	49.99	50.0	27788.0
2019-04-17 08:15:00	AAPL	Stock	50.005	50.005	49.9825	50.0	22644.0
2019-04-17 08:20:00	AAPL	Stock	49.995	50.0	49.9625	49.9875	9416.0
2019-04-17 08:25:00	AAPL	Stock	49.97	49.9875	49.9375	49.9525	23800.0
2019-04-17 08:30:00	AAPL	Stock	49.9525	49.9725	49.9425	49.9425	14660.0
2019-04-17 08:35:00	AAPL	Stock	49.9675	49.97	49.9425	49.9425	6432.0
2019-04-17 08:40:00	AAPL	Stock	49.9425	49.9575	49.9	49.9575	28204.0
2019-04-17 08:45:00	AAPL	Stock	49.95	49.9875	49.95	49.97	57252.0
2019-04-17 08:50:00	AAPL	Stock	49.97	50.0275	49.97	50.0275	43416.0
2019-04-17 08:55:00	AAPL	Stock	50.005	50.0475	50.0025	50.025	10332.0
2019-04-17 09:00:00	AAPL	Stock	50.0025	50.025	50.0	50.025	14568.0
2019-04-17 09:05:00	AAPL	Stock	50.025	50.15	50.0225	50.15	120816.0
2019-04-17 09:10:00	AAPL	Stock	50.175	50.2125	50.1	50.105	58980.0
2019-04-17 09:15:00	AAPL	Stock	50.118	50.125	50.065	50.1	33860.0
2019-04-17 09:20:00	AAPL	Stock	50.1125	50.16	50.1125	50.125	34996.0
2019-04-17 09:25:00	AAPL	Stock	50.125	50.125	49.815	49.895	299508.0
2019-04-17 09:30:00	AAPL	Stock	49.895	50.085	49.6525	50.055	8529456.0
2019-04-17 09:35:00	AAPL	Stock	50.055	50.12	50.01	50.0425	2097248.0
2019-04-17 09:40:00	AAPL	Stock	50.04	50.2275	50.03	50.1725	3208696.0
2019-04-17 09:45:00	AAPL	Stock	50.1725	50.3075	50.1725	50.245	3257144.0
2019-04-17 09:50:00	AAPL	Stock	50.245	50.325	50.16	50.1725	2149784.0
2019-04-17 09:55:00	AAPL	Stock	50.1775	50.1825	49.9675	49.99	2379404.0

> showing 50 of 358,422 rows — these rows as CSV

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