PREVIEW / stock_30min / 2022-03-31

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-03-31.parquet
  size:    2.2 MB
  rows:    110,326
  symbols: 2,546

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-03-31 04:00:00	AAPL	Stock	178.4	179.01	178.08	178.36	15997.0
2022-03-31 04:30:00	AAPL	Stock	178.36	178.6	178.3	178.55	10590.0
2022-03-31 05:00:00	AAPL	Stock	178.44	178.5	178.4	178.45	5153.0
2022-03-31 05:30:00	AAPL	Stock	178.4	178.47	178.39	178.43	3346.0
2022-03-31 06:00:00	AAPL	Stock	178.42	178.5	178.3	178.3	3582.0
2022-03-31 06:30:00	AAPL	Stock	178.33	178.4	178.29	178.32	4372.0
2022-03-31 07:00:00	AAPL	Stock	178.34	178.34	177.75	177.8	43972.0
2022-03-31 07:30:00	AAPL	Stock	177.81	178.25	177.81	178.21	50324.0
2022-03-31 08:00:00	AAPL	Stock	177.9604	178.89	177.326	178.33	255669.0
2022-03-31 08:30:00	AAPL	Stock	178.3	178.6	177.95	178.15	246140.0
2022-03-31 09:00:00	AAPL	Stock	178.1299	178.18	177.6	177.85	219234.0
2022-03-31 09:30:00	AAPL	Stock	177.87	178.03	175.6119	176.24	10063697.0
2022-03-31 10:00:00	AAPL	Stock	176.24	176.53	175.529	176.2259	5696106.0
2022-03-31 10:30:00	AAPL	Stock	176.225	177.17	176.18	176.94	4928644.0
2022-03-31 11:00:00	AAPL	Stock	176.95	176.98	176.3501	176.47	3420718.0
2022-03-31 11:30:00	AAPL	Stock	176.465	177.11	176.38	177.09	2881819.0
2022-03-31 12:00:00	AAPL	Stock	177.095	177.25	176.5293	176.74	2770903.0
2022-03-31 12:30:00	AAPL	Stock	176.7483	176.85	176.45	176.54	2225285.0
2022-03-31 13:00:00	AAPL	Stock	176.5216	176.74	176.14	176.61	2788410.0
2022-03-31 13:30:00	AAPL	Stock	176.6079	176.99	176.34	176.629	2683768.0
2022-03-31 14:00:00	AAPL	Stock	176.625	176.66	176.23	176.425	2948207.0
2022-03-31 14:30:00	AAPL	Stock	176.425	176.92	176.315	176.905	3151057.0
2022-03-31 15:00:00	AAPL	Stock	176.905	177.24	176.35	176.465	4371423.0
2022-03-31 15:30:00	AAPL	Stock	176.46	176.48	174.4	174.68	18625979.0
2022-03-31 16:00:00	AAPL	Stock	174.61	175.1	174.5	174.81	20574753.0
2022-03-31 16:30:00	AAPL	Stock	174.82	175.04	174.61	174.83	186262.0
2022-03-31 17:00:00	AAPL	Stock	174.87	174.94	174.75	174.84	78683.0
2022-03-31 17:30:00	AAPL	Stock	174.81	174.85	174.63	174.69	70945.0
2022-03-31 18:00:00	AAPL	Stock	174.7	174.86	174.65	174.65	37432.0
2022-03-31 18:30:00	AAPL	Stock	174.66	174.8	174.66	174.8	28069.0
2022-03-31 19:00:00	AAPL	Stock	174.78	174.95	174.78	174.9	10403.0
2022-03-31 19:30:00	AAPL	Stock	174.92	175.0	174.8	174.86	33294.0
2022-03-31 04:00:00	MSFT	Stock	315.0	315.3	315.0	315.3	706.0
2022-03-31 04:30:00	MSFT	Stock	315.0	315.1	315.0	315.0	1569.0
2022-03-31 05:00:00	MSFT	Stock	315.07	315.34	315.07	315.34	1893.0
2022-03-31 05:30:00	MSFT	Stock	315.4	315.41	315.2	315.2	1399.0
2022-03-31 06:00:00	MSFT	Stock	315.1	315.1	314.83	314.83	694.0
2022-03-31 06:30:00	MSFT	Stock	314.71	314.71	314.7	314.7	884.0
2022-03-31 07:00:00	MSFT	Stock	314.98	314.98	314.11	314.2	8880.0
2022-03-31 07:30:00	MSFT	Stock	314.17	314.89	314.13	314.87	5457.0
2022-03-31 08:00:00	MSFT	Stock	315.0	315.06	313.076	314.67	16206.0
2022-03-31 08:30:00	MSFT	Stock	314.87	315.1	314.2	314.95	29010.0
2022-03-31 09:00:00	MSFT	Stock	314.51	314.81	313.97	313.97	14948.0
2022-03-31 09:30:00	MSFT	Stock	314.01	315.14	311.29	311.885	2165937.0
2022-03-31 10:00:00	MSFT	Stock	311.86	312.67	310.9801	311.98	1442566.0
2022-03-31 10:30:00	MSFT	Stock	311.99	313.86	311.83	313.32	1215931.0
2022-03-31 11:00:00	MSFT	Stock	313.32	313.77	311.9344	312.13	832051.0
2022-03-31 11:30:00	MSFT	Stock	312.17	313.14	311.92	312.39	675496.0
2022-03-31 12:00:00	MSFT	Stock	312.39	312.5	311.14	311.37	502022.0
2022-03-31 12:30:00	MSFT	Stock	311.37	311.59	310.58	310.83	638197.0

> showing 50 of 110,326 rows — these rows as CSV

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