PREVIEW / stock_30min / 2020-06-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-23.parquet
  size:    2.0 MB
  rows:    98,441
  symbols: 2,446

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-06-23 04:00:00	AAPL	Stock	90.8525	91.0	90.615	90.65	46844.0
2020-06-23 04:30:00	AAPL	Stock	90.65	90.845	90.6475	90.785	20252.0
2020-06-23 05:00:00	AAPL	Stock	90.8	90.8725	90.8	90.8725	5044.0
2020-06-23 05:30:00	AAPL	Stock	90.9875	90.9875	90.775	90.7775	8688.0
2020-06-23 06:00:00	AAPL	Stock	90.7525	91.125	90.75	91.0825	39512.0
2020-06-23 06:30:00	AAPL	Stock	91.0875	91.0875	90.875	90.97	118840.0
2020-06-23 07:00:00	AAPL	Stock	90.89	91.2225	90.825	91.15	392636.0
2020-06-23 07:30:00	AAPL	Stock	91.175	91.225	91.0375	91.1625	187844.0
2020-06-23 08:00:00	AAPL	Stock	91.0625	91.3125	90.875	91.3	720112.0
2020-06-23 08:30:00	AAPL	Stock	91.3	91.3175	91.061	91.061	450704.0
2020-06-23 09:00:00	AAPL	Stock	91.065	91.1	90.875	90.9925	844324.0
2020-06-23 09:30:00	AAPL	Stock	90.9825	91.3175	90.5675	91.2628	21543712.0
2020-06-23 10:00:00	AAPL	Stock	91.2625	91.525	91.075	91.4463	12549936.0
2020-06-23 10:30:00	AAPL	Stock	91.445	91.66	91.3308	91.3928	10456372.0
2020-06-23 11:00:00	AAPL	Stock	91.3925	91.6725	91.23	91.665	7271956.0
2020-06-23 11:30:00	AAPL	Stock	91.665	92.11	91.615	92.105	9917720.0
2020-06-23 12:00:00	AAPL	Stock	92.1025	92.345	92.0275	92.3175	10419764.0
2020-06-23 12:30:00	AAPL	Stock	92.3205	92.5	92.2925	92.4062	10355452.0
2020-06-23 13:00:00	AAPL	Stock	92.405	92.85	92.365	92.844	12515876.0
2020-06-23 13:30:00	AAPL	Stock	92.85	93.095	92.6375	92.785	14659060.0
2020-06-23 14:00:00	AAPL	Stock	92.781	92.8175	92.25	92.5295	14276400.0
2020-06-23 14:30:00	AAPL	Stock	92.531	92.755	92.235	92.2375	8801556.0
2020-06-23 15:00:00	AAPL	Stock	92.25	92.3675	91.7025	91.7475	13321108.0
2020-06-23 15:30:00	AAPL	Stock	91.7325	91.9875	91.5075	91.5925	18297208.0
2020-06-23 16:00:00	AAPL	Stock	91.605	91.9962	91.5275	91.6	8346116.0
2020-06-23 16:30:00	AAPL	Stock	91.5525	91.6	91.4525	91.5875	73484.0
2020-06-23 17:00:00	AAPL	Stock	91.5875	91.6	91.475	91.535	63948.0
2020-06-23 17:30:00	AAPL	Stock	91.52	91.55	91.4325	91.4375	70544.0
2020-06-23 18:00:00	AAPL	Stock	91.435	91.5	91.25	91.4825	157784.0
2020-06-23 18:30:00	AAPL	Stock	91.4825	91.4825	91.1525	91.1575	102596.0
2020-06-23 19:00:00	AAPL	Stock	91.1575	91.25	91.0875	91.2325	82588.0
2020-06-23 19:30:00	AAPL	Stock	91.2125	91.4625	91.2	91.3	56828.0
2020-06-23 04:00:00	MSFT	Stock	202.28	202.88	202.28	202.55	3289.0
2020-06-23 04:30:00	MSFT	Stock	202.7	202.77	202.5	202.5	1668.0
2020-06-23 05:00:00	MSFT	Stock	202.57	202.57	202.4	202.5	1370.0
2020-06-23 05:30:00	MSFT	Stock	202.58	202.58	202.58	202.58	100.0
2020-06-23 06:00:00	MSFT	Stock	202.6	203.1	202.54	203.1	7717.0
2020-06-23 06:30:00	MSFT	Stock	202.91	203.01	202.77	202.94	7048.0
2020-06-23 07:00:00	MSFT	Stock	202.75	203.15	202.54	203.0	25900.0
2020-06-23 07:30:00	MSFT	Stock	203.14	203.15	202.1	202.35	17971.0
2020-06-23 08:00:00	MSFT	Stock	202.66	203.17	202.11	202.41	79508.0
2020-06-23 08:30:00	MSFT	Stock	202.42	202.56	202.15	202.3	33518.0
2020-06-23 09:00:00	MSFT	Stock	202.37	202.6	201.77	202.01	59949.0
2020-06-23 09:30:00	MSFT	Stock	202.06	203.27	201.425	202.106	5254334.0
2020-06-23 10:00:00	MSFT	Stock	202.125	202.72	201.757	202.71	1797489.0
2020-06-23 10:30:00	MSFT	Stock	202.71	202.97	202.17	202.23	1655606.0
2020-06-23 11:00:00	MSFT	Stock	202.23	203.05	201.98	202.99	1563873.0
2020-06-23 11:30:00	MSFT	Stock	202.98	203.54	202.67	203.12	1602982.0
2020-06-23 12:00:00	MSFT	Stock	203.12	203.41	202.88	203.17	1335941.0
2020-06-23 12:30:00	MSFT	Stock	203.17	203.49	202.93	203.397	832782.0

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

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