PREVIEW / stock_30min / 2018-07-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-02.parquet
  size:    1.7 MB
  rows:    83,497
  symbols: 2,796

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
2018-07-02 04:00:00	AAPL	Stock	45.9675	46.0	45.9675	45.9975	4000.0
2018-07-02 05:00:00	AAPL	Stock	46.0025	46.0025	46.0025	46.0025	1600.0
2018-07-02 05:30:00	AAPL	Stock	46.0025	46.0125	46.0025	46.0125	1080.0
2018-07-02 06:00:00	AAPL	Stock	45.975	46.0	45.975	45.9875	10796.0
2018-07-02 06:30:00	AAPL	Stock	45.9775	46.0	45.9775	46.0	2000.0
2018-07-02 07:00:00	AAPL	Stock	46.065	46.07	45.9275	46.05	44944.0
2018-07-02 07:30:00	AAPL	Stock	46.0125	46.0625	46.0075	46.05	12040.0
2018-07-02 08:00:00	AAPL	Stock	45.97	46.1125	45.97	46.025	75272.0
2018-07-02 08:30:00	AAPL	Stock	46.0	46.2775	45.9625	45.975	57496.0
2018-07-02 09:00:00	AAPL	Stock	45.9675	46.0125	45.9125	45.9725	105472.0
2018-07-02 09:30:00	AAPL	Stock	45.9675	46.5625	45.855	46.53	10782604.0
2018-07-02 10:00:00	AAPL	Stock	46.53	46.5875	46.4125	46.5825	6075972.0
2018-07-02 10:30:00	AAPL	Stock	46.5862	46.6725	46.5425	46.6425	4217260.0
2018-07-02 11:00:00	AAPL	Stock	46.6425	46.7375	46.5662	46.575	3685480.0
2018-07-02 11:30:00	AAPL	Stock	46.575	46.575	46.4275	46.495	3036900.0
2018-07-02 12:00:00	AAPL	Stock	46.4925	46.5162	46.405	46.4875	2139804.0
2018-07-02 12:30:00	AAPL	Stock	46.4875	46.4875	46.3902	46.4525	1928684.0
2018-07-02 13:00:00	AAPL	Stock	46.4515	46.485	46.32	46.36	2032556.0
2018-07-02 13:30:00	AAPL	Stock	46.3575	46.6275	46.34	46.6062	2131804.0
2018-07-02 14:00:00	AAPL	Stock	46.6075	46.73	46.6075	46.7192	3611028.0
2018-07-02 14:30:00	AAPL	Stock	46.7175	46.76	46.5875	46.5988	3543884.0
2018-07-02 15:00:00	AAPL	Stock	46.6025	46.725	46.58	46.7175	3024984.0
2018-07-02 15:30:00	AAPL	Stock	46.7175	46.825	46.6875	46.7875	7696832.0
2018-07-02 16:00:00	AAPL	Stock	46.795	46.795	46.5595	46.7725	7080452.0
2018-07-02 16:30:00	AAPL	Stock	46.78	46.795	46.77	46.795	83096.0
2018-07-02 17:00:00	AAPL	Stock	46.77	46.8	46.765	46.8	30468.0
2018-07-02 17:30:00	AAPL	Stock	46.7625	46.795	46.7625	46.795	2000.0
2018-07-02 18:00:00	AAPL	Stock	46.7775	46.825	46.7775	46.795	50732.0
2018-07-02 18:30:00	AAPL	Stock	46.7875	46.8	46.7875	46.8	3832.0
2018-07-02 19:00:00	AAPL	Stock	46.8	46.8	46.7775	46.78	8864.0
2018-07-02 19:30:00	AAPL	Stock	46.7975	46.8125	46.7975	46.8125	1528.0
2018-07-02 04:00:00	MSFT	Stock	98.06	98.06	97.9	97.9	1494.0
2018-07-02 04:30:00	MSFT	Stock	98.12	98.12	98.12	98.12	200.0
2018-07-02 05:00:00	MSFT	Stock	97.93	97.93	97.93	97.93	1000.0
2018-07-02 05:30:00	MSFT	Stock	98.0	98.0	98.0	98.0	500.0
2018-07-02 06:00:00	MSFT	Stock	98.11	98.23	98.0	98.0	4812.0
2018-07-02 06:30:00	MSFT	Stock	98.15	98.17	98.15	98.16	1794.0
2018-07-02 07:00:00	MSFT	Stock	98.25	98.5	98.15	98.4	3324.0
2018-07-02 07:30:00	MSFT	Stock	98.32	98.32	98.2	98.32	924.0
2018-07-02 08:00:00	MSFT	Stock	98.32	98.6	98.13	98.17	13393.0
2018-07-02 08:30:00	MSFT	Stock	98.29	98.61	98.08	98.24	19262.0
2018-07-02 09:00:00	MSFT	Stock	98.61	98.61	97.94	98.09	28614.0
2018-07-02 09:30:00	MSFT	Stock	98.1	98.65	98.0	98.6	2529069.0
2018-07-02 10:00:00	MSFT	Stock	98.57	98.915	98.46	98.91	1178409.0
2018-07-02 10:30:00	MSFT	Stock	98.91	99.06	98.85	98.95	1287418.0
2018-07-02 11:00:00	MSFT	Stock	98.95	99.31	98.91	99.04	1026353.0
2018-07-02 11:30:00	MSFT	Stock	99.04	99.04	98.715	98.84	656631.0
2018-07-02 12:00:00	MSFT	Stock	98.84	99.015	98.76	98.98	585567.0
2018-07-02 12:30:00	MSFT	Stock	98.98	99.065	98.87	99.02	492289.0
2018-07-02 13:00:00	MSFT	Stock	99.02	99.065	98.74	98.91	603273.0

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

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