PREVIEW / stock_30min / 2021-06-03

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-03.parquet
  size:    2.2 MB
  rows:    112,989
  symbols: 2,943

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
2021-06-03 04:00:00	AAPL	Stock	124.88	124.88	124.62	124.75	3338.0
2021-06-03 04:30:00	AAPL	Stock	124.76	124.89	124.76	124.89	2628.0
2021-06-03 05:00:00	AAPL	Stock	124.89	124.89	124.71	124.71	2503.0
2021-06-03 05:30:00	AAPL	Stock	124.71	124.74	124.61	124.62	2378.0
2021-06-03 06:00:00	AAPL	Stock	124.66	124.66	124.42	124.62	3083.0
2021-06-03 06:30:00	AAPL	Stock	124.58	124.58	124.0	124.01	10163.0
2021-06-03 07:00:00	AAPL	Stock	124.12	124.45	123.84	124.06	151124.0
2021-06-03 07:30:00	AAPL	Stock	124.06	124.3	123.85	124.07	88155.0
2021-06-03 08:00:00	AAPL	Stock	124.06	124.748	123.81	124.06	349151.0
2021-06-03 08:30:00	AAPL	Stock	124.02	124.46	123.96	124.24	172980.0
2021-06-03 09:00:00	AAPL	Stock	124.24	124.8	124.15	124.65	205586.0
2021-06-03 09:30:00	AAPL	Stock	124.66	124.85	123.27	123.62	10269406.0
2021-06-03 10:00:00	AAPL	Stock	123.62	123.79	123.305	123.46	6270848.0
2021-06-03 10:30:00	AAPL	Stock	123.46	123.94	123.13	123.935	6138787.0
2021-06-03 11:00:00	AAPL	Stock	123.94	124.15	123.81	123.9	4371801.0
2021-06-03 11:30:00	AAPL	Stock	123.8981	123.965	123.55	123.71	3402778.0
2021-06-03 12:00:00	AAPL	Stock	123.71	123.85	123.4	123.5069	3056590.0
2021-06-03 12:30:00	AAPL	Stock	123.5	123.69	123.38	123.68	2265898.0
2021-06-03 13:00:00	AAPL	Stock	123.68	123.81	123.3	123.784	2357732.0
2021-06-03 13:30:00	AAPL	Stock	123.78	124.04	123.71	123.9001	2833480.0
2021-06-03 14:00:00	AAPL	Stock	123.9	124.09	123.73	123.749	2229679.0
2021-06-03 14:30:00	AAPL	Stock	123.74	123.845	123.6	123.64	2033479.0
2021-06-03 15:00:00	AAPL	Stock	123.64	123.89	123.6399	123.86	2707026.0
2021-06-03 15:30:00	AAPL	Stock	123.8605	123.915	123.39	123.54	5977124.0
2021-06-03 16:00:00	AAPL	Stock	123.54	123.54	123.45	123.5	5533984.0
2021-06-03 16:30:00	AAPL	Stock	123.5	123.5	123.47	123.47	23039.0
2021-06-03 17:00:00	AAPL	Stock	123.48	123.56	123.47	123.56	28179.0
2021-06-03 17:30:00	AAPL	Stock	123.56	123.58	123.54	123.58	11639.0
2021-06-03 18:00:00	AAPL	Stock	123.58	123.67	123.57	123.62	22278.0
2021-06-03 18:30:00	AAPL	Stock	123.61	123.65	123.54	123.54	20042.0
2021-06-03 19:00:00	AAPL	Stock	123.54	123.6	123.48	123.5	22965.0
2021-06-03 19:30:00	AAPL	Stock	123.5	123.6	123.43	123.54	63416.0
2021-06-03 04:00:00	MSFT	Stock	247.0	247.11	247.0	247.08	531.0
2021-06-03 04:30:00	MSFT	Stock	247.21	247.21	247.11	247.11	777.0
2021-06-03 05:00:00	MSFT	Stock	247.2	247.21	247.05	247.09	3424.0
2021-06-03 06:30:00	MSFT	Stock	246.77	246.77	245.68	245.68	1138.0
2021-06-03 07:00:00	MSFT	Stock	246.25	246.63	245.0	245.25	14331.0
2021-06-03 07:30:00	MSFT	Stock	245.16	245.65	245.0	245.0	17999.0
2021-06-03 08:00:00	MSFT	Stock	245.6616	246.75	244.8	245.35	24197.0
2021-06-03 08:30:00	MSFT	Stock	245.22	245.86	245.1	245.53	41939.0
2021-06-03 09:00:00	MSFT	Stock	245.69	246.39	245.2	245.2	32890.0
2021-06-03 09:30:00	MSFT	Stock	245.23	245.53	243.6	243.79	2460270.0
2021-06-03 10:00:00	MSFT	Stock	243.77	244.89	243.64	243.78	1647342.0
2021-06-03 10:30:00	MSFT	Stock	243.79	245.41	243.0	245.39	1648693.0
2021-06-03 11:00:00	MSFT	Stock	245.42	246.34	245.365	245.62	983523.0
2021-06-03 11:30:00	MSFT	Stock	245.62	245.77	244.93	245.4671	743514.0
2021-06-03 12:00:00	MSFT	Stock	245.47	245.73	244.9	245.3	621172.0
2021-06-03 12:30:00	MSFT	Stock	245.3	245.819	245.15	245.64	499186.0
2021-06-03 13:00:00	MSFT	Stock	245.65	245.75	244.43	245.72	507445.0
2021-06-03 13:30:00	MSFT	Stock	245.7	245.77	245.16	245.31	506860.0

> showing 50 of 112,989 rows — these rows as CSV

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