PREVIEW / stock_30min / 2019-04-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-09.parquet
  size:    1.7 MB
  rows:    82,820
  symbols: 2,630

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-04-09 04:00:00	AAPL	Stock	50.025	50.025	49.9825	49.9925	7732.0
2019-04-09 04:30:00	AAPL	Stock	50.0725	50.075	50.0375	50.0375	3328.0
2019-04-09 05:00:00	AAPL	Stock	50.09	50.125	50.0775	50.0775	8748.0
2019-04-09 05:30:00	AAPL	Stock	50.095	50.1	50.095	50.1	8908.0
2019-04-09 06:00:00	AAPL	Stock	50.0975	50.1	50.075	50.075	5476.0
2019-04-09 06:30:00	AAPL	Stock	50.055	50.13	50.055	50.1075	18792.0
2019-04-09 07:00:00	AAPL	Stock	50.1225	50.2925	50.105	50.25	123236.0
2019-04-09 07:30:00	AAPL	Stock	50.25	50.3725	50.2025	50.3175	183196.0
2019-04-09 08:00:00	AAPL	Stock	50.12	50.3875	50.105	50.2	455488.0
2019-04-09 08:30:00	AAPL	Stock	50.2	50.275	50.17	50.1925	232392.0
2019-04-09 09:00:00	AAPL	Stock	50.1675	50.2125	50.065	50.0838	539940.0
2019-04-09 09:30:00	AAPL	Stock	50.085	50.4875	49.92	50.415	24393940.0
2019-04-09 10:00:00	AAPL	Stock	50.4175	50.6825	50.3675	50.655	16156416.0
2019-04-09 10:30:00	AAPL	Stock	50.655	50.7125	50.47	50.6075	9688184.0
2019-04-09 11:00:00	AAPL	Stock	50.6058	50.675	50.4275	50.48	5889604.0
2019-04-09 11:30:00	AAPL	Stock	50.4832	50.55	50.4425	50.4875	4928436.0
2019-04-09 12:00:00	AAPL	Stock	50.4825	50.5392	50.465	50.5037	3889856.0
2019-04-09 12:30:00	AAPL	Stock	50.5025	50.57	50.4025	50.41	3565512.0
2019-04-09 13:00:00	AAPL	Stock	50.41	50.415	50.02	50.05	9465920.0
2019-04-09 13:30:00	AAPL	Stock	50.0475	50.0525	49.88	50.0	8422068.0
2019-04-09 14:00:00	AAPL	Stock	50.0	50.0075	49.825	49.845	6834844.0
2019-04-09 14:30:00	AAPL	Stock	49.845	49.985	49.845	49.905	6506816.0
2019-04-09 15:00:00	AAPL	Stock	49.9075	49.9338	49.8075	49.865	4613012.0
2019-04-09 15:30:00	AAPL	Stock	49.8662	50.0	49.8125	49.875	11618584.0
2019-04-09 16:00:00	AAPL	Stock	49.875	49.92	49.805	49.8625	7224084.0
2019-04-09 16:30:00	AAPL	Stock	49.85	49.875	49.825	49.845	28040.0
2019-04-09 17:00:00	AAPL	Stock	49.825	49.8425	49.825	49.84	15872.0
2019-04-09 17:30:00	AAPL	Stock	49.845	49.845	49.8275	49.8375	27524.0
2019-04-09 18:00:00	AAPL	Stock	49.8375	49.8375	49.825	49.8275	16580.0
2019-04-09 18:30:00	AAPL	Stock	49.8275	49.835	49.825	49.835	25924.0
2019-04-09 19:00:00	AAPL	Stock	49.825	49.84	49.825	49.84	4532.0
2019-04-09 19:30:00	AAPL	Stock	49.83	49.835	49.775	49.775	20612.0
2019-04-09 04:00:00	MSFT	Stock	120.18	120.18	120.18	120.18	100.0
2019-04-09 04:30:00	MSFT	Stock	119.94	119.94	119.94	119.94	100.0
2019-04-09 05:00:00	MSFT	Stock	119.85	119.85	119.85	119.85	419.0
2019-04-09 06:00:00	MSFT	Stock	119.76	119.76	119.7	119.7	1030.0
2019-04-09 06:30:00	MSFT	Stock	119.71	119.84	119.7	119.84	875.0
2019-04-09 07:00:00	MSFT	Stock	119.74	119.74	119.5	119.5	11725.0
2019-04-09 07:30:00	MSFT	Stock	119.56	119.7	119.35	119.4	13370.0
2019-04-09 08:00:00	MSFT	Stock	119.4	119.4	119.05	119.08	17403.0
2019-04-09 08:30:00	MSFT	Stock	119.08	119.3	119.05	119.3	10430.0
2019-04-09 09:00:00	MSFT	Stock	119.141	119.3	118.61	118.85	19656.0
2019-04-09 09:30:00	MSFT	Stock	118.63	119.33	118.58	119.09	2429485.0
2019-04-09 10:00:00	MSFT	Stock	119.1	119.478	118.91	119.42	1244614.0
2019-04-09 10:30:00	MSFT	Stock	119.42	119.54	118.99	119.065	1161445.0
2019-04-09 11:00:00	MSFT	Stock	119.07	119.3	119.05	119.12	879694.0
2019-04-09 11:30:00	MSFT	Stock	119.12	119.22	119.02	119.15	860329.0
2019-04-09 12:00:00	MSFT	Stock	119.16	119.41	119.155	119.345	636226.0
2019-04-09 12:30:00	MSFT	Stock	119.35	119.38	119.17	119.175	415076.0
2019-04-09 13:00:00	MSFT	Stock	119.171	119.21	119.01	119.12	451008.0

> showing 50 of 82,820 rows — these rows as CSV

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