PREVIEW / stock_30min / 2019-03-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-12.parquet
  size:    1.7 MB
  rows:    83,998
  symbols: 2,645

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-03-12 04:00:00	AAPL	Stock	45.0	45.0	44.9075	44.945	17632.0
2019-03-12 04:30:00	AAPL	Stock	44.9625	44.975	44.9125	44.9125	13884.0
2019-03-12 05:00:00	AAPL	Stock	44.955	44.955	44.9425	44.9425	12512.0
2019-03-12 05:30:00	AAPL	Stock	44.9425	44.9425	44.9425	44.9425	400.0
2019-03-12 06:00:00	AAPL	Stock	44.8875	44.8875	44.85	44.88	22952.0
2019-03-12 06:30:00	AAPL	Stock	44.88	44.88	44.85	44.85	5520.0
2019-03-12 07:00:00	AAPL	Stock	44.855	44.915	44.7575	44.7875	77932.0
2019-03-12 07:30:00	AAPL	Stock	44.82	44.8675	44.8	44.845	22924.0
2019-03-12 08:00:00	AAPL	Stock	44.9002	44.925	44.7625	44.9175	123392.0
2019-03-12 08:30:00	AAPL	Stock	44.9225	45.02	44.915	44.9825	407288.0
2019-03-12 09:00:00	AAPL	Stock	44.98	45.0025	44.865	45.0025	469800.0
2019-03-12 09:30:00	AAPL	Stock	44.9825	45.2992	44.8425	45.21	19635316.0
2019-03-12 10:00:00	AAPL	Stock	45.21	45.45	45.1605	45.435	10620216.0
2019-03-12 10:30:00	AAPL	Stock	45.435	45.6675	45.4175	45.6	11028180.0
2019-03-12 11:00:00	AAPL	Stock	45.5985	45.625	45.47	45.5	10258896.0
2019-03-12 11:30:00	AAPL	Stock	45.4988	45.5215	45.3475	45.4475	8008836.0
2019-03-12 12:00:00	AAPL	Stock	45.45	45.46	45.3075	45.412	4894912.0
2019-03-12 12:30:00	AAPL	Stock	45.4075	45.434	45.1538	45.1875	5739444.0
2019-03-12 13:00:00	AAPL	Stock	45.1862	45.2875	45.17	45.2518	3842844.0
2019-03-12 13:30:00	AAPL	Stock	45.25	45.3455	45.21	45.295	3647144.0
2019-03-12 14:00:00	AAPL	Stock	45.2962	45.315	45.1525	45.1675	4127728.0
2019-03-12 14:30:00	AAPL	Stock	45.165	45.235	45.1625	45.2318	3583952.0
2019-03-12 15:00:00	AAPL	Stock	45.2325	45.2325	45.0525	45.105	5114636.0
2019-03-12 15:30:00	AAPL	Stock	45.105	45.25	45.085	45.235	8963624.0
2019-03-12 16:00:00	AAPL	Stock	45.2275	45.245	45.18	45.215	16514892.0
2019-03-12 16:30:00	AAPL	Stock	45.215	45.25	45.2125	45.2475	41000.0
2019-03-12 17:00:00	AAPL	Stock	45.25	45.2575	45.1925	45.2025	31616.0
2019-03-12 17:30:00	AAPL	Stock	45.2	45.2415	45.2	45.2415	13704.0
2019-03-12 18:00:00	AAPL	Stock	45.25	45.325	45.2025	45.3125	83420.0
2019-03-12 18:30:00	AAPL	Stock	45.275	45.2925	45.2625	45.27	37588.0
2019-03-12 19:00:00	AAPL	Stock	45.285	45.285	45.22	45.25	26456.0
2019-03-12 19:30:00	AAPL	Stock	45.2225	45.25	45.2075	45.2475	21852.0
2019-03-12 04:00:00	MSFT	Stock	113.19	113.19	113.19	113.19	200.0
2019-03-12 04:30:00	MSFT	Stock	113.0	113.0	113.0	113.0	3000.0
2019-03-12 05:30:00	MSFT	Stock	113.09	113.4	113.09	113.4	2029.0
2019-03-12 06:00:00	MSFT	Stock	113.07	113.07	113.0	113.0	1867.0
2019-03-12 06:30:00	MSFT	Stock	113.0	113.0	112.83	112.87	1101.0
2019-03-12 07:00:00	MSFT	Stock	112.96	113.0	112.75	112.75	5362.0
2019-03-12 07:30:00	MSFT	Stock	112.8	112.95	112.8	112.9	8800.0
2019-03-12 08:00:00	MSFT	Stock	113.0	113.0	112.88	112.97	2021.0
2019-03-12 08:30:00	MSFT	Stock	112.81	113.3	112.81	113.15	11649.0
2019-03-12 09:00:00	MSFT	Stock	113.15	113.189	113.0	113.0	7861.0
2019-03-12 09:30:00	MSFT	Stock	112.82	113.105	112.65	112.993	2112382.0
2019-03-12 10:00:00	MSFT	Stock	113.0	113.37	112.805	113.33	1779998.0
2019-03-12 10:30:00	MSFT	Stock	113.33	113.885	113.32	113.82	2065848.0
2019-03-12 11:00:00	MSFT	Stock	113.8	113.81	113.455	113.66	1422173.0
2019-03-12 11:30:00	MSFT	Stock	113.67	113.97	113.62	113.955	1526319.0
2019-03-12 12:00:00	MSFT	Stock	113.96	113.98	113.69	113.84	1231955.0
2019-03-12 12:30:00	MSFT	Stock	113.85	113.99	113.78	113.952	780007.0
2019-03-12 13:00:00	MSFT	Stock	113.95	113.97	113.7	113.71	883188.0

> showing 50 of 83,998 rows — these rows as CSV

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