PREVIEW / stock_30min / 2020-03-30

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-30.parquet
  size:    1.8 MB
  rows:    92,947
  symbols: 2,411

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-30 04:00:00	AAPL	Stock	61.75	61.75	61.38	61.6	56260.0
2020-03-30 04:30:00	AAPL	Stock	61.7	62.025	61.675	62.025	16160.0
2020-03-30 05:00:00	AAPL	Stock	61.875	62.4975	61.7875	62.1975	10756.0
2020-03-30 05:30:00	AAPL	Stock	62.4125	62.425	61.95	62.125	11092.0
2020-03-30 06:00:00	AAPL	Stock	62.0425	62.1625	61.8875	61.935	15992.0
2020-03-30 06:30:00	AAPL	Stock	62.0	62.225	62.0	62.125	7240.0
2020-03-30 07:00:00	AAPL	Stock	62.13	62.3625	61.75	62.25	312864.0
2020-03-30 07:30:00	AAPL	Stock	62.16	62.4075	62.125	62.25	276128.0
2020-03-30 08:00:00	AAPL	Stock	61.8315	62.41	61.8275	62.3125	385132.0
2020-03-30 08:30:00	AAPL	Stock	62.32	62.8475	61.935	62.775	848656.0
2020-03-30 09:00:00	AAPL	Stock	62.825	62.8425	62.625	62.6275	431828.0
2020-03-30 09:30:00	AAPL	Stock	62.685	63.415	62.375	62.4755	20639228.0
2020-03-30 10:00:00	AAPL	Stock	62.49	63.0275	62.35	62.7175	12628032.0
2020-03-30 10:30:00	AAPL	Stock	62.7225	63.15	62.7175	62.8488	9019140.0
2020-03-30 11:00:00	AAPL	Stock	62.8488	63.275	62.8075	63.2725	7612036.0
2020-03-30 11:30:00	AAPL	Stock	63.2725	63.375	63.0388	63.1425	6935288.0
2020-03-30 12:00:00	AAPL	Stock	63.1325	63.22	62.815	63.17	6692148.0
2020-03-30 12:30:00	AAPL	Stock	63.1775	63.5	63.0425	63.4325	7724868.0
2020-03-30 13:00:00	AAPL	Stock	63.435	63.435	63.0542	63.1772	6446968.0
2020-03-30 13:30:00	AAPL	Stock	63.1825	63.2575	62.9625	63.1375	4681636.0
2020-03-30 14:00:00	AAPL	Stock	63.1462	63.2625	62.8675	63.24	6952692.0
2020-03-30 14:30:00	AAPL	Stock	63.2408	63.5475	63.1675	63.4425	7716312.0
2020-03-30 15:00:00	AAPL	Stock	63.4392	63.675	62.9875	63.2125	10040464.0
2020-03-30 15:30:00	AAPL	Stock	63.2212	63.88	63.2025	63.6975	18556880.0
2020-03-30 16:00:00	AAPL	Stock	63.6975	63.7025	61.935	63.5225	13383252.0
2020-03-30 16:30:00	AAPL	Stock	63.5	63.62	63.5	63.5375	61380.0
2020-03-30 17:00:00	AAPL	Stock	63.55	63.5725	63.5	63.5175	27768.0
2020-03-30 17:30:00	AAPL	Stock	63.52	63.5575	63.5	63.5	26480.0
2020-03-30 18:00:00	AAPL	Stock	63.5	63.6725	63.475	63.625	39708.0
2020-03-30 18:30:00	AAPL	Stock	63.625	63.7025	63.55	63.55	47644.0
2020-03-30 19:00:00	AAPL	Stock	63.55	63.605	63.5	63.5	26836.0
2020-03-30 19:30:00	AAPL	Stock	63.535	63.6925	63.535	63.625	68852.0
2020-03-30 04:00:00	MSFT	Stock	148.79	150.25	148.79	149.8	2980.0
2020-03-30 04:30:00	MSFT	Stock	149.57	150.95	149.0	150.0	6657.0
2020-03-30 05:00:00	MSFT	Stock	150.8	150.8	149.82	149.82	1578.0
2020-03-30 05:30:00	MSFT	Stock	150.9	151.23	150.28	150.28	7670.0
2020-03-30 06:00:00	MSFT	Stock	150.6	150.67	150.5	150.67	2502.0
2020-03-30 06:30:00	MSFT	Stock	150.31	151.6	150.26	151.6	6113.0
2020-03-30 07:00:00	MSFT	Stock	151.15	151.5	150.6	151.0	28815.0
2020-03-30 07:30:00	MSFT	Stock	151.0	151.48	150.7	151.1	18962.0
2020-03-30 08:00:00	MSFT	Stock	151.27	151.5	149.85	150.69	170148.0
2020-03-30 08:30:00	MSFT	Stock	150.52	152.1	149.7	152.0	221397.0
2020-03-30 09:00:00	MSFT	Stock	152.2	152.55	151.39	152.5	102190.0
2020-03-30 09:30:00	MSFT	Stock	152.42	156.93	150.01	156.08	8055430.0
2020-03-30 10:00:00	MSFT	Stock	156.12	158.0	156.06	157.42	4468602.0
2020-03-30 10:30:00	MSFT	Stock	157.42	158.25	156.88	157.34	2960090.0
2020-03-30 11:00:00	MSFT	Stock	157.315	158.85	157.22	158.839	2954230.0
2020-03-30 11:30:00	MSFT	Stock	158.85	159.29	158.46	158.61	2925584.0
2020-03-30 12:00:00	MSFT	Stock	158.62	158.96	157.6	158.93	2374228.0
2020-03-30 12:30:00	MSFT	Stock	158.94	160.0	158.534	159.92	3384037.0

> showing 50 of 92,947 rows — these rows as CSV

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