PREVIEW / stock_30min / 2019-12-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-05.parquet
  size:    1.7 MB
  rows:    85,544
  symbols: 2,478

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-12-05 04:00:00	AAPL	Stock	65.5525	65.625	65.5075	65.5825	17348.0
2019-12-05 04:30:00	AAPL	Stock	65.6125	65.665	65.6125	65.665	21392.0
2019-12-05 05:00:00	AAPL	Stock	65.67	65.67	65.6375	65.6375	9340.0
2019-12-05 05:30:00	AAPL	Stock	65.6875	65.825	65.6875	65.8075	33208.0
2019-12-05 06:00:00	AAPL	Stock	65.8	65.925	65.8	65.925	47444.0
2019-12-05 06:30:00	AAPL	Stock	65.9475	65.995	65.91	65.9275	46336.0
2019-12-05 07:00:00	AAPL	Stock	65.9275	65.975	65.8925	65.9	107700.0
2019-12-05 07:30:00	AAPL	Stock	65.88	65.895	65.85	65.8875	65128.0
2019-12-05 08:00:00	AAPL	Stock	65.975	65.975	65.735	65.9175	269504.0
2019-12-05 08:30:00	AAPL	Stock	65.915	65.975	65.85	65.855	170104.0
2019-12-05 09:00:00	AAPL	Stock	65.855	65.9475	65.435	65.9375	230212.0
2019-12-05 09:30:00	AAPL	Stock	65.9475	66.1875	65.7725	66.08	10159236.0
2019-12-05 10:00:00	AAPL	Stock	66.0725	66.0925	65.6825	65.8318	6307884.0
2019-12-05 10:30:00	AAPL	Stock	65.8325	65.9575	65.705	65.925	3882612.0
2019-12-05 11:00:00	AAPL	Stock	65.9238	66.0662	65.8775	66.0325	3188232.0
2019-12-05 11:30:00	AAPL	Stock	66.0275	66.115	65.935	66.0945	2893284.0
2019-12-05 12:00:00	AAPL	Stock	66.09	66.0958	65.975	66.0125	1910496.0
2019-12-05 12:30:00	AAPL	Stock	66.0125	66.0975	65.94	66.0775	2091828.0
2019-12-05 13:00:00	AAPL	Stock	66.0725	66.1625	66.05	66.155	1948972.0
2019-12-05 13:30:00	AAPL	Stock	66.1505	66.3238	66.1488	66.2375	3760896.0
2019-12-05 14:00:00	AAPL	Stock	66.2358	66.3525	66.1775	66.3252	2833344.0
2019-12-05 14:30:00	AAPL	Stock	66.325	66.395	66.0825	66.2475	3696696.0
2019-12-05 15:00:00	AAPL	Stock	66.2525	66.4125	66.2352	66.4062	3194672.0
2019-12-05 15:30:00	AAPL	Stock	66.4075	66.4725	66.3325	66.395	6519740.0
2019-12-05 16:00:00	AAPL	Stock	66.395	66.395	66.3375	66.35	8487384.0
2019-12-05 16:30:00	AAPL	Stock	66.35	66.395	66.345	66.3575	61232.0
2019-12-05 17:00:00	AAPL	Stock	66.36	66.395	66.3525	66.3875	29120.0
2019-12-05 17:30:00	AAPL	Stock	66.3998	66.415	66.3875	66.4	6868.0
2019-12-05 18:00:00	AAPL	Stock	66.3975	66.4375	66.3975	66.425	46548.0
2019-12-05 18:30:00	AAPL	Stock	66.425	66.425	66.4	66.4125	17984.0
2019-12-05 19:00:00	AAPL	Stock	66.425	66.4625	66.425	66.4375	76044.0
2019-12-05 19:30:00	AAPL	Stock	66.4475	66.5	66.4375	66.5	70360.0
2019-12-05 04:00:00	MSFT	Stock	150.18	150.18	150.08	150.08	898.0
2019-12-05 05:30:00	MSFT	Stock	150.5	150.65	150.5	150.65	5500.0
2019-12-05 06:00:00	MSFT	Stock	150.64	150.82	150.6	150.6	2129.0
2019-12-05 06:30:00	MSFT	Stock	150.6	150.6	150.6	150.6	664.0
2019-12-05 07:00:00	MSFT	Stock	150.52	150.6	150.05	150.39	27616.0
2019-12-05 07:30:00	MSFT	Stock	150.35	150.35	150.25	150.35	10446.0
2019-12-05 08:00:00	MSFT	Stock	150.4	150.456	150.05	150.4	17145.0
2019-12-05 08:30:00	MSFT	Stock	149.85	150.382	149.85	150.26	159965.0
2019-12-05 09:00:00	MSFT	Stock	150.26	150.3	149.85	150.07	29301.0
2019-12-05 09:30:00	MSFT	Stock	150.05	150.32	149.56	150.13	1547531.0
2019-12-05 10:00:00	MSFT	Stock	150.12	150.19	149.66	149.9	1301174.0
2019-12-05 10:30:00	MSFT	Stock	149.91	149.97	149.59	149.83	810786.0
2019-12-05 11:00:00	MSFT	Stock	149.83	150.04	149.635	149.95	902054.0
2019-12-05 11:30:00	MSFT	Stock	149.93	149.988	149.72	149.86	675774.0
2019-12-05 12:00:00	MSFT	Stock	149.85	149.99	149.83	149.88	394004.0
2019-12-05 12:30:00	MSFT	Stock	149.875	149.95	149.79	149.84	354343.0
2019-12-05 13:00:00	MSFT	Stock	149.83	149.96	149.75	149.764	463933.0
2019-12-05 13:30:00	MSFT	Stock	149.764	149.86	149.6	149.83	606705.0

> showing 50 of 85,544 rows — these rows as CSV

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