PREVIEW / stock_30min / 2021-03-19

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-19.parquet
  size:    2.3 MB
  rows:    114,531
  symbols: 2,920

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
2021-03-19 04:00:00	AAPL	Stock	120.86	121.53	120.86	121.44	14720.0
2021-03-19 04:30:00	AAPL	Stock	121.44	121.7	121.44	121.7	16116.0
2021-03-19 05:00:00	AAPL	Stock	121.63	121.66	121.53	121.63	6318.0
2021-03-19 05:30:00	AAPL	Stock	121.51	121.57	121.47	121.55	5235.0
2021-03-19 06:00:00	AAPL	Stock	121.47	121.48	121.11	121.17	6501.0
2021-03-19 06:30:00	AAPL	Stock	121.32	121.59	121.27	121.3	16141.0
2021-03-19 07:00:00	AAPL	Stock	121.27	121.37	121.0	121.19	91415.0
2021-03-19 07:30:00	AAPL	Stock	121.17	121.41	121.11	121.32	77382.0
2021-03-19 08:00:00	AAPL	Stock	121.2401	121.43	121.0101	121.23	339014.0
2021-03-19 08:30:00	AAPL	Stock	121.2	121.33	121.01	121.14	126724.0
2021-03-19 09:00:00	AAPL	Stock	121.14	121.16	119.89	119.89	724032.0
2021-03-19 09:30:00	AAPL	Stock	119.89	121.43	119.73	120.68	22912946.0
2021-03-19 10:00:00	AAPL	Stock	120.68	120.68	119.675	120.1153	9323240.0
2021-03-19 10:30:00	AAPL	Stock	120.1104	120.73	119.8441	120.5	7570062.0
2021-03-19 11:00:00	AAPL	Stock	120.5052	120.56	119.86	120.0115	5998210.0
2021-03-19 11:30:00	AAPL	Stock	120.01	120.6196	119.93	120.46	4267988.0
2021-03-19 12:00:00	AAPL	Stock	120.47	120.85	120.41	120.5581	5011051.0
2021-03-19 12:30:00	AAPL	Stock	120.55	121.16	120.5301	120.925	4516280.0
2021-03-19 13:00:00	AAPL	Stock	120.92	120.95	120.485	120.605	3588012.0
2021-03-19 13:30:00	AAPL	Stock	120.61	120.68	120.27	120.32	4019421.0
2021-03-19 14:00:00	AAPL	Stock	120.32	120.49	120.0	120.2801	4935058.0
2021-03-19 14:30:00	AAPL	Stock	120.29	120.34	119.89	120.1153	4300433.0
2021-03-19 15:00:00	AAPL	Stock	120.11	120.185	119.9	120.085	5742410.0
2021-03-19 15:30:00	AAPL	Stock	120.09	120.97	119.85	119.87	14873662.0
2021-03-19 16:00:00	AAPL	Stock	119.86	120.22	119.8538	120.03	59203051.0
2021-03-19 16:30:00	AAPL	Stock	120.02	120.09	119.99	120.01	110769.0
2021-03-19 17:00:00	AAPL	Stock	120.01	120.05	120.0	120.02	69456.0
2021-03-19 17:30:00	AAPL	Stock	120.03	120.04	119.99	120.03	120470.0
2021-03-19 18:00:00	AAPL	Stock	120.03	120.03	119.95	119.99	350516.0
2021-03-19 18:30:00	AAPL	Stock	120.0	120.03	119.97	119.99	33993.0
2021-03-19 19:00:00	AAPL	Stock	119.98	120.0	119.96	119.97	28096.0
2021-03-19 19:30:00	AAPL	Stock	119.98	120.05	119.95	120.02	76804.0
2021-03-19 04:00:00	MSFT	Stock	232.75	232.75	232.75	232.75	147.0
2021-03-19 04:30:00	MSFT	Stock	232.7	232.7	232.48	232.48	206.0
2021-03-19 05:00:00	MSFT	Stock	232.33	232.72	232.16	232.72	1195.0
2021-03-19 05:30:00	MSFT	Stock	232.5	232.5	232.33	232.33	650.0
2021-03-19 06:00:00	MSFT	Stock	232.43	232.43	232.0	232.0	2269.0
2021-03-19 06:30:00	MSFT	Stock	232.1	232.1	231.86	232.0	3192.0
2021-03-19 07:00:00	MSFT	Stock	231.82	231.9	231.15	231.35	18875.0
2021-03-19 07:30:00	MSFT	Stock	231.4	232.0	231.07	231.76	17200.0
2021-03-19 08:00:00	MSFT	Stock	231.5	232.3	231.25	232.05	37934.0
2021-03-19 08:30:00	MSFT	Stock	232.1	232.3	231.6	231.85	11199.0
2021-03-19 09:00:00	MSFT	Stock	231.56	232.41	230.28	231.0	143998.0
2021-03-19 09:30:00	MSFT	Stock	231.0	232.474	230.5301	230.6717	6781402.0
2021-03-19 10:00:00	MSFT	Stock	230.65	230.74	229.3496	230.58	1715970.0
2021-03-19 10:30:00	MSFT	Stock	230.56	231.59	230.1683	231.155	1395274.0
2021-03-19 11:00:00	MSFT	Stock	231.16	231.5299	230.17	230.735	960909.0
2021-03-19 11:30:00	MSFT	Stock	230.72	231.59	230.57	231.44	780307.0
2021-03-19 12:00:00	MSFT	Stock	231.43	231.7824	231.13	231.33	789646.0
2021-03-19 12:30:00	MSFT	Stock	231.32	231.9272	231.23	231.89	767102.0

> showing 50 of 114,531 rows — these rows as CSV

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