PREVIEW / stock_30min / 2022-10-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-10-14.parquet
  size:    2.0 MB
  rows:    100,340
  symbols: 2,123

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-10-14 04:00:00	AAPL	Stock	143.0	143.3	142.33	142.33	33519.0
2022-10-14 04:30:00	AAPL	Stock	142.38	142.6	141.8	141.81	23493.0
2022-10-14 05:00:00	AAPL	Stock	141.81	142.29	141.68	141.91	22434.0
2022-10-14 05:30:00	AAPL	Stock	141.9	142.43	141.7	142.37	21273.0
2022-10-14 06:00:00	AAPL	Stock	142.39	143.19	142.37	143.01	28620.0
2022-10-14 06:30:00	AAPL	Stock	143.13	143.25	142.8	143.2	17098.0
2022-10-14 07:00:00	AAPL	Stock	143.2	143.38	143.01	143.15	42095.0
2022-10-14 07:30:00	AAPL	Stock	143.0	143.06	142.1	142.11	63400.0
2022-10-14 08:00:00	AAPL	Stock	143.01	143.3893	141.7715	142.44	146751.0
2022-10-14 08:30:00	AAPL	Stock	142.55	144.66	142.11	144.1	386737.0
2022-10-14 09:00:00	AAPL	Stock	144.12	144.5	143.62	144.31	345154.0
2022-10-14 09:30:00	AAPL	Stock	144.31	144.52	141.39	142.135	11872212.0
2022-10-14 10:00:00	AAPL	Stock	142.12	142.13	139.97	140.64	8263158.0
2022-10-14 10:30:00	AAPL	Stock	140.63	140.82	139.51	140.3158	5818117.0
2022-10-14 11:00:00	AAPL	Stock	140.34	140.94	139.59	140.38	4398781.0
2022-10-14 11:30:00	AAPL	Stock	140.39	140.41	139.24	139.64	4099971.0
2022-10-14 12:00:00	AAPL	Stock	139.64	140.21	138.98	139.4501	3310893.0
2022-10-14 12:30:00	AAPL	Stock	139.44	139.93	139.09	139.13	2392505.0
2022-10-14 13:00:00	AAPL	Stock	139.14	139.64	138.95	139.25	2709993.0
2022-10-14 13:30:00	AAPL	Stock	139.265	139.574	139.17	139.5	2425640.0
2022-10-14 14:00:00	AAPL	Stock	139.5	139.51	138.5	138.74	3451478.0
2022-10-14 14:30:00	AAPL	Stock	138.73	138.86	138.39	138.805	3344123.0
2022-10-14 15:00:00	AAPL	Stock	138.81	139.18	138.31	138.825	4656971.0
2022-10-14 15:30:00	AAPL	Stock	138.82	139.11	138.19	138.38	10611250.0
2022-10-14 16:00:00	AAPL	Stock	138.38	138.55	138.2	138.52	11036136.0
2022-10-14 16:30:00	AAPL	Stock	138.5	138.55	138.32	138.41	181699.0
2022-10-14 17:00:00	AAPL	Stock	138.42	138.48	138.25	138.28	44472.0
2022-10-14 17:30:00	AAPL	Stock	138.31	138.38	138.26	138.36	14206.0
2022-10-14 18:00:00	AAPL	Stock	138.36	138.36	138.09	138.19	28565.0
2022-10-14 18:30:00	AAPL	Stock	138.19	138.2	138.04	138.07	15701.0
2022-10-14 19:00:00	AAPL	Stock	138.07	138.08	138.0	138.05	12931.0
2022-10-14 19:30:00	AAPL	Stock	138.03	138.1	138.03	138.08	26695.0
2022-10-14 04:00:00	MSFT	Stock	233.72	233.72	233.72	233.72	100.0
2022-10-14 04:30:00	MSFT	Stock	232.89	232.89	232.46	232.47	613.0
2022-10-14 05:00:00	MSFT	Stock	232.38	232.69	232.2	232.54	600.0
2022-10-14 05:30:00	MSFT	Stock	232.3	233.0	232.1	233.0	2190.0
2022-10-14 06:00:00	MSFT	Stock	233.18	234.8	233.18	234.8	2607.0
2022-10-14 06:30:00	MSFT	Stock	234.59	234.59	234.14	234.14	1540.0
2022-10-14 07:00:00	MSFT	Stock	234.41	234.89	234.0	234.5	8108.0
2022-10-14 07:30:00	MSFT	Stock	234.02	234.04	232.51	232.51	8547.0
2022-10-14 08:00:00	MSFT	Stock	234.0202	234.92	232.51	233.9	19760.0
2022-10-14 08:30:00	MSFT	Stock	234.15	236.938	233.0	236.02	68598.0
2022-10-14 09:00:00	MSFT	Stock	236.28	236.3	235.0	235.51	66023.0
2022-10-14 09:30:00	MSFT	Stock	235.69	237.24	233.765	234.18	3152088.0
2022-10-14 10:00:00	MSFT	Stock	234.11	234.16	230.31	231.86	2115615.0
2022-10-14 10:30:00	MSFT	Stock	231.77	232.35	230.31	231.5	1355324.0
2022-10-14 11:00:00	MSFT	Stock	231.51	232.985	230.9232	231.94	1225788.0
2022-10-14 11:30:00	MSFT	Stock	231.9387	231.98	229.91	230.254	1033447.0
2022-10-14 12:00:00	MSFT	Stock	230.19	230.99	229.02	230.08	1121186.0
2022-10-14 12:30:00	MSFT	Stock	230.0899	230.58	229.56	229.79	696990.0

> showing 50 of 100,340 rows — these rows as CSV

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