PREVIEW / stock_30min / 2023-01-04

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-04.parquet
  size:    2.1 MB
  rows:    103,251
  symbols: 1,959

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
2023-01-04 04:00:00	AAPL	Stock	125.9	126.4	125.66	126.15	56644.0
2023-01-04 04:30:00	AAPL	Stock	126.1	126.4	126.07	126.24	16050.0
2023-01-04 05:00:00	AAPL	Stock	126.21	126.68	126.2	126.35	17176.0
2023-01-04 05:30:00	AAPL	Stock	126.37	126.48	125.91	126.15	23915.0
2023-01-04 06:00:00	AAPL	Stock	126.13	126.37	126.13	126.35	8812.0
2023-01-04 06:30:00	AAPL	Stock	126.24	126.5	126.24	126.3	20138.0
2023-01-04 07:00:00	AAPL	Stock	126.25	126.25	125.7	125.9	63908.0
2023-01-04 07:30:00	AAPL	Stock	125.88	126.08	125.53	125.86	55361.0
2023-01-04 08:00:00	AAPL	Stock	126.071	126.56	125.38	126.3	322206.0
2023-01-04 08:30:00	AAPL	Stock	126.31	126.66	126.04	126.33	197664.0
2023-01-04 09:00:00	AAPL	Stock	126.28	127.0	126.0	126.85	398867.0
2023-01-04 09:30:00	AAPL	Stock	126.89	127.555	125.94	126.66	12235650.0
2023-01-04 10:00:00	AAPL	Stock	126.64	127.34	125.08	125.9983	7950838.0
2023-01-04 10:30:00	AAPL	Stock	125.99	127.02	125.334	126.99	5221475.0
2023-01-04 11:00:00	AAPL	Stock	126.96	127.5	126.5	127.38	4342270.0
2023-01-04 11:30:00	AAPL	Stock	127.39	128.44	127.38	127.77	5156753.0
2023-01-04 12:00:00	AAPL	Stock	127.77	128.6557	127.72	128.065	3356451.0
2023-01-04 12:30:00	AAPL	Stock	128.075	128.22	127.23	127.23	2395241.0
2023-01-04 13:00:00	AAPL	Stock	127.235	127.5	126.93	127.2601	2406899.0
2023-01-04 13:30:00	AAPL	Stock	127.265	127.4884	127.07	127.191	2034488.0
2023-01-04 14:00:00	AAPL	Stock	127.17	127.87	125.62	125.725	6493246.0
2023-01-04 14:30:00	AAPL	Stock	125.72	126.51	125.38	126.4734	4878938.0
2023-01-04 15:00:00	AAPL	Stock	126.47	126.85	125.82	125.8399	4097684.0
2023-01-04 15:30:00	AAPL	Stock	125.82	126.48	125.28	126.38	7478781.0
2023-01-04 16:00:00	AAPL	Stock	126.38	126.68	126.17	126.2	7404686.0
2023-01-04 16:30:00	AAPL	Stock	126.2	126.36	126.15	126.17	58334.0
2023-01-04 17:00:00	AAPL	Stock	126.18	127.6	126.11	127.42	202264.0
2023-01-04 17:30:00	AAPL	Stock	127.28	127.74	127.2	127.54	97908.0
2023-01-04 18:00:00	AAPL	Stock	127.52	127.52	126.36	127.15	97016.0
2023-01-04 18:30:00	AAPL	Stock	127.16	127.22	127.0	127.0	44007.0
2023-01-04 19:00:00	AAPL	Stock	127.01	127.08	126.75	126.99	37844.0
2023-01-04 19:30:00	AAPL	Stock	127.03	127.05	126.61	126.65	34426.0
2023-01-04 04:00:00	MSFT	Stock	236.98	241.0	235.32	235.32	68195.0
2023-01-04 04:30:00	MSFT	Stock	235.3	235.82	234.64	234.8	20084.0
2023-01-04 05:00:00	MSFT	Stock	234.85	235.0	234.8	234.85	13619.0
2023-01-04 05:30:00	MSFT	Stock	234.8	234.84	234.01	234.34	10428.0
2023-01-04 06:00:00	MSFT	Stock	234.57	235.0	234.51	234.51	8234.0
2023-01-04 06:30:00	MSFT	Stock	234.42	235.0	234.38	235.0	16051.0
2023-01-04 07:00:00	MSFT	Stock	235.0	235.4	234.1	234.26	55156.0
2023-01-04 07:30:00	MSFT	Stock	234.32	234.45	232.81	233.34	48264.0
2023-01-04 08:00:00	MSFT	Stock	234.9996	238.982	232.96	233.78	107596.0
2023-01-04 08:30:00	MSFT	Stock	233.96	234.0	232.7	232.83	121986.0
2023-01-04 09:00:00	MSFT	Stock	232.86	233.91	231.9	232.02	234184.0
2023-01-04 09:30:00	MSFT	Stock	232.02	232.87	228.295	229.01	6123308.0
2023-01-04 10:00:00	MSFT	Stock	228.98	229.47	226.0	227.15	4665712.0
2023-01-04 10:30:00	MSFT	Stock	227.14	228.5814	226.265	227.58	2703871.0
2023-01-04 11:00:00	MSFT	Stock	227.555	228.29	226.73	228.1323	2680228.0
2023-01-04 11:30:00	MSFT	Stock	228.17	229.7999	228.17	228.85	2528516.0
2023-01-04 12:00:00	MSFT	Stock	228.86	229.76	228.36	229.015	1694470.0
2023-01-04 12:30:00	MSFT	Stock	229.015	229.65	227.96	227.97	1288014.0

> showing 50 of 103,251 rows — these rows as CSV

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