PREVIEW / stock_30min / 2022-01-31

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-31.parquet
  size:    2.2 MB
  rows:    109,847
  symbols: 2,610

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-01-31 04:00:00	AAPL	Stock	170.7	172.01	170.7	171.71	48280.0
2022-01-31 04:30:00	AAPL	Stock	171.68	171.91	171.32	171.55	14671.0
2022-01-31 05:00:00	AAPL	Stock	171.5	171.57	170.83	171.04	23273.0
2022-01-31 05:30:00	AAPL	Stock	170.89	170.9	170.08	170.33	149176.0
2022-01-31 06:00:00	AAPL	Stock	170.49	170.67	170.21	170.4	40079.0
2022-01-31 06:30:00	AAPL	Stock	170.45	170.82	170.42	170.61	23050.0
2022-01-31 07:00:00	AAPL	Stock	170.69	170.85	169.63	169.93	178465.0
2022-01-31 07:30:00	AAPL	Stock	169.94	170.37	169.8	170.3	120441.0
2022-01-31 08:00:00	AAPL	Stock	170.55	170.86	169.63	170.14	431629.0
2022-01-31 08:30:00	AAPL	Stock	170.23	170.77	170.0	170.57	358057.0
2022-01-31 09:00:00	AAPL	Stock	170.57	170.72	169.91	170.21	281094.0
2022-01-31 09:30:00	AAPL	Stock	170.2	172.9	169.51	172.52	15029411.0
2022-01-31 10:00:00	AAPL	Stock	172.53	173.62	172.53	172.62	9548071.0
2022-01-31 10:30:00	AAPL	Stock	172.61	173.14	172.27	173.08	6328952.0
2022-01-31 11:00:00	AAPL	Stock	173.07	173.36	172.39	172.57	5020923.0
2022-01-31 11:30:00	AAPL	Stock	172.565	173.58	172.38	173.295	4468870.0
2022-01-31 12:00:00	AAPL	Stock	173.3	173.335	172.35	172.635	4395277.0
2022-01-31 12:30:00	AAPL	Stock	172.63	173.0874	172.43	172.9708	2962240.0
2022-01-31 13:00:00	AAPL	Stock	172.98	173.06	172.7	173.03	3084570.0
2022-01-31 13:30:00	AAPL	Stock	173.035	173.545	172.8	173.28	3601317.0
2022-01-31 14:00:00	AAPL	Stock	173.28	173.74	173.2	173.62	3591474.0
2022-01-31 14:30:00	AAPL	Stock	173.62	173.62	173.155	173.4801	3501341.0
2022-01-31 15:00:00	AAPL	Stock	173.49	173.61	172.77	173.29	4915044.0
2022-01-31 15:30:00	AAPL	Stock	173.28	175.0	173.06	174.8	14652792.0
2022-01-31 16:00:00	AAPL	Stock	174.66	174.96	174.2	174.28	15141798.0
2022-01-31 16:30:00	AAPL	Stock	174.3	174.78	174.27	174.35	93899.0
2022-01-31 17:00:00	AAPL	Stock	174.35	174.4	174.26	174.27	45040.0
2022-01-31 17:30:00	AAPL	Stock	174.27	174.35	174.05	174.17	49732.0
2022-01-31 18:00:00	AAPL	Stock	174.19	174.49	174.19	174.31	46307.0
2022-01-31 18:30:00	AAPL	Stock	174.25	174.49	174.25	174.48	12075.0
2022-01-31 19:00:00	AAPL	Stock	174.48	174.48	174.3	174.4	11661.0
2022-01-31 19:30:00	AAPL	Stock	174.4	174.5	174.2	174.4	51677.0
2022-01-31 04:00:00	MSFT	Stock	310.0	310.58	309.5	309.57	4443.0
2022-01-31 04:30:00	MSFT	Stock	309.7	310.2	309.69	309.8	2262.0
2022-01-31 05:00:00	MSFT	Stock	309.53	309.53	308.8	309.1	2522.0
2022-01-31 05:30:00	MSFT	Stock	309.09	309.53	309.0	309.53	1361.0
2022-01-31 06:00:00	MSFT	Stock	309.49	309.9	308.59	308.6	4956.0
2022-01-31 06:30:00	MSFT	Stock	308.99	309.45	308.99	309.2	1099.0
2022-01-31 07:00:00	MSFT	Stock	309.44	309.44	307.0	307.5	33899.0
2022-01-31 07:30:00	MSFT	Stock	307.6	308.3	307.45	308.1	16888.0
2022-01-31 08:00:00	MSFT	Stock	309.5	309.5	307.05	308.0	24401.0
2022-01-31 08:30:00	MSFT	Stock	308.2	308.6999	307.82	308.48	23807.0
2022-01-31 09:00:00	MSFT	Stock	308.65	309.12	307.2561	308.98	56037.0
2022-01-31 09:30:00	MSFT	Stock	308.9	310.84	306.37	310.8	4478810.0
2022-01-31 10:00:00	MSFT	Stock	310.8	312.38	309.9	310.02	2618899.0
2022-01-31 10:30:00	MSFT	Stock	310.03	310.29	308.09	308.725	2000893.0
2022-01-31 11:00:00	MSFT	Stock	308.69	309.56	307.08	307.27	1713347.0
2022-01-31 11:30:00	MSFT	Stock	307.4	310.4	307.1476	309.74	1685525.0
2022-01-31 12:00:00	MSFT	Stock	309.76	309.86	307.59	308.29	1531148.0
2022-01-31 12:30:00	MSFT	Stock	308.2954	308.635	307.844	308.27	1192220.0

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

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