PREVIEW / stock_30min / 2022-02-17

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-02-17.parquet
  size:    2.1 MB
  rows:    105,869
  symbols: 2,517

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-02-17 04:00:00	AAPL	Stock	172.0	172.0	171.29	171.46	10031.0
2022-02-17 04:30:00	AAPL	Stock	171.64	171.64	171.3	171.42	3082.0
2022-02-17 05:00:00	AAPL	Stock	171.45	171.55	171.4	171.5	2835.0
2022-02-17 05:30:00	AAPL	Stock	171.59	171.6	171.58	171.58	1564.0
2022-02-17 06:00:00	AAPL	Stock	171.45	171.45	171.45	171.45	214.0
2022-02-17 06:30:00	AAPL	Stock	171.42	171.5	171.42	171.5	969.0
2022-02-17 07:00:00	AAPL	Stock	171.5	171.92	171.42	171.68	18117.0
2022-02-17 07:30:00	AAPL	Stock	171.75	172.0	171.75	171.9	25863.0
2022-02-17 08:00:00	AAPL	Stock	171.7701	172.19	171.4	171.5	283737.0
2022-02-17 08:30:00	AAPL	Stock	171.56	171.67	170.9	171.1	217438.0
2022-02-17 09:00:00	AAPL	Stock	171.1	172.55	170.84	171.1	196790.0
2022-02-17 09:30:00	AAPL	Stock	171.15	171.72	170.74	171.2006	6129738.0
2022-02-17 10:00:00	AAPL	Stock	171.2	171.91	170.86	170.92	4832004.0
2022-02-17 10:30:00	AAPL	Stock	170.92	171.62	170.84	171.3401	3757998.0
2022-02-17 11:00:00	AAPL	Stock	171.34	171.5	171.17	171.305	2468520.0
2022-02-17 11:30:00	AAPL	Stock	171.31	171.6	171.0	171.2	2468585.0
2022-02-17 12:00:00	AAPL	Stock	171.205	171.2614	170.755	171.05	2201651.0
2022-02-17 12:30:00	AAPL	Stock	171.05	171.19	170.78	170.99	1675627.0
2022-02-17 13:00:00	AAPL	Stock	170.99	171.055	170.41	170.645	2164417.0
2022-02-17 13:30:00	AAPL	Stock	170.63	170.73	170.19	170.43	1886498.0
2022-02-17 14:00:00	AAPL	Stock	170.4299	170.43	169.75	169.805	2877591.0
2022-02-17 14:30:00	AAPL	Stock	169.8	169.873	169.31	169.51	3263039.0
2022-02-17 15:00:00	AAPL	Stock	169.51	169.53	168.895	169.21	4128436.0
2022-02-17 15:30:00	AAPL	Stock	169.21	169.54	168.47	168.92	9117960.0
2022-02-17 16:00:00	AAPL	Stock	168.92	171.5805	168.75	168.95	10846463.0
2022-02-17 16:30:00	AAPL	Stock	168.9599	169.15	168.88	169.03	109522.0
2022-02-17 17:00:00	AAPL	Stock	169.03	169.11	168.9	168.96	21870.0
2022-02-17 17:30:00	AAPL	Stock	168.96	169.0	168.81	168.95	32276.0
2022-02-17 18:00:00	AAPL	Stock	168.95	169.09	168.75	169.03	43161.0
2022-02-17 18:30:00	AAPL	Stock	169.05	169.15	168.99	169.06	21984.0
2022-02-17 19:00:00	AAPL	Stock	169.05	169.11	168.9	168.97	16531.0
2022-02-17 19:30:00	AAPL	Stock	168.94	168.96	168.52	168.84	37933.0
2022-02-17 04:00:00	MSFT	Stock	297.28	297.57	297.0	297.57	2617.0
2022-02-17 04:30:00	MSFT	Stock	297.61	297.61	297.22	297.3	4118.0
2022-02-17 05:00:00	MSFT	Stock	297.4	297.4	297.4	297.4	619.0
2022-02-17 05:30:00	MSFT	Stock	297.54	297.8	297.52	297.8	2196.0
2022-02-17 06:00:00	MSFT	Stock	297.46	297.46	297.46	297.46	101.0
2022-02-17 06:30:00	MSFT	Stock	297.4	297.6	297.3	297.55	971.0
2022-02-17 07:00:00	MSFT	Stock	297.5	298.25	297.5	297.99	10149.0
2022-02-17 07:30:00	MSFT	Stock	298.07	298.44	297.9	298.25	6586.0
2022-02-17 08:00:00	MSFT	Stock	298.0	298.45	297.1	297.53	29674.0
2022-02-17 08:30:00	MSFT	Stock	297.62	297.75	295.8	296.0	26469.0
2022-02-17 09:00:00	MSFT	Stock	296.2	299.5	295.46	296.16	50001.0
2022-02-17 09:30:00	MSFT	Stock	296.26	296.8	294.41	294.9799	2110810.0
2022-02-17 10:00:00	MSFT	Stock	294.975	295.26	293.54	293.975	1476415.0
2022-02-17 10:30:00	MSFT	Stock	293.96	294.5466	293.58	294.43	1447414.0
2022-02-17 11:00:00	MSFT	Stock	294.425	295.32	294.22	294.96	1088280.0
2022-02-17 11:30:00	MSFT	Stock	294.98	295.36	294.431	294.61	902545.0
2022-02-17 12:00:00	MSFT	Stock	294.61	294.85	293.22	293.83	997789.0
2022-02-17 12:30:00	MSFT	Stock	293.83	294.5	293.73	294.0	750024.0

> showing 50 of 105,869 rows — these rows as CSV

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