PREVIEW / stock_30min / 2019-01-02

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-02.parquet
  size:    1.7 MB
  rows:    86,038
  symbols: 2,701

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-01-02 04:00:00	AAPL	Stock	38.6	38.67	38.2525	38.67	50132.0
2019-01-02 04:30:00	AAPL	Stock	38.625	38.675	38.515	38.675	32716.0
2019-01-02 05:00:00	AAPL	Stock	38.625	38.675	38.625	38.625	12232.0
2019-01-02 05:30:00	AAPL	Stock	38.6475	38.6475	38.5875	38.615	16732.0
2019-01-02 06:00:00	AAPL	Stock	38.645	38.645	38.5375	38.635	19540.0
2019-01-02 06:30:00	AAPL	Stock	38.6625	38.6625	38.525	38.615	44948.0
2019-01-02 07:00:00	AAPL	Stock	38.625	38.8375	38.625	38.775	135888.0
2019-01-02 07:30:00	AAPL	Stock	38.75	38.76	38.625	38.625	141116.0
2019-01-02 08:00:00	AAPL	Stock	38.75	39.435	38.6	39.435	312256.0
2019-01-02 08:30:00	AAPL	Stock	38.65	38.6725	38.6075	38.625	109560.0
2019-01-02 09:00:00	AAPL	Stock	38.645	38.765	38.645	38.7425	246848.0
2019-01-02 09:30:00	AAPL	Stock	38.7225	38.8875	38.5575	38.7975	16004172.0
2019-01-02 10:00:00	AAPL	Stock	38.7925	39.055	38.6425	38.9375	11614176.0
2019-01-02 10:30:00	AAPL	Stock	38.945	39.3	38.8575	39.22	9339712.0
2019-01-02 11:00:00	AAPL	Stock	39.22	39.6075	39.1825	39.4218	10391236.0
2019-01-02 11:30:00	AAPL	Stock	39.42	39.4675	39.2488	39.2575	6632584.0
2019-01-02 12:00:00	AAPL	Stock	39.2662	39.365	39.23	39.3425	4308772.0
2019-01-02 12:30:00	AAPL	Stock	39.34	39.5975	39.33	39.5425	5707912.0
2019-01-02 13:00:00	AAPL	Stock	39.5425	39.6525	39.5375	39.5855	5295720.0
2019-01-02 13:30:00	AAPL	Stock	39.5888	39.7125	39.5425	39.685	4740960.0
2019-01-02 14:00:00	AAPL	Stock	39.6825	39.6825	39.44	39.573	4974544.0
2019-01-02 14:30:00	AAPL	Stock	39.575	39.675	39.475	39.4802	3776608.0
2019-01-02 15:00:00	AAPL	Stock	39.4775	39.5075	39.2025	39.285	7984952.0
2019-01-02 15:30:00	AAPL	Stock	39.2825	39.4975	39.1825	39.48	10213680.0
2019-01-02 16:00:00	AAPL	Stock	39.48	39.4925	39.415	39.4675	12497712.0
2019-01-02 16:30:00	AAPL	Stock	37.5	39.3125	36.1275	36.5275	7677180.0
2019-01-02 17:00:00	AAPL	Stock	36.5275	36.925	36.5	36.6275	5830748.0
2019-01-02 17:30:00	AAPL	Stock	36.63	36.73	36.4575	36.535	2282252.0
2019-01-02 18:00:00	AAPL	Stock	36.535	36.67	36.475	36.5375	1094956.0
2019-01-02 18:30:00	AAPL	Stock	36.5375	36.5425	36.505	36.525	440212.0
2019-01-02 19:00:00	AAPL	Stock	36.525	36.6175	36.5	36.575	379952.0
2019-01-02 19:30:00	AAPL	Stock	36.575	36.585	36.48	36.5	499636.0
2019-01-02 04:00:00	MSFT	Stock	99.4	99.4	98.88	99.23	1080.0
2019-01-02 04:30:00	MSFT	Stock	99.35	99.35	99.2	99.2	2223.0
2019-01-02 05:00:00	MSFT	Stock	99.49	99.9	99.49	99.6	4168.0
2019-01-02 05:30:00	MSFT	Stock	99.5	99.5	99.4	99.4	746.0
2019-01-02 06:00:00	MSFT	Stock	99.41	99.5	99.04	99.38	9170.0
2019-01-02 06:30:00	MSFT	Stock	99.47	99.5	99.12	99.12	7922.0
2019-01-02 07:00:00	MSFT	Stock	99.38	99.65	99.01	99.63	58120.0
2019-01-02 07:30:00	MSFT	Stock	99.55	99.61	99.08	99.26	50538.0
2019-01-02 08:00:00	MSFT	Stock	99.43	99.62	99.0	99.14	58399.0
2019-01-02 08:30:00	MSFT	Stock	99.19	101.57	99.01	99.34	46352.0
2019-01-02 09:00:00	MSFT	Stock	99.28	99.55	99.23	99.55	81584.0
2019-01-02 09:30:00	MSFT	Stock	99.58	99.88	98.94	99.55	3828228.0
2019-01-02 10:00:00	MSFT	Stock	99.55	100.55	99.22	100.125	2993433.0
2019-01-02 10:30:00	MSFT	Stock	100.13	100.89	99.96	100.72	1830738.0
2019-01-02 11:00:00	MSFT	Stock	100.72	101.35	100.54	100.905	2260691.0
2019-01-02 11:30:00	MSFT	Stock	100.905	100.99	100.44	100.475	1779902.0
2019-01-02 12:00:00	MSFT	Stock	100.47	100.79	100.35	100.56	1340680.0
2019-01-02 12:30:00	MSFT	Stock	100.56	101.438	100.53	101.33	1177203.0

> showing 50 of 86,038 rows — these rows as CSV

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