PREVIEW / stock_30min / 2021-08-18

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-18.parquet
  size:    2.2 MB
  rows:    109,022
  symbols: 2,783

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-08-18 04:00:00	AAPL	Stock	149.99	150.51	149.99	150.42	21234.0
2021-08-18 04:30:00	AAPL	Stock	150.41	150.5	150.31	150.36	8724.0
2021-08-18 05:00:00	AAPL	Stock	150.4	150.69	150.4	150.58	13074.0
2021-08-18 05:30:00	AAPL	Stock	150.47	150.69	150.32	150.38	6328.0
2021-08-18 06:00:00	AAPL	Stock	150.38	150.52	150.32	150.52	3982.0
2021-08-18 06:30:00	AAPL	Stock	150.53	150.68	150.53	150.64	4178.0
2021-08-18 07:00:00	AAPL	Stock	150.61	150.7	150.43	150.45	68743.0
2021-08-18 07:30:00	AAPL	Stock	150.42	150.44	150.26	150.31	34368.0
2021-08-18 08:00:00	AAPL	Stock	150.3899	150.65	150.0	150.04	144332.0
2021-08-18 08:30:00	AAPL	Stock	150.03	150.1	149.8799	149.98	86884.0
2021-08-18 09:00:00	AAPL	Stock	149.97	150.0	149.72	149.82	171881.0
2021-08-18 09:30:00	AAPL	Stock	149.81	150.72	149.4	149.755	8978074.0
2021-08-18 10:00:00	AAPL	Stock	149.75	150.4399	149.64	149.78	5502137.0
2021-08-18 10:30:00	AAPL	Stock	149.775	149.91	149.14	149.29	5030905.0
2021-08-18 11:00:00	AAPL	Stock	149.271	149.28	148.39	148.43	5180303.0
2021-08-18 11:30:00	AAPL	Stock	148.4299	148.7299	148.18	148.46	4348335.0
2021-08-18 12:00:00	AAPL	Stock	148.4493	148.93	148.35	148.67	3617650.0
2021-08-18 12:30:00	AAPL	Stock	148.6699	148.87	148.44	148.6689	2324393.0
2021-08-18 13:00:00	AAPL	Stock	148.66	148.7	148.28	148.2872	2106177.0
2021-08-18 13:30:00	AAPL	Stock	148.29	148.315	147.91	148.17	3169116.0
2021-08-18 14:00:00	AAPL	Stock	148.16	148.689	147.72	148.49	6644870.0
2021-08-18 14:30:00	AAPL	Stock	148.487	148.65	147.86	147.99	4276413.0
2021-08-18 15:00:00	AAPL	Stock	147.98	147.99	147.47	147.5	4457322.0
2021-08-18 15:30:00	AAPL	Stock	147.495	147.52	146.15	146.36	13155208.0
2021-08-18 16:00:00	AAPL	Stock	146.36	146.36	146.0	146.12	5849812.0
2021-08-18 16:30:00	AAPL	Stock	146.1	146.24	145.98	146.24	111508.0
2021-08-18 17:00:00	AAPL	Stock	146.25	146.43	146.15	146.43	46587.0
2021-08-18 17:30:00	AAPL	Stock	146.45	146.54	146.22	146.34	40946.0
2021-08-18 18:00:00	AAPL	Stock	146.34	146.35	146.29	146.32	27937.0
2021-08-18 18:30:00	AAPL	Stock	146.32	146.44	146.31	146.44	16721.0
2021-08-18 19:00:00	AAPL	Stock	146.44	146.5	146.38	146.45	14021.0
2021-08-18 19:30:00	AAPL	Stock	146.45	146.5	146.295	146.36	51258.0
2021-08-18 04:00:00	MSFT	Stock	292.2	292.6	291.85	292.2	3331.0
2021-08-18 04:30:00	MSFT	Stock	292.2	292.5	292.15	292.39	1362.0
2021-08-18 05:00:00	MSFT	Stock	292.37	292.74	292.37	292.52	2003.0
2021-08-18 05:30:00	MSFT	Stock	292.51	292.55	292.5	292.5	2847.0
2021-08-18 06:00:00	MSFT	Stock	292.4	292.4	292.01	292.09	2226.0
2021-08-18 06:30:00	MSFT	Stock	292.56	292.87	292.53	292.87	1105.0
2021-08-18 07:00:00	MSFT	Stock	292.87	293.0	292.67	292.7	7627.0
2021-08-18 07:30:00	MSFT	Stock	292.7	292.7	292.17	292.4	6521.0
2021-08-18 08:00:00	MSFT	Stock	292.5	292.95	292.08	292.1	15042.0
2021-08-18 08:30:00	MSFT	Stock	292.09	292.27	292.0	292.1	16942.0
2021-08-18 09:00:00	MSFT	Stock	292.04	292.6253	291.74	291.84	13903.0
2021-08-18 09:30:00	MSFT	Stock	291.77	294.82	291.65	294.225	2061709.0
2021-08-18 10:00:00	MSFT	Stock	294.2	294.6	293.49	293.93	1014867.0
2021-08-18 10:30:00	MSFT	Stock	293.94	294.0	293.14	293.5376	848395.0
2021-08-18 11:00:00	MSFT	Stock	293.53	293.575	293.02	293.28	613326.0
2021-08-18 11:30:00	MSFT	Stock	293.27	293.68	292.74	293.46	671742.0
2021-08-18 12:00:00	MSFT	Stock	293.45	294.12	293.26	293.63	573200.0
2021-08-18 12:30:00	MSFT	Stock	293.64	293.83	293.15	293.41	461756.0

> showing 50 of 109,022 rows — these rows as CSV

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