PREVIEW / stock_30min / 2019-08-02

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-02.parquet
  size:    1.7 MB
  rows:    83,464
  symbols: 2,561

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-08-02 04:00:00	AAPL	Stock	51.55	51.55	51.4275	51.5	20840.0
2019-08-02 04:30:00	AAPL	Stock	51.405	51.4925	51.3775	51.4425	17496.0
2019-08-02 05:00:00	AAPL	Stock	51.385	51.3925	51.3725	51.3825	5428.0
2019-08-02 05:30:00	AAPL	Stock	51.4075	51.4125	51.3875	51.4	6052.0
2019-08-02 06:00:00	AAPL	Stock	51.3875	51.5875	51.3875	51.5	23540.0
2019-08-02 06:30:00	AAPL	Stock	51.5	51.66	51.45	51.66	25096.0
2019-08-02 07:00:00	AAPL	Stock	51.5875	51.6375	51.5025	51.615	127344.0
2019-08-02 07:30:00	AAPL	Stock	51.6025	51.66	51.5125	51.53	99232.0
2019-08-02 08:00:00	AAPL	Stock	51.5275	52.1075	51.5075	51.61	396868.0
2019-08-02 08:30:00	AAPL	Stock	51.6025	51.6125	51.37	51.57	440960.0
2019-08-02 09:00:00	AAPL	Stock	51.5875	51.9475	51.25	51.3	937096.0
2019-08-02 09:30:00	AAPL	Stock	51.2875	51.6075	50.9425	51.2375	24143752.0
2019-08-02 10:00:00	AAPL	Stock	51.235	51.37	50.89	50.9782	12934092.0
2019-08-02 10:30:00	AAPL	Stock	50.9775	50.9775	50.4075	50.481	14835988.0
2019-08-02 11:00:00	AAPL	Stock	50.4825	50.925	50.425	50.7375	10024428.0
2019-08-02 11:30:00	AAPL	Stock	50.7375	50.8525	50.605	50.7975	6543316.0
2019-08-02 12:00:00	AAPL	Stock	50.795	51.155	50.7152	51.085	8210984.0
2019-08-02 12:30:00	AAPL	Stock	51.0775	51.11	50.8625	50.8912	6490676.0
2019-08-02 13:00:00	AAPL	Stock	50.895	50.9175	50.76	50.8225	4665084.0
2019-08-02 13:30:00	AAPL	Stock	50.8237	50.9138	50.6775	50.8825	4373772.0
2019-08-02 14:00:00	AAPL	Stock	50.885	51.12	50.8025	51.0175	5596740.0
2019-08-02 14:30:00	AAPL	Stock	51.02	51.095	50.915	50.9825	4016944.0
2019-08-02 15:00:00	AAPL	Stock	50.9875	51.08	50.745	51.0325	5826256.0
2019-08-02 15:30:00	AAPL	Stock	51.0325	51.1875	50.8025	51.0225	14710900.0
2019-08-02 16:00:00	AAPL	Stock	51.0225	51.0975	50.94	51.0375	7958716.0
2019-08-02 16:30:00	AAPL	Stock	51.06	51.0825	51.005	51.0625	53828.0
2019-08-02 17:00:00	AAPL	Stock	51.0825	51.0825	51.06	51.06	59316.0
2019-08-02 17:30:00	AAPL	Stock	51.06	51.07	51.0125	51.05	17172.0
2019-08-02 18:00:00	AAPL	Stock	51.0625	51.0725	51.0425	51.0425	4156.0
2019-08-02 18:30:00	AAPL	Stock	51.0425	51.075	51.0425	51.06	5364.0
2019-08-02 19:00:00	AAPL	Stock	51.05	51.0525	51.04	51.04	6376.0
2019-08-02 19:30:00	AAPL	Stock	51.04	51.125	51.0375	51.125	65440.0
2019-08-02 04:00:00	MSFT	Stock	137.16	137.16	136.89	137.07	800.0
2019-08-02 04:30:00	MSFT	Stock	136.83	136.83	136.8	136.8	600.0
2019-08-02 05:00:00	MSFT	Stock	136.97	136.97	136.77	136.77	400.0
2019-08-02 05:30:00	MSFT	Stock	136.81	136.81	136.7	136.7	853.0
2019-08-02 06:00:00	MSFT	Stock	137.12	137.3	137.12	137.3	1928.0
2019-08-02 06:30:00	MSFT	Stock	137.3	137.3	137.3	137.3	100.0
2019-08-02 07:00:00	MSFT	Stock	137.34	137.4	137.2	137.3	2799.0
2019-08-02 07:30:00	MSFT	Stock	137.21	137.43	137.2	137.25	8562.0
2019-08-02 08:00:00	MSFT	Stock	137.243	137.52	137.11	137.3	13088.0
2019-08-02 08:30:00	MSFT	Stock	137.27	138.06	136.79	137.38	26605.0
2019-08-02 09:00:00	MSFT	Stock	137.37	138.07	137.17	138.07	41166.0
2019-08-02 09:30:00	MSFT	Stock	138.06	138.4	136.59	136.79	3381310.0
2019-08-02 10:00:00	MSFT	Stock	136.82	137.11	136.03	136.329	2471116.0
2019-08-02 10:30:00	MSFT	Stock	136.31	136.31	135.53	135.54	1936607.0
2019-08-02 11:00:00	MSFT	Stock	135.54	136.18	135.49	135.89	1934740.0
2019-08-02 11:30:00	MSFT	Stock	135.89	136.035	135.51	135.909	1408917.0
2019-08-02 12:00:00	MSFT	Stock	135.9	136.416	135.75	136.39	1310224.0
2019-08-02 12:30:00	MSFT	Stock	136.38	136.405	135.75	135.8	1102081.0

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

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