PREVIEW / stock_30min / 2021-06-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-23.parquet
  size:    2.2 MB
  rows:    111,013
  symbols: 2,930

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-06-23 04:00:00	AAPL	Stock	133.78	134.2	133.74	133.98	7944.0
2021-06-23 04:30:00	AAPL	Stock	134.04	134.04	133.94	133.95	5345.0
2021-06-23 05:00:00	AAPL	Stock	133.98	134.0	133.81	133.93	4869.0
2021-06-23 05:30:00	AAPL	Stock	133.97	134.0	133.97	133.98	1912.0
2021-06-23 06:00:00	AAPL	Stock	133.94	134.06	133.94	134.06	1768.0
2021-06-23 06:30:00	AAPL	Stock	134.12	134.19	134.06	134.06	2361.0
2021-06-23 07:00:00	AAPL	Stock	134.09	134.22	133.89	133.96	101691.0
2021-06-23 07:30:00	AAPL	Stock	133.96	134.11	133.82	134.08	52052.0
2021-06-23 08:00:00	AAPL	Stock	134.0701	134.24	133.87	134.06	177216.0
2021-06-23 08:30:00	AAPL	Stock	134.155	134.16	133.9	134.05	214034.0
2021-06-23 09:00:00	AAPL	Stock	134.05	134.1199	133.55	133.78	255882.0
2021-06-23 09:30:00	AAPL	Stock	133.78	134.32	133.51	134.095	10085431.0
2021-06-23 10:00:00	AAPL	Stock	134.09	134.26	133.88	133.9611	5025583.0
2021-06-23 10:30:00	AAPL	Stock	133.96	133.965	133.65	133.76	3635560.0
2021-06-23 11:00:00	AAPL	Stock	133.77	133.81	133.23	133.48	4403426.0
2021-06-23 11:30:00	AAPL	Stock	133.47	133.7801	133.36	133.73	2927866.0
2021-06-23 12:00:00	AAPL	Stock	133.735	133.82	133.61	133.6801	2643389.0
2021-06-23 12:30:00	AAPL	Stock	133.685	133.77	133.26	133.725	3089119.0
2021-06-23 13:00:00	AAPL	Stock	133.73	134.25	133.67	134.08	3901398.0
2021-06-23 13:30:00	AAPL	Stock	134.08	134.09	133.77	133.95	1966506.0
2021-06-23 14:00:00	AAPL	Stock	133.94	133.95	133.615	133.68	2286459.0
2021-06-23 14:30:00	AAPL	Stock	133.675	133.95	133.61	133.93	1942347.0
2021-06-23 15:00:00	AAPL	Stock	133.9356	133.9887	133.8	133.975	2220221.0
2021-06-23 15:30:00	AAPL	Stock	133.9799	133.9799	133.5106	133.69	4729120.0
2021-06-23 16:00:00	AAPL	Stock	133.7	133.74	133.62	133.7	4433338.0
2021-06-23 16:30:00	AAPL	Stock	133.7	133.7	133.5	133.6	82485.0
2021-06-23 17:00:00	AAPL	Stock	133.61	133.7099	133.61	133.64	30560.0
2021-06-23 17:30:00	AAPL	Stock	133.63	133.68	133.62	133.68	8224.0
2021-06-23 18:00:00	AAPL	Stock	133.65	133.72	133.62	133.7	26090.0
2021-06-23 18:30:00	AAPL	Stock	133.7	133.75	133.66	133.66	26375.0
2021-06-23 19:00:00	AAPL	Stock	133.68	133.69	133.63	133.68	16936.0
2021-06-23 19:30:00	AAPL	Stock	133.68	133.7	133.63	133.65	29549.0
2021-06-23 04:00:00	MSFT	Stock	266.29	266.29	265.8	266.29	2356.0
2021-06-23 04:30:00	MSFT	Stock	266.28	266.28	265.94	265.95	2419.0
2021-06-23 05:00:00	MSFT	Stock	265.68	265.68	265.63	265.63	690.0
2021-06-23 05:30:00	MSFT	Stock	265.89	265.89	265.89	265.89	431.0
2021-06-23 06:00:00	MSFT	Stock	265.94	266.15	265.94	266.15	1991.0
2021-06-23 06:30:00	MSFT	Stock	266.34	266.37	266.21	266.21	737.0
2021-06-23 07:00:00	MSFT	Stock	266.35	266.4	265.11	265.49	16257.0
2021-06-23 07:30:00	MSFT	Stock	265.58	266.5	265.58	266.32	33427.0
2021-06-23 08:00:00	MSFT	Stock	265.7399	266.49	265.0528	266.19	20122.0
2021-06-23 08:30:00	MSFT	Stock	266.39	266.44	265.51	266.269	90855.0
2021-06-23 09:00:00	MSFT	Stock	266.39	266.48	265.05	265.51	50140.0
2021-06-23 09:30:00	MSFT	Stock	265.5	266.83	265.22	266.1655	2315704.0
2021-06-23 10:00:00	MSFT	Stock	266.16	266.37	265.34	265.47	1248895.0
2021-06-23 10:30:00	MSFT	Stock	265.46	265.46	264.6399	264.85	1275780.0
2021-06-23 11:00:00	MSFT	Stock	264.88	265.24	264.43	265.2201	877608.0
2021-06-23 11:30:00	MSFT	Stock	265.22	265.63	265.08	265.35	716953.0
2021-06-23 12:00:00	MSFT	Stock	265.35	265.3699	264.9341	264.9522	547709.0
2021-06-23 12:30:00	MSFT	Stock	264.93	265.25	264.43	264.9285	759959.0

> showing 50 of 111,013 rows — these rows as CSV

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