PREVIEW / stock_30min / 2023-06-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-20.parquet
  size:    2.1 MB
  rows:    104,578
  symbols: 1,615

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-06-20 04:00:00	AAPL	Stock	184.77	184.77	184.11	184.13	10162.0
2023-06-20 04:30:00	AAPL	Stock	184.14	184.2	183.9	184.08	20212.0
2023-06-20 05:00:00	AAPL	Stock	184.15	184.25	184.07	184.13	4996.0
2023-06-20 05:30:00	AAPL	Stock	184.18	184.25	184.18	184.21	2631.0
2023-06-20 06:00:00	AAPL	Stock	184.25	184.35	184.17	184.17	3319.0
2023-06-20 06:30:00	AAPL	Stock	184.25	184.35	184.18	184.34	1910.0
2023-06-20 07:00:00	AAPL	Stock	184.35	184.4	184.05	184.08	22697.0
2023-06-20 07:30:00	AAPL	Stock	184.15	184.23	184.02	184.23	13117.0
2023-06-20 08:00:00	AAPL	Stock	184.39	184.4	183.71	184.28	66194.0
2023-06-20 08:30:00	AAPL	Stock	184.25	184.6	184.25	184.6	46479.0
2023-06-20 09:00:00	AAPL	Stock	184.67	184.68	183.9	184.49	184831.0
2023-06-20 09:30:00	AAPL	Stock	184.41	186.1	184.41	185.305	6361505.0
2023-06-20 10:00:00	AAPL	Stock	185.305	185.97	184.7	184.81	3491408.0
2023-06-20 10:30:00	AAPL	Stock	184.82	184.99	184.51	184.84	2540734.0
2023-06-20 11:00:00	AAPL	Stock	184.86	185.36	184.79	185.0601	2311982.0
2023-06-20 11:30:00	AAPL	Stock	185.07	185.24	184.91	184.98	1598035.0
2023-06-20 12:00:00	AAPL	Stock	184.98	185.6	184.9	185.555	2039241.0
2023-06-20 12:30:00	AAPL	Stock	185.55	186.09	185.49	185.74	2151325.0
2023-06-20 13:00:00	AAPL	Stock	185.745	186.04	185.53	185.93	1622258.0
2023-06-20 13:30:00	AAPL	Stock	185.92	186.03	185.47	185.55	1306575.0
2023-06-20 14:00:00	AAPL	Stock	185.54	185.81	185.415	185.77	1494004.0
2023-06-20 14:30:00	AAPL	Stock	185.77	185.845	185.22	185.4769	1389835.0
2023-06-20 15:00:00	AAPL	Stock	185.475	185.53	185.13	185.34	1615238.0
2023-06-20 15:30:00	AAPL	Stock	185.34	185.5	184.81	185.03	4143617.0
2023-06-20 16:00:00	AAPL	Stock	185.03	185.06	184.8	184.82	7125789.0
2023-06-20 16:30:00	AAPL	Stock	184.8107	185.01	184.77	184.79	28946.0
2023-06-20 17:00:00	AAPL	Stock	184.79	185.01	184.69	184.76	37468.0
2023-06-20 17:30:00	AAPL	Stock	184.79	184.84	184.73	184.82	5291.0
2023-06-20 18:00:00	AAPL	Stock	184.77	184.82	184.64	184.7	6767.0
2023-06-20 18:30:00	AAPL	Stock	184.78	184.79	184.67	184.7	8362.0
2023-06-20 19:00:00	AAPL	Stock	184.7	184.77	184.7	184.73	7923.0
2023-06-20 19:30:00	AAPL	Stock	184.77	184.86	184.71	184.85	14116.0
2023-06-20 04:00:00	MSFT	Stock	343.1	343.18	339.51	339.78	11391.0
2023-06-20 04:30:00	MSFT	Stock	339.53	339.53	339.12	339.3	5847.0
2023-06-20 05:00:00	MSFT	Stock	339.5	339.81	339.5	339.71	1443.0
2023-06-20 05:30:00	MSFT	Stock	339.69	339.81	339.51	339.81	3955.0
2023-06-20 06:00:00	MSFT	Stock	339.9	340.58	339.9	340.21	3479.0
2023-06-20 06:30:00	MSFT	Stock	340.5	340.71	340.11	340.71	1235.0
2023-06-20 07:00:00	MSFT	Stock	340.88	340.88	340.09	340.31	15105.0
2023-06-20 07:30:00	MSFT	Stock	340.25	340.5	340.2	340.3	6618.0
2023-06-20 08:00:00	MSFT	Stock	340.4	341.14	340.1	340.9	26222.0
2023-06-20 08:30:00	MSFT	Stock	340.89	341.28	340.5	341.28	9533.0
2023-06-20 09:00:00	MSFT	Stock	341.3	341.63	338.8	339.19	72422.0
2023-06-20 09:30:00	MSFT	Stock	339.27	342.08	338.6	339.3	2967141.0
2023-06-20 10:00:00	MSFT	Stock	339.25	340.06	336.24	336.38	1778019.0
2023-06-20 10:30:00	MSFT	Stock	336.4	337.52	335.86	336.807	1730241.0
2023-06-20 11:00:00	MSFT	Stock	336.8	337.8	336.66	336.94	974846.0
2023-06-20 11:30:00	MSFT	Stock	337.0	337.22	336.09	336.105	920601.0
2023-06-20 12:00:00	MSFT	Stock	336.1	338.565	336.0549	338.23	928230.0
2023-06-20 12:30:00	MSFT	Stock	338.24	339.385	338.19	339.04	731374.0

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

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