PREVIEW / stock_30min / 2019-08-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-26.parquet
  size:    1.7 MB
  rows:    84,297
  symbols: 2,548

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-26 04:00:00	AAPL	Stock	51.025	51.47	51.025	51.4	118924.0
2019-08-26 04:30:00	AAPL	Stock	51.3575	51.71	51.3575	51.6375	36672.0
2019-08-26 05:00:00	AAPL	Stock	51.6375	51.65	51.4125	51.4275	38744.0
2019-08-26 05:30:00	AAPL	Stock	51.4125	51.7	51.04	51.25	97956.0
2019-08-26 06:00:00	AAPL	Stock	51.2475	51.7125	51.1875	51.5	91612.0
2019-08-26 06:30:00	AAPL	Stock	51.495	51.52	51.29	51.4775	40820.0
2019-08-26 07:00:00	AAPL	Stock	51.4075	51.6575	51.34	51.6	460216.0
2019-08-26 07:30:00	AAPL	Stock	51.62	51.7	51.4675	51.49	203496.0
2019-08-26 08:00:00	AAPL	Stock	51.5475	51.7	51.303	51.4375	562504.0
2019-08-26 08:30:00	AAPL	Stock	51.425	51.615	51.3725	51.6075	337128.0
2019-08-26 09:00:00	AAPL	Stock	51.57	51.6125	51.375	51.49	427336.0
2019-08-26 09:30:00	AAPL	Stock	51.4725	51.7975	51.3825	51.615	19088604.0
2019-08-26 10:00:00	AAPL	Stock	51.615	51.7125	51.2642	51.445	8586104.0
2019-08-26 10:30:00	AAPL	Stock	51.445	51.655	51.3472	51.545	7460904.0
2019-08-26 11:00:00	AAPL	Stock	51.5442	51.7	51.515	51.606	5249352.0
2019-08-26 11:30:00	AAPL	Stock	51.6025	51.655	51.4325	51.5127	3598256.0
2019-08-26 12:00:00	AAPL	Stock	51.5112	51.795	51.4725	51.705	4517124.0
2019-08-26 12:30:00	AAPL	Stock	51.7038	51.72	51.6275	51.685	3425964.0
2019-08-26 13:00:00	AAPL	Stock	51.68	51.7475	51.5475	51.57	3732544.0
2019-08-26 13:30:00	AAPL	Stock	51.57	51.5725	51.465	51.485	2511380.0
2019-08-26 14:00:00	AAPL	Stock	51.49	51.505	51.33	51.3925	3425300.0
2019-08-26 14:30:00	AAPL	Stock	51.39	51.4682	51.35	51.42	2752504.0
2019-08-26 15:00:00	AAPL	Stock	51.42	51.55	51.414	51.4382	4761284.0
2019-08-26 15:30:00	AAPL	Stock	51.44	51.65	51.295	51.65	9494160.0
2019-08-26 16:00:00	AAPL	Stock	51.6225	51.7125	51.6	51.6475	7442956.0
2019-08-26 16:30:00	AAPL	Stock	51.63	51.65	51.6225	51.6375	95688.0
2019-08-26 17:00:00	AAPL	Stock	51.6375	51.725	51.62	51.65	61440.0
2019-08-26 17:30:00	AAPL	Stock	51.65	51.6935	51.65	51.6875	29076.0
2019-08-26 18:00:00	AAPL	Stock	51.68	51.7125	51.6575	51.665	34592.0
2019-08-26 18:30:00	AAPL	Stock	51.67	51.6875	51.6275	51.6425	37104.0
2019-08-26 19:00:00	AAPL	Stock	51.6375	51.645	51.6	51.61	22324.0
2019-08-26 19:30:00	AAPL	Stock	51.625	51.625	51.55	51.575	17848.0
2019-08-26 04:00:00	MSFT	Stock	134.01	135.0	133.39	134.79	11309.0
2019-08-26 04:30:00	MSFT	Stock	134.89	135.45	134.89	135.42	5367.0
2019-08-26 05:00:00	MSFT	Stock	135.45	135.45	135.25	135.25	728.0
2019-08-26 05:30:00	MSFT	Stock	135.2	136.2	134.74	135.07	10094.0
2019-08-26 06:00:00	MSFT	Stock	135.15	135.57	135.15	135.57	1973.0
2019-08-26 06:30:00	MSFT	Stock	135.21	135.41	135.2	135.41	900.0
2019-08-26 07:00:00	MSFT	Stock	135.25	135.34	134.9	135.1	9386.0
2019-08-26 07:30:00	MSFT	Stock	135.1	135.38	134.85	134.9	20489.0
2019-08-26 08:00:00	MSFT	Stock	135.002	135.35	134.58	134.8	26178.0
2019-08-26 08:30:00	MSFT	Stock	134.989	135.3	134.9	135.25	29801.0
2019-08-26 09:00:00	MSFT	Stock	135.25	135.25	135.0	135.01	40292.0
2019-08-26 09:30:00	MSFT	Stock	135.01	135.28	134.15	134.76	2487890.0
2019-08-26 10:00:00	MSFT	Stock	134.76	134.94	133.9	134.568	1250597.0
2019-08-26 10:30:00	MSFT	Stock	134.565	134.85	134.06	134.635	1119914.0
2019-08-26 11:00:00	MSFT	Stock	134.64	135.1	134.49	135.01	1027307.0
2019-08-26 11:30:00	MSFT	Stock	134.99	135.16	134.73	134.98	810545.0
2019-08-26 12:00:00	MSFT	Stock	134.99	135.45	134.87	135.18	804731.0
2019-08-26 12:30:00	MSFT	Stock	135.2	135.3	135.058	135.179	545761.0

> showing 50 of 84,297 rows — these rows as CSV

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