PREVIEW / stock_30min / 2019-02-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-05.parquet
  size:    1.7 MB
  rows:    83,971
  symbols: 2,686

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-02-05 04:00:00	AAPL	Stock	42.825	42.9375	42.825	42.895	47136.0
2019-02-05 04:30:00	AAPL	Stock	42.8525	42.9	42.8525	42.895	32208.0
2019-02-05 05:00:00	AAPL	Stock	42.9	42.93	42.895	42.93	21964.0
2019-02-05 05:30:00	AAPL	Stock	42.9	42.98	42.9	42.98	6480.0
2019-02-05 06:00:00	AAPL	Stock	42.975	43.105	42.975	43.105	10972.0
2019-02-05 06:30:00	AAPL	Stock	43.0725	43.0725	43.0075	43.0275	13620.0
2019-02-05 07:00:00	AAPL	Stock	43.0025	43.095	43.0	43.0525	107656.0
2019-02-05 07:30:00	AAPL	Stock	43.0625	43.1325	43.0125	43.0875	139508.0
2019-02-05 08:00:00	AAPL	Stock	43.095	43.2425	43.0	43.0625	324572.0
2019-02-05 08:30:00	AAPL	Stock	43.0425	43.225	43.03	43.2025	265212.0
2019-02-05 09:00:00	AAPL	Stock	43.2	43.2375	43.155	43.215	276280.0
2019-02-05 09:30:00	AAPL	Stock	43.215	43.62	43.0875	43.5513	22484176.0
2019-02-05 10:00:00	AAPL	Stock	43.553	43.575	43.4	43.4475	11791156.0
2019-02-05 10:30:00	AAPL	Stock	43.445	43.75	43.445	43.7032	10208252.0
2019-02-05 11:00:00	AAPL	Stock	43.705	43.77	43.5575	43.6015	8297280.0
2019-02-05 11:30:00	AAPL	Stock	43.601	43.66	43.5037	43.6028	7961320.0
2019-02-05 12:00:00	AAPL	Stock	43.6075	43.61	43.4475	43.4785	5612292.0
2019-02-05 12:30:00	AAPL	Stock	43.4775	43.5025	43.2525	43.2912	7122452.0
2019-02-05 13:00:00	AAPL	Stock	43.2925	43.3225	43.1725	43.31	7341800.0
2019-02-05 13:30:00	AAPL	Stock	43.31	43.4725	43.3025	43.4492	5530252.0
2019-02-05 14:00:00	AAPL	Stock	43.45	43.61	43.4462	43.5285	6315528.0
2019-02-05 14:30:00	AAPL	Stock	43.5325	43.595	43.46	43.5525	5485112.0
2019-02-05 15:00:00	AAPL	Stock	43.5582	43.62	43.4925	43.6165	5512484.0
2019-02-05 15:30:00	AAPL	Stock	43.6175	43.6175	43.4375	43.525	13203348.0
2019-02-05 16:00:00	AAPL	Stock	43.545	43.555	43.49	43.5025	11602400.0
2019-02-05 16:30:00	AAPL	Stock	43.5125	43.545	43.4725	43.4775	176324.0
2019-02-05 17:00:00	AAPL	Stock	43.5225	43.53	43.5	43.525	20456.0
2019-02-05 17:30:00	AAPL	Stock	43.5125	43.525	43.49	43.525	34496.0
2019-02-05 18:00:00	AAPL	Stock	43.5	43.525	43.49	43.5125	28416.0
2019-02-05 18:30:00	AAPL	Stock	43.5225	43.525	43.5125	43.525	7964.0
2019-02-05 19:00:00	AAPL	Stock	43.5175	43.5375	43.505	43.5375	17312.0
2019-02-05 19:30:00	AAPL	Stock	43.5425	43.5725	43.5375	43.5375	70640.0
2019-02-05 04:30:00	MSFT	Stock	105.52	105.52	105.52	105.52	101.0
2019-02-05 05:00:00	MSFT	Stock	105.69	105.7	105.69	105.7	297.0
2019-02-05 06:00:00	MSFT	Stock	105.75	105.75	105.75	105.75	203.0
2019-02-05 06:30:00	MSFT	Stock	105.83	105.85	105.83	105.85	647.0
2019-02-05 07:00:00	MSFT	Stock	105.91	106.12	105.88	106.0	6069.0
2019-02-05 07:30:00	MSFT	Stock	106.05	106.13	106.05	106.13	5381.0
2019-02-05 08:00:00	MSFT	Stock	106.127	106.15	105.85	105.91	14161.0
2019-02-05 08:30:00	MSFT	Stock	105.91	106.06	105.79	106.0	9816.0
2019-02-05 09:00:00	MSFT	Stock	106.0	106.15	105.92	106.15	13230.0
2019-02-05 09:30:00	MSFT	Stock	106.1	106.86	105.96	106.51	3230044.0
2019-02-05 10:00:00	MSFT	Stock	106.51	106.65	106.17	106.51	1293697.0
2019-02-05 10:30:00	MSFT	Stock	106.5	107.01	106.5	106.86	1715355.0
2019-02-05 11:00:00	MSFT	Stock	106.86	106.905	106.42	106.49	1496781.0
2019-02-05 11:30:00	MSFT	Stock	106.49	106.975	106.44	106.936	1000951.0
2019-02-05 12:00:00	MSFT	Stock	106.94	107.015	106.71	106.955	1341715.0
2019-02-05 12:30:00	MSFT	Stock	106.95	107.01	106.61	106.7	1362748.0
2019-02-05 13:00:00	MSFT	Stock	106.705	106.96	106.56	106.96	977059.0
2019-02-05 13:30:00	MSFT	Stock	106.96	107.03	106.85	106.97	911782.0

> showing 50 of 83,971 rows — these rows as CSV

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