PREVIEW / stock_30min / 2020-03-25

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-25.parquet
  size:    1.9 MB
  rows:    96,797
  symbols: 2,448

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-25 04:00:00	AAPL	Stock	63.75	63.975	63.0075	63.975	161484.0
2020-03-25 04:30:00	AAPL	Stock	64.1075	64.375	63.75	64.25	62456.0
2020-03-25 05:00:00	AAPL	Stock	64.245	64.975	64.1775	64.975	50064.0
2020-03-25 05:30:00	AAPL	Stock	64.9	64.9725	64.02	64.1825	59856.0
2020-03-25 06:00:00	AAPL	Stock	64.2875	64.2875	63.0625	63.125	97804.0
2020-03-25 06:30:00	AAPL	Stock	63.075	63.1875	61.8275	61.8275	203660.0
2020-03-25 07:00:00	AAPL	Stock	62.0625	62.875	62.0	62.52	633996.0
2020-03-25 07:30:00	AAPL	Stock	62.575	62.6225	61.6375	62.1025	467580.0
2020-03-25 08:00:00	AAPL	Stock	62.4825	62.875	61.625	62.375	819412.0
2020-03-25 08:30:00	AAPL	Stock	62.375	62.845	62.3	62.75	726280.0
2020-03-25 09:00:00	AAPL	Stock	62.8325	62.925	62.45	62.72	1063480.0
2020-03-25 09:30:00	AAPL	Stock	62.7225	64.5625	62.4675	62.7175	40175748.0
2020-03-25 10:00:00	AAPL	Stock	62.6675	62.6775	61.075	61.9765	22248120.0
2020-03-25 10:30:00	AAPL	Stock	61.9725	62.6625	61.8375	62.61	13924832.0
2020-03-25 11:00:00	AAPL	Stock	62.6275	63.75	62.5975	63.46	18585116.0
2020-03-25 11:30:00	AAPL	Stock	63.47	63.6248	62.815	63.2975	10833704.0
2020-03-25 12:00:00	AAPL	Stock	63.32	63.9425	63.2575	63.6075	12484620.0
2020-03-25 12:30:00	AAPL	Stock	63.6025	63.82	63.35	63.4925	11887908.0
2020-03-25 13:00:00	AAPL	Stock	63.4978	63.95	63.445	63.7325	9983332.0
2020-03-25 13:30:00	AAPL	Stock	63.7375	64.325	63.6275	63.8375	12778516.0
2020-03-25 14:00:00	AAPL	Stock	63.8512	64.005	63.1702	63.7575	11123176.0
2020-03-25 14:30:00	AAPL	Stock	63.7575	63.91	63.35	63.73	9752900.0
2020-03-25 15:00:00	AAPL	Stock	63.7422	64.2875	63.6475	63.8275	13016376.0
2020-03-25 15:30:00	AAPL	Stock	63.8375	64.2025	61.075	61.3662	34411732.0
2020-03-25 16:00:00	AAPL	Stock	61.385	61.5	61.0875	61.475	19717596.0
2020-03-25 16:30:00	AAPL	Stock	61.465	61.6875	61.38	61.5775	273760.0
2020-03-25 17:00:00	AAPL	Stock	61.5625	61.66	61.45	61.595	146348.0
2020-03-25 17:30:00	AAPL	Stock	61.625	61.8	61.595	61.75	157860.0
2020-03-25 18:00:00	AAPL	Stock	61.75	62.0675	61.66	61.85	231852.0
2020-03-25 18:30:00	AAPL	Stock	61.76	61.975	61.75	61.95	74564.0
2020-03-25 19:00:00	AAPL	Stock	61.945	61.995	61.455	61.7875	162840.0
2020-03-25 19:30:00	AAPL	Stock	61.775	61.95	61.65	61.88	109456.0
2020-03-25 04:00:00	MSFT	Stock	150.0	152.7	150.0	152.54	25633.0
2020-03-25 04:30:00	MSFT	Stock	152.83	153.47	152.05	153.47	16016.0
2020-03-25 05:00:00	MSFT	Stock	153.68	154.9	153.67	154.5	18450.0
2020-03-25 05:30:00	MSFT	Stock	154.59	154.7	152.65	152.73	35459.0
2020-03-25 06:00:00	MSFT	Stock	152.98	153.5	150.73	150.8	17703.0
2020-03-25 06:30:00	MSFT	Stock	151.08	151.08	147.0	147.2	33059.0
2020-03-25 07:00:00	MSFT	Stock	147.42	150.0	147.25	148.5	80599.0
2020-03-25 07:30:00	MSFT	Stock	148.1	148.4	147.0	147.75	57572.0
2020-03-25 08:00:00	MSFT	Stock	148.9	149.89	147.0	148.3	129849.0
2020-03-25 08:30:00	MSFT	Stock	148.204	149.29	148.07	149.25	79214.0
2020-03-25 09:00:00	MSFT	Stock	149.27	150.0	148.2	148.5	147140.0
2020-03-25 09:30:00	MSFT	Stock	148.91	151.256	147.38	147.44	8528573.0
2020-03-25 10:00:00	MSFT	Stock	147.43	147.78	144.44	146.046	4179626.0
2020-03-25 10:30:00	MSFT	Stock	146.04	148.7	145.99	148.415	3041463.0
2020-03-25 11:00:00	MSFT	Stock	148.42	148.56	146.99	147.631	2779899.0
2020-03-25 11:30:00	MSFT	Stock	147.635	148.29	146.71	147.55	2495747.0
2020-03-25 12:00:00	MSFT	Stock	147.54	150.45	147.415	149.97	3821555.0
2020-03-25 12:30:00	MSFT	Stock	149.931	150.35	149.11	149.81	3215912.0

> showing 50 of 96,797 rows — these rows as CSV

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