PREVIEW / stock_30min / 2022-08-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-18.parquet
  size:    2.1 MB
  rows:    104,679
  symbols: 2,237

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-08-18 04:00:00	AAPL	Stock	173.81	173.81	173.25	173.34	43409.0
2022-08-18 04:30:00	AAPL	Stock	173.34	173.69	173.28	173.63	22050.0
2022-08-18 05:00:00	AAPL	Stock	173.54	173.94	173.54	173.94	9445.0
2022-08-18 05:30:00	AAPL	Stock	173.9	174.15	173.9	174.1	3819.0
2022-08-18 06:00:00	AAPL	Stock	174.15	174.2	173.9	174.0	11117.0
2022-08-18 06:30:00	AAPL	Stock	173.91	174.15	173.8	173.95	16846.0
2022-08-18 07:00:00	AAPL	Stock	173.98	174.17	173.86	173.92	32822.0
2022-08-18 07:30:00	AAPL	Stock	173.89	174.25	173.89	174.13	34345.0
2022-08-18 08:00:00	AAPL	Stock	173.91	174.39	172.52	174.09	264203.0
2022-08-18 08:30:00	AAPL	Stock	174.1	174.1	173.77	173.94	192448.0
2022-08-18 09:00:00	AAPL	Stock	173.94	174.13	173.4	173.7	330923.0
2022-08-18 09:30:00	AAPL	Stock	173.74	174.56	173.23	173.415	7887451.0
2022-08-18 10:00:00	AAPL	Stock	173.4	173.965	173.12	173.63	4278510.0
2022-08-18 10:30:00	AAPL	Stock	173.62	174.35	173.4501	174.012	3211647.0
2022-08-18 11:00:00	AAPL	Stock	174.02	174.41	173.58	174.4	2730149.0
2022-08-18 11:30:00	AAPL	Stock	174.41	174.72	174.3	174.3501	2853809.0
2022-08-18 12:00:00	AAPL	Stock	174.37	174.64	173.81	174.03	2889126.0
2022-08-18 12:30:00	AAPL	Stock	174.0331	174.15	173.56	173.98	2366725.0
2022-08-18 13:00:00	AAPL	Stock	173.975	174.5	173.79	174.4086	2692641.0
2022-08-18 13:30:00	AAPL	Stock	174.41	174.54	174.18	174.32	2013997.0
2022-08-18 14:00:00	AAPL	Stock	174.31	174.49	174.15	174.2599	2415005.0
2022-08-18 14:30:00	AAPL	Stock	174.255	174.4	173.93	174.2599	2716071.0
2022-08-18 15:00:00	AAPL	Stock	174.26	174.865	174.17	174.7391	4481495.0
2022-08-18 15:30:00	AAPL	Stock	174.74	174.9	173.91	174.18	6817249.0
2022-08-18 16:00:00	AAPL	Stock	174.16	174.22	174.0	174.08	4331028.0
2022-08-18 16:30:00	AAPL	Stock	174.09	174.25	174.02	174.1	27880.0
2022-08-18 17:00:00	AAPL	Stock	174.1	174.15	174.06	174.12	13940.0
2022-08-18 17:30:00	AAPL	Stock	174.12	174.13	173.85	174.01	40688.0
2022-08-18 18:00:00	AAPL	Stock	174.01	174.04	173.88	174.02	14641.0
2022-08-18 18:30:00	AAPL	Stock	174.0	174.02	173.88	173.95	21664.0
2022-08-18 19:00:00	AAPL	Stock	173.87	174.0	173.87	173.92	8275.0
2022-08-18 19:30:00	AAPL	Stock	173.93	174.12	173.93	174.11	18117.0
2022-08-18 04:00:00	MSFT	Stock	290.05	290.35	289.58	289.82	2236.0
2022-08-18 04:30:00	MSFT	Stock	289.65	290.5	289.59	290.49	1600.0
2022-08-18 05:00:00	MSFT	Stock	290.5	290.71	290.37	290.71	806.0
2022-08-18 05:30:00	MSFT	Stock	290.8	290.8	290.8	290.8	100.0
2022-08-18 06:00:00	MSFT	Stock	291.32	291.32	291.32	291.32	190.0
2022-08-18 06:30:00	MSFT	Stock	291.5	291.5	291.5	291.5	300.0
2022-08-18 07:00:00	MSFT	Stock	291.1	291.48	291.1	291.13	5535.0
2022-08-18 07:30:00	MSFT	Stock	291.3	291.55	291.3	291.5	5065.0
2022-08-18 08:00:00	MSFT	Stock	291.5	292.19	289.64	291.9	18504.0
2022-08-18 08:30:00	MSFT	Stock	291.81	291.85	291.5	291.52	12366.0
2022-08-18 09:00:00	MSFT	Stock	291.71	291.71	290.0	290.1	33638.0
2022-08-18 09:30:00	MSFT	Stock	290.43	290.79	289.66	289.915	1160078.0
2022-08-18 10:00:00	MSFT	Stock	289.99	290.55	289.08	289.9399	809926.0
2022-08-18 10:30:00	MSFT	Stock	289.92	290.92	289.6226	290.48	802746.0
2022-08-18 11:00:00	MSFT	Stock	290.5	291.24	289.9	291.18	633954.0
2022-08-18 11:30:00	MSFT	Stock	291.22	291.6	290.96	291.1301	505597.0
2022-08-18 12:00:00	MSFT	Stock	291.17	291.55	290.29	290.59	579273.0
2022-08-18 12:30:00	MSFT	Stock	290.59	290.79	290.15	290.7386	375768.0

> showing 50 of 104,679 rows — these rows as CSV

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