PREVIEW / stock_30min / 2022-09-27

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-27.parquet
  size:    2.1 MB
  rows:    104,498
  symbols: 2,277

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
2022-09-27 04:00:00	AAPL	Stock	152.52	153.33	152.52	152.99	23446.0
2022-09-27 04:30:00	AAPL	Stock	152.95	152.96	152.65	152.67	7808.0
2022-09-27 05:00:00	AAPL	Stock	152.68	152.68	152.12	152.17	8905.0
2022-09-27 05:30:00	AAPL	Stock	152.2	152.5	152.2	152.22	11092.0
2022-09-27 06:00:00	AAPL	Stock	152.34	152.77	152.22	152.76	10392.0
2022-09-27 06:30:00	AAPL	Stock	152.77	153.0	152.64	152.79	16669.0
2022-09-27 07:00:00	AAPL	Stock	152.66	152.96	152.62	152.88	45949.0
2022-09-27 07:30:00	AAPL	Stock	152.87	153.2	152.87	153.0	128299.0
2022-09-27 08:00:00	AAPL	Stock	152.7001	153.21	152.5	152.93	173786.0
2022-09-27 08:30:00	AAPL	Stock	152.93	153.35	152.86	152.92	101757.0
2022-09-27 09:00:00	AAPL	Stock	152.91	153.1	152.6	152.79	206931.0
2022-09-27 09:30:00	AAPL	Stock	152.74	154.72	152.7	153.92	10036823.0
2022-09-27 10:00:00	AAPL	Stock	153.92	154.04	152.5	152.7899	6326341.0
2022-09-27 10:30:00	AAPL	Stock	152.7895	153.72	152.73	153.4762	4147625.0
2022-09-27 11:00:00	AAPL	Stock	153.46	153.57	151.57	151.755	4728450.0
2022-09-27 11:30:00	AAPL	Stock	151.755	152.39	151.53	151.575	4361430.0
2022-09-27 12:00:00	AAPL	Stock	151.58	151.625	149.945	150.8455	6025625.0
2022-09-27 12:30:00	AAPL	Stock	150.85	151.82	150.745	151.7	4511141.0
2022-09-27 13:00:00	AAPL	Stock	151.69	151.7	151.0	151.296	3641612.0
2022-09-27 13:30:00	AAPL	Stock	151.29	151.5	150.72	151.08	2776123.0
2022-09-27 14:00:00	AAPL	Stock	151.09	151.63	150.86	151.1159	2930379.0
2022-09-27 14:30:00	AAPL	Stock	151.12	152.45	150.93	152.02	4161196.0
2022-09-27 15:00:00	AAPL	Stock	152.03	152.05	151.4	151.52	3986380.0
2022-09-27 15:30:00	AAPL	Stock	151.52	152.19	151.03	151.75	7389018.0
2022-09-27 16:00:00	AAPL	Stock	151.76	151.91	151.51	151.69	7222671.0
2022-09-27 16:30:00	AAPL	Stock	151.67	151.83	151.6	151.81	105482.0
2022-09-27 17:00:00	AAPL	Stock	151.82	151.85	151.66	151.8	42299.0
2022-09-27 17:30:00	AAPL	Stock	151.79	151.88	151.72	151.78	17380.0
2022-09-27 18:00:00	AAPL	Stock	151.82	151.99	151.78	151.82	26817.0
2022-09-27 18:30:00	AAPL	Stock	151.83	151.98	151.81	151.95	13472.0
2022-09-27 19:00:00	AAPL	Stock	151.98	152.07	151.85	151.98	22555.0
2022-09-27 19:30:00	AAPL	Stock	151.99	152.2	151.8	151.9	42848.0
2022-09-27 04:00:00	MSFT	Stock	237.6	240.97	237.6	240.6	4407.0
2022-09-27 04:30:00	MSFT	Stock	240.51	240.63	240.3	240.61	2193.0
2022-09-27 05:00:00	MSFT	Stock	240.13	240.13	239.29	239.67	1663.0
2022-09-27 05:30:00	MSFT	Stock	239.54	239.79	239.31	239.31	1340.0
2022-09-27 06:00:00	MSFT	Stock	239.6	240.0	239.55	240.0	13504.0
2022-09-27 06:30:00	MSFT	Stock	239.96	240.37	239.8	240.0	3519.0
2022-09-27 07:00:00	MSFT	Stock	239.93	240.5	239.9	240.32	14907.0
2022-09-27 07:30:00	MSFT	Stock	240.28	240.66	240.2	240.66	34849.0
2022-09-27 08:00:00	MSFT	Stock	240.2	240.73	236.857	240.48	68395.0
2022-09-27 08:30:00	MSFT	Stock	240.6	240.9	239.82	240.0	48471.0
2022-09-27 09:00:00	MSFT	Stock	239.83	240.39	239.33	239.98	65360.0
2022-09-27 09:30:00	MSFT	Stock	239.98	241.8	239.31	240.06	2307462.0
2022-09-27 10:00:00	MSFT	Stock	240.07	240.14	238.42	238.97	1299380.0
2022-09-27 10:30:00	MSFT	Stock	239.05	240.1	238.75	239.565	988961.0
2022-09-27 11:00:00	MSFT	Stock	239.57	239.86	237.24	237.43	952867.0
2022-09-27 11:30:00	MSFT	Stock	237.4	238.27	236.6882	236.7612	996451.0
2022-09-27 12:00:00	MSFT	Stock	236.74	236.87	234.5	235.324	1689809.0
2022-09-27 12:30:00	MSFT	Stock	235.29	235.92	234.87	235.67	974701.0

> showing 50 of 104,498 rows — these rows as CSV

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