PREVIEW / stock_30min / 2023-05-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-17.parquet
  size:    2.1 MB
  rows:    101,431
  symbols: 1,677

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-05-17 04:00:00	AAPL	Stock	172.18	172.35	172.0	172.18	11526.0
2023-05-17 04:30:00	AAPL	Stock	172.1	172.2	172.09	172.2	1274.0
2023-05-17 05:00:00	AAPL	Stock	172.22	172.22	172.01	172.13	2611.0
2023-05-17 05:30:00	AAPL	Stock	172.12	172.15	172.1	172.15	3428.0
2023-05-17 06:00:00	AAPL	Stock	172.16	172.17	172.08	172.1	2623.0
2023-05-17 06:30:00	AAPL	Stock	172.11	172.13	171.99	172.11	9227.0
2023-05-17 07:00:00	AAPL	Stock	172.13	172.22	172.07	172.16	31495.0
2023-05-17 07:30:00	AAPL	Stock	172.15	172.18	171.93	172.01	66503.0
2023-05-17 08:00:00	AAPL	Stock	172.1987	172.29	170.8	171.1194	324976.0
2023-05-17 08:30:00	AAPL	Stock	171.09	171.55	171.05	171.51	126829.0
2023-05-17 09:00:00	AAPL	Stock	171.5783	171.97	171.25	171.75	156386.0
2023-05-17 09:30:00	AAPL	Stock	171.71	172.15	170.43	170.5299	6436411.0
2023-05-17 10:00:00	AAPL	Stock	170.52	171.2109	170.4201	171.0217	3593528.0
2023-05-17 10:30:00	AAPL	Stock	171.03	171.1599	170.8001	171.03	2295339.0
2023-05-17 11:00:00	AAPL	Stock	171.045	171.16	170.47	170.8467	2671772.0
2023-05-17 11:30:00	AAPL	Stock	170.84	171.27	170.73	171.07	2057183.0
2023-05-17 12:00:00	AAPL	Stock	171.07	171.16	170.83	171.135	1174713.0
2023-05-17 12:30:00	AAPL	Stock	171.14	171.74	170.96	171.6299	2407718.0
2023-05-17 13:00:00	AAPL	Stock	171.64	172.12	171.6	172.04	2478725.0
2023-05-17 13:30:00	AAPL	Stock	172.04	172.86	171.86	172.8286	3707383.0
2023-05-17 14:00:00	AAPL	Stock	172.825	172.85	172.24	172.4085	2479340.0
2023-05-17 14:30:00	AAPL	Stock	172.42	172.45	171.95	172.1285	1980380.0
2023-05-17 15:00:00	AAPL	Stock	172.13	172.59	171.94	172.35	2271619.0
2023-05-17 15:30:00	AAPL	Stock	172.36	172.925	172.32	172.65	4512919.0
2023-05-17 16:00:00	AAPL	Stock	172.63	172.75	172.6	172.69	7652301.0
2023-05-17 16:30:00	AAPL	Stock	172.68	172.71	172.64	172.7	31116.0
2023-05-17 17:00:00	AAPL	Stock	172.7	172.73	172.65	172.65	44958.0
2023-05-17 17:30:00	AAPL	Stock	172.6501	172.7	172.63	172.667	5536.0
2023-05-17 18:00:00	AAPL	Stock	172.67	172.67	172.61	172.6646	9307.0
2023-05-17 18:30:00	AAPL	Stock	172.6792	172.6792	172.6201	172.64	4194.0
2023-05-17 19:00:00	AAPL	Stock	172.64	172.68	172.61	172.64	4027.0
2023-05-17 19:30:00	AAPL	Stock	172.69	172.72	172.54	172.72	18799.0
2023-05-17 04:00:00	MSFT	Stock	311.72	311.72	311.41	311.41	454.0
2023-05-17 04:30:00	MSFT	Stock	311.4	311.49	311.4	311.49	1914.0
2023-05-17 05:00:00	MSFT	Stock	311.49	311.49	311.35	311.49	1252.0
2023-05-17 05:30:00	MSFT	Stock	311.49	311.6	311.42	311.6	1054.0
2023-05-17 06:00:00	MSFT	Stock	311.61	311.94	311.21	311.21	2607.0
2023-05-17 06:30:00	MSFT	Stock	311.22	311.25	310.93	310.93	1283.0
2023-05-17 07:00:00	MSFT	Stock	311.36	311.94	311.1	311.41	14582.0
2023-05-17 07:30:00	MSFT	Stock	311.48	311.55	311.3	311.5	4832.0
2023-05-17 08:00:00	MSFT	Stock	311.6	311.79	311.0	311.45	26935.0
2023-05-17 08:30:00	MSFT	Stock	311.34	311.94	311.24	311.9373	16754.0
2023-05-17 09:00:00	MSFT	Stock	311.9211	312.5	311.47	312.29	22738.0
2023-05-17 09:30:00	MSFT	Stock	312.29	313.11	311.43	311.75	2119869.0
2023-05-17 10:00:00	MSFT	Stock	311.68	311.87	311.07	311.225	1079045.0
2023-05-17 10:30:00	MSFT	Stock	311.23	312.0	311.1	311.8	748232.0
2023-05-17 11:00:00	MSFT	Stock	311.81	312.13	310.74	311.5	1129871.0
2023-05-17 11:30:00	MSFT	Stock	311.515	312.35	311.41	312.31	669950.0
2023-05-17 12:00:00	MSFT	Stock	312.29	312.52	311.87	312.41	459140.0
2023-05-17 12:30:00	MSFT	Stock	312.44	313.14	312.33	312.935	736063.0

> showing 50 of 101,431 rows — these rows as CSV

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