PREVIEW / stock_30min / 2023-02-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-17.parquet
  size:    2.1 MB
  rows:    101,233
  symbols: 1,820

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-02-17 04:00:00	AAPL	Stock	152.8	152.8	151.85	152.4	28362.0
2023-02-17 04:30:00	AAPL	Stock	152.4	152.53	152.12	152.12	18224.0
2023-02-17 05:00:00	AAPL	Stock	152.19	152.3	152.01	152.27	7886.0
2023-02-17 05:30:00	AAPL	Stock	152.16	152.2	152.02	152.02	3942.0
2023-02-17 06:00:00	AAPL	Stock	152.01	152.1	151.86	152.1	19338.0
2023-02-17 06:30:00	AAPL	Stock	152.02	152.1	151.86	152.07	7668.0
2023-02-17 07:00:00	AAPL	Stock	152.12	152.26	152.1	152.1	20472.0
2023-02-17 07:30:00	AAPL	Stock	152.11	152.5	152.11	152.38	16846.0
2023-02-17 08:00:00	AAPL	Stock	152.22	152.99	152.0	152.1	116784.0
2023-02-17 08:30:00	AAPL	Stock	152.12	152.6	152.11	152.5	68999.0
2023-02-17 09:00:00	AAPL	Stock	152.5	153.39	152.07	152.39	237191.0
2023-02-17 09:30:00	AAPL	Stock	152.35	153.0	151.5	151.69	7967337.0
2023-02-17 10:00:00	AAPL	Stock	151.68	152.65	151.63	152.02	4612198.0
2023-02-17 10:30:00	AAPL	Stock	152.0	152.68	151.87	152.01	3156881.0
2023-02-17 11:00:00	AAPL	Stock	151.99	152.2699	151.49	151.6501	2502527.0
2023-02-17 11:30:00	AAPL	Stock	151.66	151.94	151.37	151.575	2265339.0
2023-02-17 12:00:00	AAPL	Stock	151.57	152.17	151.51	151.71	2293738.0
2023-02-17 12:30:00	AAPL	Stock	151.705	151.795	150.9104	151.08	2214244.0
2023-02-17 13:00:00	AAPL	Stock	151.09	151.4899	150.85	150.99	1953077.0
2023-02-17 13:30:00	AAPL	Stock	151.0	151.44	150.85	151.44	1693959.0
2023-02-17 14:00:00	AAPL	Stock	151.435	151.995	151.34	151.68	2326503.0
2023-02-17 14:30:00	AAPL	Stock	151.683	152.3599	151.683	152.3501	2602805.0
2023-02-17 15:00:00	AAPL	Stock	152.3589	152.63	151.93	152.035	2988860.0
2023-02-17 15:30:00	AAPL	Stock	152.025	152.55	151.965	152.54	5195701.0
2023-02-17 16:00:00	AAPL	Stock	152.54	152.55	152.4	152.51	6499111.0
2023-02-17 16:30:00	AAPL	Stock	152.5	152.55	152.46	152.52	72867.0
2023-02-17 17:00:00	AAPL	Stock	152.52	152.52	152.41	152.46	79789.0
2023-02-17 17:30:00	AAPL	Stock	152.48	152.54	152.46	152.5	24871.0
2023-02-17 18:00:00	AAPL	Stock	152.5	152.64	152.48	152.64	14983.0
2023-02-17 18:30:00	AAPL	Stock	152.63	152.69	152.56	152.62	6781.0
2023-02-17 19:00:00	AAPL	Stock	152.62	152.63	152.55	152.57	5582.0
2023-02-17 19:30:00	AAPL	Stock	152.56	152.64	152.55	152.64	10713.0
2023-02-17 04:00:00	MSFT	Stock	260.0	260.02	259.52	259.81	14303.0
2023-02-17 04:30:00	MSFT	Stock	259.97	260.68	259.97	260.0	3160.0
2023-02-17 05:00:00	MSFT	Stock	259.9	259.9	259.62	259.64	1342.0
2023-02-17 05:30:00	MSFT	Stock	259.8	259.99	259.62	259.62	2309.0
2023-02-17 06:00:00	MSFT	Stock	259.66	259.73	259.0	259.73	7640.0
2023-02-17 06:30:00	MSFT	Stock	259.76	259.79	259.47	259.79	2628.0
2023-02-17 07:00:00	MSFT	Stock	259.83	260.84	259.83	260.67	9736.0
2023-02-17 07:30:00	MSFT	Stock	260.66	260.78	260.52	260.68	3512.0
2023-02-17 08:00:00	MSFT	Stock	260.0907	260.84	259.96	259.96	21322.0
2023-02-17 08:30:00	MSFT	Stock	260.1	260.77	259.81	260.5501	38929.0
2023-02-17 09:00:00	MSFT	Stock	260.46	261.94	259.2	259.39	102545.0
2023-02-17 09:30:00	MSFT	Stock	259.39	260.09	256.44	257.265	4345635.0
2023-02-17 10:00:00	MSFT	Stock	257.23	258.82	257.06	257.3499	1877141.0
2023-02-17 10:30:00	MSFT	Stock	257.33	258.97	256.89	256.94	1524322.0
2023-02-17 11:00:00	MSFT	Stock	256.93	257.43	256.52	256.96	1034539.0
2023-02-17 11:30:00	MSFT	Stock	256.97	257.49	256.57	257.18	1007970.0
2023-02-17 12:00:00	MSFT	Stock	257.18	257.74	256.91	257.01	1045152.0
2023-02-17 12:30:00	MSFT	Stock	257.0	257.11	256.0	256.295	923361.0

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

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