PREVIEW / stock_30min / 2020-08-25

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-25.parquet
  size:    1.9 MB
  rows:    96,654
  symbols: 2,445

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-08-25 04:00:00	AAPL	Stock	126.625	126.625	126.1725	126.1725	22976.0
2020-08-25 04:30:00	AAPL	Stock	126.1275	126.1275	125.8775	126.0625	9252.0
2020-08-25 05:00:00	AAPL	Stock	126.205	126.21	126.1375	126.21	5780.0
2020-08-25 05:30:00	AAPL	Stock	126.2725	126.35	126.1725	126.1725	6248.0
2020-08-25 06:00:00	AAPL	Stock	126.225	126.225	125.8775	126.0025	8372.0
2020-08-25 06:30:00	AAPL	Stock	126.015	126.15	126.015	126.0625	4008.0
2020-08-25 07:00:00	AAPL	Stock	126.1125	126.25	125.1025	125.15	366756.0
2020-08-25 07:30:00	AAPL	Stock	125.175	125.485	125.05	125.1125	245264.0
2020-08-25 08:00:00	AAPL	Stock	126.0625	126.2475	124.755	125.25	718068.0
2020-08-25 08:30:00	AAPL	Stock	125.2525	125.31	124.9125	125.0625	299096.0
2020-08-25 09:00:00	AAPL	Stock	125.075	125.1675	124.4125	124.6975	1064504.0
2020-08-25 09:30:00	AAPL	Stock	124.69	125.1792	123.7025	124.32	27335888.0
2020-08-25 10:00:00	AAPL	Stock	124.32	124.3375	123.0525	123.4365	19227416.0
2020-08-25 10:30:00	AAPL	Stock	123.4442	123.97	123.1275	123.8575	13698104.0
2020-08-25 11:00:00	AAPL	Stock	123.865	124.8575	123.7175	124.2775	13838028.0
2020-08-25 11:30:00	AAPL	Stock	124.29	124.3575	123.7375	123.9725	11650896.0
2020-08-25 12:00:00	AAPL	Stock	123.9825	124.1125	123.4725	123.92	9963400.0
2020-08-25 12:30:00	AAPL	Stock	123.9128	124.1715	123.775	123.8375	6196348.0
2020-08-25 13:00:00	AAPL	Stock	123.825	124.23	123.58	124.18	6103092.0
2020-08-25 13:30:00	AAPL	Stock	124.1875	124.275	123.7325	123.835	6872060.0
2020-08-25 14:00:00	AAPL	Stock	123.8525	124.0025	123.708	123.88	4818660.0
2020-08-25 14:30:00	AAPL	Stock	123.8875	124.205	123.79	124.1275	6784372.0
2020-08-25 15:00:00	AAPL	Stock	124.125	125.02	124.0272	124.8175	15089472.0
2020-08-25 15:30:00	AAPL	Stock	124.815	125.0725	124.5675	124.8275	14563028.0
2020-08-25 16:00:00	AAPL	Stock	124.8275	124.9975	124.8	124.985	7482348.0
2020-08-25 16:30:00	AAPL	Stock	124.9525	124.985	124.825	124.9325	63700.0
2020-08-25 17:00:00	AAPL	Stock	124.95	124.965	124.825	124.95	62096.0
2020-08-25 17:30:00	AAPL	Stock	124.95	124.95	124.895	124.895	46572.0
2020-08-25 18:00:00	AAPL	Stock	124.905	124.9325	124.825	124.8375	45540.0
2020-08-25 18:30:00	AAPL	Stock	124.8375	124.8875	124.825	124.8325	43604.0
2020-08-25 19:00:00	AAPL	Stock	124.83	124.8725	124.825	124.8475	40784.0
2020-08-25 19:30:00	AAPL	Stock	124.865	124.96	124.865	124.9075	155292.0
2020-08-25 04:30:00	MSFT	Stock	213.95	213.95	213.95	213.95	100.0
2020-08-25 05:00:00	MSFT	Stock	214.19	214.24	214.19	214.24	1200.0
2020-08-25 05:30:00	MSFT	Stock	214.42	214.42	214.02	214.04	1828.0
2020-08-25 06:00:00	MSFT	Stock	213.89	214.08	213.8	214.08	1286.0
2020-08-25 06:30:00	MSFT	Stock	214.28	214.28	214.22	214.22	297.0
2020-08-25 07:00:00	MSFT	Stock	214.0	214.18	213.3	213.5	16445.0
2020-08-25 07:30:00	MSFT	Stock	213.42	213.78	213.4	213.46	4175.0
2020-08-25 08:00:00	MSFT	Stock	213.947	214.0	213.0	213.62	32866.0
2020-08-25 08:30:00	MSFT	Stock	213.599	213.599	213.11	213.3	4550.0
2020-08-25 09:00:00	MSFT	Stock	213.26	213.4	212.8	213.06	49390.0
2020-08-25 09:30:00	MSFT	Stock	213.3	214.55	213.1	214.393	2207108.0
2020-08-25 10:00:00	MSFT	Stock	214.38	215.73	214.07	215.273	1826721.0
2020-08-25 10:30:00	MSFT	Stock	215.28	216.02	214.95	215.82	1448605.0
2020-08-25 11:00:00	MSFT	Stock	215.8	216.52	215.09	215.31	1620432.0
2020-08-25 11:30:00	MSFT	Stock	215.32	215.478	214.75	215.19	951337.0
2020-08-25 12:00:00	MSFT	Stock	215.183	215.26	214.69	215.11	651271.0
2020-08-25 12:30:00	MSFT	Stock	215.12	215.48	215.05	215.426	606309.0
2020-08-25 13:00:00	MSFT	Stock	215.44	215.48	215.04	215.17	426068.0

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

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