PREVIEW / stock_30min / 2021-08-04

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-04.parquet
  size:    2.2 MB
  rows:    110,089
  symbols: 2,832

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-08-04 04:00:00	AAPL	Stock	147.0	147.4	147.0	147.32	3015.0
2021-08-04 04:30:00	AAPL	Stock	147.3	147.3	147.3	147.3	695.0
2021-08-04 05:00:00	AAPL	Stock	147.34	147.35	147.22	147.3	2494.0
2021-08-04 05:30:00	AAPL	Stock	147.38	147.53	147.38	147.4	2343.0
2021-08-04 06:00:00	AAPL	Stock	147.49	147.53	147.49	147.53	458.0
2021-08-04 06:30:00	AAPL	Stock	147.53	147.68	147.4	147.43	4131.0
2021-08-04 07:00:00	AAPL	Stock	147.4	147.54	147.35	147.36	29338.0
2021-08-04 07:30:00	AAPL	Stock	147.36	147.36	147.09	147.09	29110.0
2021-08-04 08:00:00	AAPL	Stock	147.36	147.55	146.94	147.27	185858.0
2021-08-04 08:30:00	AAPL	Stock	147.25	147.38	146.905	147.22	1477261.0
2021-08-04 09:00:00	AAPL	Stock	147.2136	147.29	147.1099	147.25	43039.0
2021-08-04 09:30:00	AAPL	Stock	147.26	147.79	146.79	147.693	8756821.0
2021-08-04 10:00:00	AAPL	Stock	147.7	147.756	146.69	147.08	5409547.0
2021-08-04 10:30:00	AAPL	Stock	147.07	147.29	146.58	146.63	3627234.0
2021-08-04 11:00:00	AAPL	Stock	146.635	146.76	146.28	146.4	3541919.0
2021-08-04 11:30:00	AAPL	Stock	146.405	146.99	146.37	146.97	2816432.0
2021-08-04 12:00:00	AAPL	Stock	146.96	147.31	146.81	147.195	2595193.0
2021-08-04 12:30:00	AAPL	Stock	147.2	147.24	146.97	147.145	1619209.0
2021-08-04 13:00:00	AAPL	Stock	147.15	147.52	147.1401	147.265	2132778.0
2021-08-04 13:30:00	AAPL	Stock	147.27	147.3	147.0	147.075	1615412.0
2021-08-04 14:00:00	AAPL	Stock	147.07	147.26	146.97	147.1	1638216.0
2021-08-04 14:30:00	AAPL	Stock	147.105	147.2	146.77	146.82	1919496.0
2021-08-04 15:00:00	AAPL	Stock	146.815	147.05	146.66	147.013	2023293.0
2021-08-04 15:30:00	AAPL	Stock	147.02	147.33	146.91	146.94	3932154.0
2021-08-04 16:00:00	AAPL	Stock	146.95	146.95	146.77	146.82	5133640.0
2021-08-04 16:30:00	AAPL	Stock	146.84	146.89	146.75	146.83	39204.0
2021-08-04 17:00:00	AAPL	Stock	146.83	146.95	146.81	146.85	470193.0
2021-08-04 17:30:00	AAPL	Stock	146.84	146.95	146.81	146.9	18392.0
2021-08-04 18:00:00	AAPL	Stock	146.89	146.93	146.87	146.93	7867.0
2021-08-04 18:30:00	AAPL	Stock	146.93	146.95	146.88	146.9	9393.0
2021-08-04 19:00:00	AAPL	Stock	146.91	146.95	146.87	146.95	3852.0
2021-08-04 19:30:00	AAPL	Stock	146.92	147.01	146.9	147.01	22135.0
2021-08-04 04:00:00	MSFT	Stock	287.19	287.19	287.01	287.01	211.0
2021-08-04 04:30:00	MSFT	Stock	286.9	286.9	286.9	286.9	700.0
2021-08-04 05:00:00	MSFT	Stock	287.12	287.15	286.92	286.92	1000.0
2021-08-04 05:30:00	MSFT	Stock	287.0	287.31	287.0	287.2	1163.0
2021-08-04 06:30:00	MSFT	Stock	287.25	287.3	287.17	287.17	1358.0
2021-08-04 07:00:00	MSFT	Stock	287.2	287.2	286.96	286.97	3649.0
2021-08-04 07:30:00	MSFT	Stock	286.9	286.97	286.6	286.6	3149.0
2021-08-04 08:00:00	MSFT	Stock	287.12	287.4799	286.55	286.63	9067.0
2021-08-04 08:30:00	MSFT	Stock	286.66	286.68	286.2	286.33	5671.0
2021-08-04 09:00:00	MSFT	Stock	286.25	286.4	285.54	285.98	13131.0
2021-08-04 09:30:00	MSFT	Stock	286.0	287.2126	285.8	286.795	1784373.0
2021-08-04 10:00:00	MSFT	Stock	286.805	286.88	284.65	284.78	1311293.0
2021-08-04 10:30:00	MSFT	Stock	284.775	285.62	284.65	285.02	837666.0
2021-08-04 11:00:00	MSFT	Stock	285.03	285.544	284.97	285.251	547225.0
2021-08-04 11:30:00	MSFT	Stock	285.23	286.48	285.07	286.45	656125.0
2021-08-04 12:00:00	MSFT	Stock	286.44	286.725	286.12	286.32	553457.0
2021-08-04 12:30:00	MSFT	Stock	286.33	286.55	286.135	286.48	317580.0
2021-08-04 13:00:00	MSFT	Stock	286.49	287.03	286.49	286.742	586330.0

> showing 50 of 110,089 rows — these rows as CSV

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