PREVIEW / stock_30min / 2021-11-17

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-11-17.parquet
  size:    2.3 MB
  rows:    113,906
  symbols: 2,703

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-11-17 04:00:00	AAPL	Stock	150.99	151.27	150.93	151.26	6938.0
2021-11-17 04:30:00	AAPL	Stock	151.13	151.13	151.05	151.05	1591.0
2021-11-17 05:00:00	AAPL	Stock	151.0	151.02	150.92	150.92	1244.0
2021-11-17 05:30:00	AAPL	Stock	150.97	150.98	150.95	150.96	1368.0
2021-11-17 06:00:00	AAPL	Stock	150.95	151.0	150.95	150.95	2144.0
2021-11-17 06:30:00	AAPL	Stock	150.99	151.06	150.93	151.06	5932.0
2021-11-17 07:00:00	AAPL	Stock	151.06	151.18	150.99	151.1	46703.0
2021-11-17 07:30:00	AAPL	Stock	151.12	151.27	151.06	151.06	25663.0
2021-11-17 08:00:00	AAPL	Stock	151.0363	151.24	150.623	150.92	112030.0
2021-11-17 08:30:00	AAPL	Stock	151.0	151.1	150.99	151.07	40958.0
2021-11-17 09:00:00	AAPL	Stock	151.09	151.22	150.72	151.0	136096.0
2021-11-17 09:30:00	AAPL	Stock	150.99	152.78	150.99	152.07	10182106.0
2021-11-17 10:00:00	AAPL	Stock	152.08	152.78	152.0545	152.51	6406819.0
2021-11-17 10:30:00	AAPL	Stock	152.52	152.63	152.2	152.6187	2729316.0
2021-11-17 11:00:00	AAPL	Stock	152.62	154.485	152.605	154.3729	10085148.0
2021-11-17 11:30:00	AAPL	Stock	154.37	155.0	154.19	154.985	6413562.0
2021-11-17 12:00:00	AAPL	Stock	154.985	155.0	153.77	154.105	6012097.0
2021-11-17 12:30:00	AAPL	Stock	154.11	154.7194	153.795	154.005	3771582.0
2021-11-17 13:00:00	AAPL	Stock	154.01	154.42	153.735	154.36	3103783.0
2021-11-17 13:30:00	AAPL	Stock	154.36	154.545	154.25	154.295	2585753.0
2021-11-17 14:00:00	AAPL	Stock	154.295	154.545	154.02	154.19	2649303.0
2021-11-17 14:30:00	AAPL	Stock	154.181	154.181	153.78	154.11	2392386.0
2021-11-17 15:00:00	AAPL	Stock	154.105	154.18	153.65	153.9	3418258.0
2021-11-17 15:30:00	AAPL	Stock	153.89	154.27	153.34	153.65	8169372.0
2021-11-17 16:00:00	AAPL	Stock	153.49	153.57	153.21	153.39	7779809.0
2021-11-17 16:30:00	AAPL	Stock	153.39	153.56	153.36	153.55	77148.0
2021-11-17 17:00:00	AAPL	Stock	153.58	153.71	153.45	153.49	40365.0
2021-11-17 17:30:00	AAPL	Stock	153.48	153.5	153.3001	153.32	55804.0
2021-11-17 18:00:00	AAPL	Stock	153.35	153.63	153.33	153.58	18505.0
2021-11-17 18:30:00	AAPL	Stock	153.58	153.69	153.55	153.65	13099.0
2021-11-17 19:00:00	AAPL	Stock	153.66	153.72	153.5	153.5	24806.0
2021-11-17 19:30:00	AAPL	Stock	153.65	153.69	153.5	153.68	21400.0
2021-11-17 04:00:00	MSFT	Stock	339.61	339.61	339.1	339.26	1298.0
2021-11-17 04:30:00	MSFT	Stock	339.27	339.27	339.25	339.25	1050.0
2021-11-17 05:30:00	MSFT	Stock	339.87	340.0	339.87	340.0	616.0
2021-11-17 06:00:00	MSFT	Stock	339.89	339.91	339.84	339.84	1488.0
2021-11-17 06:30:00	MSFT	Stock	339.96	339.96	339.86	339.87	950.0
2021-11-17 07:00:00	MSFT	Stock	339.88	340.13	339.0	339.11	16937.0
2021-11-17 07:30:00	MSFT	Stock	339.32	339.5	339.15	339.2	5622.0
2021-11-17 08:00:00	MSFT	Stock	339.1559	340.16	338.8	339.31	18457.0
2021-11-17 08:30:00	MSFT	Stock	339.51	339.65	339.43	339.46	10880.0
2021-11-17 09:00:00	MSFT	Stock	339.55	339.55	338.92	339.19	7580.0
2021-11-17 09:30:00	MSFT	Stock	339.21	340.33	338.0	338.11	1426612.0
2021-11-17 10:00:00	MSFT	Stock	338.205	340.07	338.16	339.615	1024829.0
2021-11-17 10:30:00	MSFT	Stock	339.62	340.2	339.31	339.84	673734.0
2021-11-17 11:00:00	MSFT	Stock	339.83	341.07	339.83	340.81	780376.0
2021-11-17 11:30:00	MSFT	Stock	340.8	342.14	340.422	342.03	827157.0
2021-11-17 12:00:00	MSFT	Stock	342.05	342.19	340.43	340.49	841784.0
2021-11-17 12:30:00	MSFT	Stock	340.5	340.87	340.01	340.355	486209.0
2021-11-17 13:00:00	MSFT	Stock	340.33	340.79	339.73	340.07	562178.0

> showing 50 of 113,906 rows — these rows as CSV

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