PREVIEW / stock_30min / 2019-07-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-23.parquet
  size:    1.7 MB
  rows:    83,486
  symbols: 2,576

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-07-23 04:00:00	AAPL	Stock	52.0	52.0	51.875	51.935	14660.0
2019-07-23 04:30:00	AAPL	Stock	51.9625	51.9625	51.885	51.9075	19904.0
2019-07-23 05:00:00	AAPL	Stock	51.9075	51.93	51.8875	51.93	4816.0
2019-07-23 06:00:00	AAPL	Stock	51.975	52.0325	51.975	52.0325	9000.0
2019-07-23 06:30:00	AAPL	Stock	52.0475	52.0475	51.975	51.975	6880.0
2019-07-23 07:00:00	AAPL	Stock	52.0	52.025	51.96	51.9825	91036.0
2019-07-23 07:30:00	AAPL	Stock	51.9925	52.0625	51.975	52.015	75484.0
2019-07-23 08:00:00	AAPL	Stock	52.0	52.0975	51.6775	52.0875	234788.0
2019-07-23 08:30:00	AAPL	Stock	52.0825	52.17	52.0775	52.0918	172580.0
2019-07-23 09:00:00	AAPL	Stock	52.09	52.1375	52.075	52.12	175596.0
2019-07-23 09:30:00	AAPL	Stock	52.0925	52.1975	51.8575	51.96	11036948.0
2019-07-23 10:00:00	AAPL	Stock	51.96	52.12	51.885	52.0395	5948948.0
2019-07-23 10:30:00	AAPL	Stock	52.04	52.0975	51.9825	52.03	3221608.0
2019-07-23 11:00:00	AAPL	Stock	52.03	52.065	51.925	52.0432	2876900.0
2019-07-23 11:30:00	AAPL	Stock	52.0425	52.055	51.8225	51.9025	3667940.0
2019-07-23 12:00:00	AAPL	Stock	51.9068	51.95	51.8425	51.895	2468544.0
2019-07-23 12:30:00	AAPL	Stock	51.895	51.97	51.86	51.93	1839824.0
2019-07-23 13:00:00	AAPL	Stock	51.93	51.935	51.855	51.8798	1606680.0
2019-07-23 13:30:00	AAPL	Stock	51.88	52.0875	51.875	52.0575	3847272.0
2019-07-23 14:00:00	AAPL	Stock	52.06	52.1025	51.996	52.0355	2961816.0
2019-07-23 14:30:00	AAPL	Stock	52.0408	52.1175	52.0	52.1138	2644892.0
2019-07-23 15:00:00	AAPL	Stock	52.115	52.1625	52.065	52.147	2741288.0
2019-07-23 15:30:00	AAPL	Stock	52.1462	52.2275	52.1062	52.2062	5687708.0
2019-07-23 16:00:00	AAPL	Stock	52.21	52.2925	52.0442	52.21	3905468.0
2019-07-23 16:30:00	AAPL	Stock	52.25	52.2525	51.69	51.8625	404604.0
2019-07-23 17:00:00	AAPL	Stock	51.8625	51.9925	51.825	51.955	156008.0
2019-07-23 17:30:00	AAPL	Stock	51.95	52.0625	51.925	52.0	74136.0
2019-07-23 18:00:00	AAPL	Stock	52.0025	52.025	51.965	51.965	24024.0
2019-07-23 18:30:00	AAPL	Stock	51.955	52.0375	51.9525	52.0	32200.0
2019-07-23 19:00:00	AAPL	Stock	52.0	52.0	51.95	51.9825	14792.0
2019-07-23 19:30:00	AAPL	Stock	51.9675	51.9825	51.925	51.9825	29928.0
2019-07-23 04:00:00	MSFT	Stock	138.47	138.95	138.47	138.95	562.0
2019-07-23 04:30:00	MSFT	Stock	139.0	139.0	139.0	139.0	236.0
2019-07-23 05:30:00	MSFT	Stock	138.99	139.0	138.99	139.0	893.0
2019-07-23 06:00:00	MSFT	Stock	139.02	139.25	139.02	139.25	1978.0
2019-07-23 07:00:00	MSFT	Stock	139.04	139.25	138.95	139.17	8193.0
2019-07-23 07:30:00	MSFT	Stock	139.08	139.1	139.0	139.0	4254.0
2019-07-23 08:00:00	MSFT	Stock	139.108	139.2	138.77	139.11	42173.0
2019-07-23 08:30:00	MSFT	Stock	139.15	139.22	138.95	139.0	30807.0
2019-07-23 09:00:00	MSFT	Stock	138.9	140.12	138.81	139.77	95298.0
2019-07-23 09:30:00	MSFT	Stock	139.77	139.99	138.15	138.26	2930664.0
2019-07-23 10:00:00	MSFT	Stock	138.255	138.6	138.03	138.32	1382326.0
2019-07-23 10:30:00	MSFT	Stock	138.328	138.97	138.29	138.85	881328.0
2019-07-23 11:00:00	MSFT	Stock	138.85	138.94	138.58	138.765	741923.0
2019-07-23 11:30:00	MSFT	Stock	138.765	138.83	138.46	138.56	716916.0
2019-07-23 12:00:00	MSFT	Stock	138.555	138.57	138.2	138.3	727506.0
2019-07-23 12:30:00	MSFT	Stock	138.29	138.605	138.22	138.56	475373.0
2019-07-23 13:00:00	MSFT	Stock	138.575	138.745	138.5	138.625	512584.0
2019-07-23 13:30:00	MSFT	Stock	138.62	139.13	138.59	139.075	1138826.0
2019-07-23 14:00:00	MSFT	Stock	139.08	139.135	138.83	138.876	556692.0

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

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