PREVIEW / stock_30min / 2020-03-05

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-05.parquet
  size:    1.8 MB
  rows:    89,414
  symbols: 2,432

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-03-05 04:00:00	AAPL	Stock	74.215	74.495	74.0	74.18	59368.0
2020-03-05 04:30:00	AAPL	Stock	74.1275	74.3975	74.1125	74.2575	20276.0
2020-03-05 05:00:00	AAPL	Stock	74.255	74.255	73.8575	73.95	73672.0
2020-03-05 05:30:00	AAPL	Stock	74.0075	74.0825	73.8375	73.8375	29776.0
2020-03-05 06:00:00	AAPL	Stock	73.875	74.1725	73.8	73.8025	49536.0
2020-03-05 06:30:00	AAPL	Stock	73.875	73.9625	73.7425	73.9025	73868.0
2020-03-05 07:00:00	AAPL	Stock	73.985	74.3475	73.8625	74.2875	348988.0
2020-03-05 07:30:00	AAPL	Stock	74.3125	74.35	74.05	74.1275	380000.0
2020-03-05 08:00:00	AAPL	Stock	74.2	74.35	73.6875	73.72	818980.0
2020-03-05 08:30:00	AAPL	Stock	73.72	73.975	73.625	73.95	372564.0
2020-03-05 09:00:00	AAPL	Stock	73.905	73.935	73.525	73.88	705172.0
2020-03-05 09:30:00	AAPL	Stock	73.88	74.3575	73.595	73.865	20220184.0
2020-03-05 10:00:00	AAPL	Stock	73.855	74.68	73.575	74.4275	13532128.0
2020-03-05 10:30:00	AAPL	Stock	74.4373	74.81	74.2125	74.42	9949984.0
2020-03-05 11:00:00	AAPL	Stock	74.42	74.8875	74.2125	74.745	9376036.0
2020-03-05 11:30:00	AAPL	Stock	74.7275	74.8375	74.2375	74.3525	6772484.0
2020-03-05 12:00:00	AAPL	Stock	74.3475	74.445	74.065	74.19	6931500.0
2020-03-05 12:30:00	AAPL	Stock	74.1875	74.3375	73.305	73.55	10824520.0
2020-03-05 13:00:00	AAPL	Stock	73.5462	73.95	73.345	73.925	8211088.0
2020-03-05 13:30:00	AAPL	Stock	73.925	74.2125	73.73	74.01	8228988.0
2020-03-05 14:00:00	AAPL	Stock	74.0025	74.0025	73.445	73.5325	6417400.0
2020-03-05 14:30:00	AAPL	Stock	73.5375	73.95	73.5275	73.615	6917612.0
2020-03-05 15:00:00	AAPL	Stock	73.6125	73.7425	72.955	73.1125	11588132.0
2020-03-05 15:30:00	AAPL	Stock	73.1175	73.725	72.8525	73.23	20975448.0
2020-03-05 16:00:00	AAPL	Stock	73.23	73.2725	73.0375	73.2	14784224.0
2020-03-05 16:30:00	AAPL	Stock	73.18	73.2375	73.0875	73.2175	157852.0
2020-03-05 17:00:00	AAPL	Stock	73.2175	73.245	73.1275	73.245	46384.0
2020-03-05 17:30:00	AAPL	Stock	73.225	73.2432	73.1375	73.21	39684.0
2020-03-05 18:00:00	AAPL	Stock	73.1875	73.3875	73.09	73.3875	141468.0
2020-03-05 18:30:00	AAPL	Stock	73.3425	73.4125	73.2775	73.3525	70024.0
2020-03-05 19:00:00	AAPL	Stock	73.3625	73.6	73.3175	73.4975	164704.0
2020-03-05 19:30:00	AAPL	Stock	73.5	73.5	73.2	73.2375	102904.0
2020-03-05 04:00:00	MSFT	Stock	167.99	167.99	166.9	166.9	7990.0
2020-03-05 04:30:00	MSFT	Stock	166.91	167.68	166.9	167.14	6603.0
2020-03-05 05:00:00	MSFT	Stock	167.14	167.14	166.15	166.26	6683.0
2020-03-05 05:30:00	MSFT	Stock	166.32	166.75	165.87	166.0	4481.0
2020-03-05 06:00:00	MSFT	Stock	166.2	167.0	166.01	166.01	11687.0
2020-03-05 06:30:00	MSFT	Stock	166.0	166.7	165.8	166.66	5272.0
2020-03-05 07:00:00	MSFT	Stock	166.7	166.9	166.06	166.75	34849.0
2020-03-05 07:30:00	MSFT	Stock	166.9	166.94	166.15	166.15	36974.0
2020-03-05 08:00:00	MSFT	Stock	166.45	167.0	165.75	165.99	110489.0
2020-03-05 08:30:00	MSFT	Stock	166.0	166.5	165.85	166.35	34719.0
2020-03-05 09:00:00	MSFT	Stock	166.2	168.87	165.1	165.94	93005.0
2020-03-05 09:30:00	MSFT	Stock	166.02	167.82	165.694	167.1	4829540.0
2020-03-05 10:00:00	MSFT	Stock	167.09	168.9	166.43	168.345	2500293.0
2020-03-05 10:30:00	MSFT	Stock	168.355	169.67	168.32	169.064	2241170.0
2020-03-05 11:00:00	MSFT	Stock	169.07	170.87	168.78	170.3	2704770.0
2020-03-05 11:30:00	MSFT	Stock	170.32	170.41	167.945	168.36	1926726.0
2020-03-05 12:00:00	MSFT	Stock	168.37	168.78	166.88	167.31	1927686.0
2020-03-05 12:30:00	MSFT	Stock	167.3	167.91	166.13	166.8	2097244.0

> showing 50 of 89,414 rows — these rows as CSV

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