PREVIEW / stock_30min / 2019-07-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-24.parquet
  size:    1.7 MB
  rows:    84,647
  symbols: 2,591

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-24 04:00:00	AAPL	Stock	51.95	51.95	51.85	51.85	1200.0
2019-07-24 04:30:00	AAPL	Stock	51.85	51.85	51.7475	51.755	4796.0
2019-07-24 05:00:00	AAPL	Stock	51.8225	51.885	51.77	51.8375	10332.0
2019-07-24 05:30:00	AAPL	Stock	51.8675	51.8675	51.77	51.77	17120.0
2019-07-24 06:00:00	AAPL	Stock	51.83	51.83	51.8075	51.8075	5600.0
2019-07-24 06:30:00	AAPL	Stock	51.875	51.9875	51.875	51.93	4252.0
2019-07-24 07:00:00	AAPL	Stock	51.945	52.035	51.9	52.035	54552.0
2019-07-24 07:30:00	AAPL	Stock	51.9875	52.025	51.95	51.9625	26064.0
2019-07-24 08:00:00	AAPL	Stock	51.8925	52.03	51.8925	52.0	213892.0
2019-07-24 08:30:00	AAPL	Stock	51.98	52.02	51.9125	51.9375	41044.0
2019-07-24 09:00:00	AAPL	Stock	51.93	52.21	51.845	51.9175	220548.0
2019-07-24 09:30:00	AAPL	Stock	51.9175	52.2875	51.9175	52.175	8174712.0
2019-07-24 10:00:00	AAPL	Stock	52.1725	52.2675	52.1175	52.195	4295172.0
2019-07-24 10:30:00	AAPL	Stock	52.1975	52.265	51.945	51.98	3982452.0
2019-07-24 11:00:00	AAPL	Stock	51.9775	52.0025	51.8925	51.976	3250140.0
2019-07-24 11:30:00	AAPL	Stock	51.9818	52.045	51.935	51.9525	2492492.0
2019-07-24 12:00:00	AAPL	Stock	51.95	52.02	51.9412	51.965	1709432.0
2019-07-24 12:30:00	AAPL	Stock	51.9662	52.055	51.966	52.0425	2056084.0
2019-07-24 13:00:00	AAPL	Stock	52.0462	52.049	51.95	51.955	1438476.0
2019-07-24 13:30:00	AAPL	Stock	51.9575	51.9625	51.8205	51.85	2298904.0
2019-07-24 14:00:00	AAPL	Stock	51.8515	51.8825	51.7925	51.8438	2330108.0
2019-07-24 14:30:00	AAPL	Stock	51.8462	52.02	51.8462	52.0175	2724276.0
2019-07-24 15:00:00	AAPL	Stock	52.015	52.155	51.9912	52.13	3255332.0
2019-07-24 15:30:00	AAPL	Stock	52.1325	52.1875	52.0478	52.1675	5704588.0
2019-07-24 16:00:00	AAPL	Stock	52.1675	52.28	52.0798	52.125	5691568.0
2019-07-24 16:30:00	AAPL	Stock	52.15	52.21	52.1125	52.115	51692.0
2019-07-24 17:00:00	AAPL	Stock	52.105	52.175	52.07	52.1375	76148.0
2019-07-24 17:30:00	AAPL	Stock	52.115	52.25	52.115	52.2025	67908.0
2019-07-24 18:00:00	AAPL	Stock	52.2025	52.2475	52.2025	52.2475	19824.0
2019-07-24 18:30:00	AAPL	Stock	52.2475	52.2475	52.205	52.205	16492.0
2019-07-24 19:00:00	AAPL	Stock	52.23	52.2475	52.23	52.23	8472.0
2019-07-24 19:30:00	AAPL	Stock	52.2425	52.2525	52.215	52.2475	19868.0
2019-07-24 04:00:00	MSFT	Stock	139.0	139.0	139.0	139.0	110.0
2019-07-24 04:30:00	MSFT	Stock	138.9	138.9	138.77	138.9	2400.0
2019-07-24 05:00:00	MSFT	Stock	138.89	139.15	138.88	139.09	1708.0
2019-07-24 05:30:00	MSFT	Stock	138.94	138.94	138.75	138.8	4847.0
2019-07-24 06:00:00	MSFT	Stock	138.88	138.9	138.85	138.9	948.0
2019-07-24 07:00:00	MSFT	Stock	138.96	139.0	138.82	139.0	4939.0
2019-07-24 07:30:00	MSFT	Stock	138.86	138.97	138.85	138.95	3728.0
2019-07-24 08:00:00	MSFT	Stock	138.89	139.15	138.82	139.015	11238.0
2019-07-24 08:30:00	MSFT	Stock	139.13	139.16	138.9	138.96	11387.0
2019-07-24 09:00:00	MSFT	Stock	138.9	139.29	138.87	138.87	51935.0
2019-07-24 09:30:00	MSFT	Stock	138.88	139.91	138.85	139.76	2322990.0
2019-07-24 10:00:00	MSFT	Stock	139.76	139.783	139.46	139.65	1065216.0
2019-07-24 10:30:00	MSFT	Stock	139.65	139.86	139.585	139.695	1116929.0
2019-07-24 11:00:00	MSFT	Stock	139.69	139.71	139.53	139.675	570833.0
2019-07-24 11:30:00	MSFT	Stock	139.675	139.88	139.66	139.81	587257.0
2019-07-24 12:00:00	MSFT	Stock	139.821	140.09	139.79	140.02	1233027.0
2019-07-24 12:30:00	MSFT	Stock	140.02	140.185	139.985	140.126	629624.0
2019-07-24 13:00:00	MSFT	Stock	140.13	140.148	140.01	140.06	557539.0

> showing 50 of 84,647 rows — these rows as CSV

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