PREVIEW / stock_30min / 2022-08-01

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-01.parquet
  size:    2.1 MB
  rows:    105,922
  symbols: 2,350

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-01 04:00:00	AAPL	Stock	161.98	162.25	161.98	162.07	11616.0
2022-08-01 04:30:00	AAPL	Stock	162.08	162.15	161.79	162.01	9581.0
2022-08-01 05:00:00	AAPL	Stock	161.92	162.13	161.92	162.01	3670.0
2022-08-01 05:30:00	AAPL	Stock	161.97	162.16	161.95	162.16	11697.0
2022-08-01 06:00:00	AAPL	Stock	162.1	162.19	162.09	162.09	604.0
2022-08-01 06:30:00	AAPL	Stock	162.12	162.12	162.01	162.1	7682.0
2022-08-01 07:00:00	AAPL	Stock	162.05	162.2	162.0	162.12	27834.0
2022-08-01 07:30:00	AAPL	Stock	162.08	162.3	162.01	162.06	35595.0
2022-08-01 08:00:00	AAPL	Stock	162.09	162.3	161.0	161.86	323409.0
2022-08-01 08:30:00	AAPL	Stock	161.88	161.95	161.2	161.2	380062.0
2022-08-01 09:00:00	AAPL	Stock	161.2	161.35	160.85	161.02	352392.0
2022-08-01 09:30:00	AAPL	Stock	161.01	163.11	161.01	162.768	8763616.0
2022-08-01 10:00:00	AAPL	Stock	162.74	163.38	162.1805	162.42	4939519.0
2022-08-01 10:30:00	AAPL	Stock	162.4365	163.59	162.39	163.2	4032837.0
2022-08-01 11:00:00	AAPL	Stock	163.22	163.37	162.705	163.2959	3213433.0
2022-08-01 11:30:00	AAPL	Stock	163.32	163.34	162.76	163.16	2214310.0
2022-08-01 12:00:00	AAPL	Stock	163.19	163.2382	162.35	162.4096	2516236.0
2022-08-01 12:30:00	AAPL	Stock	162.41	162.6	161.95	162.1001	2134251.0
2022-08-01 13:00:00	AAPL	Stock	162.11	162.13	161.5	161.545	2565379.0
2022-08-01 13:30:00	AAPL	Stock	161.52	161.67	160.89	161.35	2844155.0
2022-08-01 14:00:00	AAPL	Stock	161.355	161.7	160.99	161.61	2188062.0
2022-08-01 14:30:00	AAPL	Stock	161.61	162.2499	161.515	162.175	2930973.0
2022-08-01 15:00:00	AAPL	Stock	162.17	162.25	161.45	161.56	2592205.0
2022-08-01 15:30:00	AAPL	Stock	161.545	161.86	161.19	161.57	5262207.0
2022-08-01 16:00:00	AAPL	Stock	161.57	161.75	161.51	161.51	5804454.0
2022-08-01 16:30:00	AAPL	Stock	161.51	161.65	161.47	161.6044	18849.0
2022-08-01 17:00:00	AAPL	Stock	161.61	161.77	161.56	161.62	14039.0
2022-08-01 17:30:00	AAPL	Stock	161.6979	161.7	161.6	161.6231	21173.0
2022-08-01 18:00:00	AAPL	Stock	161.61	161.61	161.5	161.52	7062.0
2022-08-01 18:30:00	AAPL	Stock	161.51	161.58	161.35	161.46	9076.0
2022-08-01 19:00:00	AAPL	Stock	161.42	161.61	161.42	161.53	8355.0
2022-08-01 19:30:00	AAPL	Stock	161.42	161.44	161.31	161.4	16566.0
2022-08-01 04:00:00	MSFT	Stock	282.0	282.0	280.01	280.01	2098.0
2022-08-01 04:30:00	MSFT	Stock	280.18	280.18	279.95	279.95	1900.0
2022-08-01 05:00:00	MSFT	Stock	279.8	280.0	279.71	279.74	3856.0
2022-08-01 05:30:00	MSFT	Stock	280.05	280.05	279.99	279.99	249.0
2022-08-01 06:00:00	MSFT	Stock	279.84	279.93	279.84	279.93	1146.0
2022-08-01 06:30:00	MSFT	Stock	279.54	279.54	279.52	279.52	210.0
2022-08-01 07:00:00	MSFT	Stock	279.9	280.0	278.72	279.65	24633.0
2022-08-01 07:30:00	MSFT	Stock	279.66	280.09	279.5	279.75	9369.0
2022-08-01 08:00:00	MSFT	Stock	279.97	280.09	278.77	279.19	20687.0
2022-08-01 08:30:00	MSFT	Stock	279.38	279.38	278.63	278.84	41416.0
2022-08-01 09:00:00	MSFT	Stock	278.83	278.83	277.5	277.89	40664.0
2022-08-01 09:30:00	MSFT	Stock	277.93	279.0	276.7431	278.7	2198329.0
2022-08-01 10:00:00	MSFT	Stock	278.55	280.08	277.73	278.05	1321804.0
2022-08-01 10:30:00	MSFT	Stock	278.07	281.21	278.04	281.1101	1181879.0
2022-08-01 11:00:00	MSFT	Stock	281.12	281.28	279.86	280.89	821185.0
2022-08-01 11:30:00	MSFT	Stock	280.92	280.92	279.8672	280.34	579948.0
2022-08-01 12:00:00	MSFT	Stock	280.35	280.48	278.73	279.1637	806484.0
2022-08-01 12:30:00	MSFT	Stock	279.18	279.32	278.22	278.75	537830.0

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

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