PREVIEW / stock_30min / 2020-02-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-24.parquet
  size:    1.9 MB
  rows:    93,618
  symbols: 2,456

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-02-24 04:00:00	AAPL	Stock	75.0	75.47	74.53	74.825	267212.0
2020-02-24 04:30:00	AAPL	Stock	74.825	75.0	74.4775	74.9775	166164.0
2020-02-24 05:00:00	AAPL	Stock	74.9725	75.25	74.89	75.0625	123292.0
2020-02-24 05:30:00	AAPL	Stock	75.005	75.005	74.625	74.75	146476.0
2020-02-24 06:00:00	AAPL	Stock	74.685	74.97	74.5875	74.875	109600.0
2020-02-24 06:30:00	AAPL	Stock	74.875	75.255	74.8725	75.1	127964.0
2020-02-24 07:00:00	AAPL	Stock	75.0575	75.825	75.0	75.5425	625060.0
2020-02-24 07:30:00	AAPL	Stock	75.5075	75.7275	75.2325	75.45	438756.0
2020-02-24 08:00:00	AAPL	Stock	75.4825	75.825	75.0	75.375	944996.0
2020-02-24 08:30:00	AAPL	Stock	75.375	75.465	75.045	75.3125	731536.0
2020-02-24 09:00:00	AAPL	Stock	75.3275	75.3275	74.1375	74.2275	1716336.0
2020-02-24 09:30:00	AAPL	Stock	74.2675	76.045	72.3075	75.69	48164012.0
2020-02-24 10:00:00	AAPL	Stock	75.6925	75.92	74.9075	75.065	15310392.0
2020-02-24 10:30:00	AAPL	Stock	75.0525	75.3312	74.6	75.2712	12900148.0
2020-02-24 11:00:00	AAPL	Stock	75.27	75.34	74.725	75.11	9121572.0
2020-02-24 11:30:00	AAPL	Stock	75.105	75.155	74.6025	74.925	7956644.0
2020-02-24 12:00:00	AAPL	Stock	74.915	74.9718	74.5	74.7908	7298432.0
2020-02-24 12:30:00	AAPL	Stock	74.7875	75.245	74.665	75.03	6095968.0
2020-02-24 13:00:00	AAPL	Stock	75.015	75.0175	74.6675	74.9625	5631892.0
2020-02-24 13:30:00	AAPL	Stock	74.9575	75.1675	74.8575	75.0875	5190832.0
2020-02-24 14:00:00	AAPL	Stock	75.0925	75.2325	74.7775	75.1712	5490020.0
2020-02-24 14:30:00	AAPL	Stock	75.1775	75.625	75.1	75.5425	7263980.0
2020-02-24 15:00:00	AAPL	Stock	75.55	75.8225	75.075	75.1402	9376072.0
2020-02-24 15:30:00	AAPL	Stock	75.155	75.2375	74.52	74.5425	16211208.0
2020-02-24 16:00:00	AAPL	Stock	74.5425	74.62	74.4375	74.55	19805908.0
2020-02-24 16:30:00	AAPL	Stock	74.5625	74.6	74.48	74.5975	288428.0
2020-02-24 17:00:00	AAPL	Stock	74.55	74.5625	74.465	74.5375	80396.0
2020-02-24 17:30:00	AAPL	Stock	74.5375	74.5375	74.4	74.455	85604.0
2020-02-24 18:00:00	AAPL	Stock	74.4225	74.6675	74.315	74.5	233548.0
2020-02-24 18:30:00	AAPL	Stock	74.525	74.8375	74.4625	74.825	71928.0
2020-02-24 19:00:00	AAPL	Stock	74.825	75.0775	74.8125	74.9675	180960.0
2020-02-24 19:30:00	AAPL	Stock	75.02	75.325	74.9775	75.275	126512.0
2020-02-24 04:00:00	MSFT	Stock	172.8	172.8	171.3	171.5	43461.0
2020-02-24 04:30:00	MSFT	Stock	171.78	172.28	171.3	171.8	40510.0
2020-02-24 05:00:00	MSFT	Stock	172.05	172.3	171.85	172.24	19240.0
2020-02-24 05:30:00	MSFT	Stock	172.01	172.2	171.42	171.44	17963.0
2020-02-24 06:00:00	MSFT	Stock	171.44	172.3	171.44	171.8	26122.0
2020-02-24 06:30:00	MSFT	Stock	171.94	173.16	171.82	172.71	13604.0
2020-02-24 07:00:00	MSFT	Stock	172.99	173.98	172.33	172.88	92961.0
2020-02-24 07:30:00	MSFT	Stock	172.8	173.65	171.8	172.02	107893.0
2020-02-24 08:00:00	MSFT	Stock	173.7	173.98	171.42	171.62	220183.0
2020-02-24 08:30:00	MSFT	Stock	171.7	171.94	168.65	169.771	541458.0
2020-02-24 09:00:00	MSFT	Stock	169.8	170.1	166.92	167.76	620140.0
2020-02-24 09:30:00	MSFT	Stock	167.93	174.3	163.23	174.26	14908328.0
2020-02-24 10:00:00	MSFT	Stock	174.22	174.55	172.05	172.42	5107259.0
2020-02-24 10:30:00	MSFT	Stock	172.37	173.05	171.18	172.95	4444763.0
2020-02-24 11:00:00	MSFT	Stock	172.94	173.18	171.87	172.05	2912657.0
2020-02-24 11:30:00	MSFT	Stock	172.05	172.3	171.07	171.86	2674932.0
2020-02-24 12:00:00	MSFT	Stock	171.83	171.99	170.7	171.66	2137539.0
2020-02-24 12:30:00	MSFT	Stock	171.65	172.43	171.44	171.71	1732227.0

> showing 50 of 93,618 rows — these rows as CSV

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