PREVIEW / stock_30min / 2020-07-22

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-22.parquet
  size:    1.9 MB
  rows:    98,108
  symbols: 2,440

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
2020-07-22 04:00:00	AAPL	Stock	96.7525	96.7525	96.4025	96.64	27956.0
2020-07-22 04:30:00	AAPL	Stock	96.65	96.6575	96.4	96.55	48812.0
2020-07-22 05:00:00	AAPL	Stock	96.5475	96.745	96.425	96.745	33608.0
2020-07-22 05:30:00	AAPL	Stock	96.725	97.0	96.725	96.995	8972.0
2020-07-22 06:00:00	AAPL	Stock	96.975	97.415	96.975	97.26	4980.0
2020-07-22 06:30:00	AAPL	Stock	97.26	97.345	97.16	97.345	30332.0
2020-07-22 07:00:00	AAPL	Stock	97.4225	97.4425	97.2525	97.3875	76732.0
2020-07-22 07:30:00	AAPL	Stock	97.3975	97.43	97.25	97.25	44864.0
2020-07-22 08:00:00	AAPL	Stock	97.3	97.4835	97.18	97.2173	243580.0
2020-07-22 08:30:00	AAPL	Stock	97.2175	97.2875	97.083	97.18	120476.0
2020-07-22 09:00:00	AAPL	Stock	97.1725	97.25	96.66	96.69	1120176.0
2020-07-22 09:30:00	AAPL	Stock	96.6675	97.8075	96.6675	97.6575	11953256.0
2020-07-22 10:00:00	AAPL	Stock	97.675	97.975	97.325	97.365	7176948.0
2020-07-22 10:30:00	AAPL	Stock	97.3575	97.51	96.8925	97.1075	6662712.0
2020-07-22 11:00:00	AAPL	Stock	97.1	97.255	96.77	97.2385	4802104.0
2020-07-22 11:30:00	AAPL	Stock	97.2675	97.345	97.075	97.095	3053384.0
2020-07-22 12:00:00	AAPL	Stock	97.1025	97.2725	96.96	97.095	2669240.0
2020-07-22 12:30:00	AAPL	Stock	97.1025	97.1525	96.845	97.0112	2274884.0
2020-07-22 13:00:00	AAPL	Stock	96.9975	97.12	96.86	96.8955	2617408.0
2020-07-22 13:30:00	AAPL	Stock	96.8975	96.9475	96.6025	96.655	3083316.0
2020-07-22 14:00:00	AAPL	Stock	96.66	96.9125	96.6435	96.835	2616636.0
2020-07-22 14:30:00	AAPL	Stock	96.83	97.0	96.71	96.79	2626520.0
2020-07-22 15:00:00	AAPL	Stock	96.8	97.22	96.79	96.86	3336700.0
2020-07-22 15:30:00	AAPL	Stock	96.8675	97.4625	96.8525	97.2725	6272804.0
2020-07-22 16:00:00	AAPL	Stock	97.2725	97.3125	96.875	96.9975	6991236.0
2020-07-22 16:30:00	AAPL	Stock	96.9925	97.2725	96.925	97.1375	131296.0
2020-07-22 17:00:00	AAPL	Stock	97.1875	97.205	97.05	97.05	34512.0
2020-07-22 17:30:00	AAPL	Stock	97.08	97.2725	97.06	97.065	432968.0
2020-07-22 18:00:00	AAPL	Stock	97.1	97.25	97.1	97.2	30768.0
2020-07-22 18:30:00	AAPL	Stock	97.215	97.215	97.1325	97.1875	4872.0
2020-07-22 19:00:00	AAPL	Stock	97.145	97.15	97.0	97.0325	15756.0
2020-07-22 19:30:00	AAPL	Stock	97.0375	97.125	97.0	97.075	53092.0
2020-07-22 04:00:00	MSFT	Stock	210.0	210.0	208.8	209.64	7476.0
2020-07-22 04:30:00	MSFT	Stock	209.5	209.5	208.6	209.05	2489.0
2020-07-22 05:00:00	MSFT	Stock	209.2	209.39	208.93	209.39	1282.0
2020-07-22 05:30:00	MSFT	Stock	209.21	210.3	209.21	210.02	3916.0
2020-07-22 06:00:00	MSFT	Stock	210.02	210.66	210.0	210.66	9524.0
2020-07-22 06:30:00	MSFT	Stock	210.65	210.8	210.25	210.66	7607.0
2020-07-22 07:00:00	MSFT	Stock	210.64	211.27	210.45	211.1	37281.0
2020-07-22 07:30:00	MSFT	Stock	211.11	211.19	210.55	210.55	27634.0
2020-07-22 08:00:00	MSFT	Stock	211.0	211.3	210.151	210.21	97942.0
2020-07-22 08:30:00	MSFT	Stock	210.39	210.39	209.62	209.929	95421.0
2020-07-22 09:00:00	MSFT	Stock	209.97	210.11	208.708	209.14	490250.0
2020-07-22 09:30:00	MSFT	Stock	209.13	211.335	209.1	210.41	4259744.0
2020-07-22 10:00:00	MSFT	Stock	210.425	211.63	210.23	210.315	2220298.0
2020-07-22 10:30:00	MSFT	Stock	210.31	210.58	208.39	209.47	2345651.0
2020-07-22 11:00:00	MSFT	Stock	209.44	210.51	209.04	210.27	2048165.0
2020-07-22 11:30:00	MSFT	Stock	210.28	210.74	210.12	210.5	1582638.0
2020-07-22 12:00:00	MSFT	Stock	210.5	211.75	210.23	211.15	2588817.0
2020-07-22 12:30:00	MSFT	Stock	211.14	211.26	210.61	210.95	1348237.0

> showing 50 of 98,108 rows — these rows as CSV

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