PREVIEW / stock_30min / 2021-07-27

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-27.parquet
  size:    2.2 MB
  rows:    109,043
  symbols: 2,844

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-07-27 04:00:00	AAPL	Stock	148.5	148.57	148.03	148.22	22318.0
2021-07-27 04:30:00	AAPL	Stock	148.3	148.71	148.3	148.7	7525.0
2021-07-27 05:00:00	AAPL	Stock	148.61	148.69	148.3	148.63	11420.0
2021-07-27 05:30:00	AAPL	Stock	148.78	148.95	148.7	148.95	12754.0
2021-07-27 06:00:00	AAPL	Stock	148.82	149.05	148.82	148.9	8270.0
2021-07-27 06:30:00	AAPL	Stock	148.95	149.1	148.95	149.05	7429.0
2021-07-27 07:00:00	AAPL	Stock	149.07	149.53	149.05	149.45	136582.0
2021-07-27 07:30:00	AAPL	Stock	149.46	149.47	149.09	149.27	73827.0
2021-07-27 08:00:00	AAPL	Stock	149.27	149.5	148.618	149.3	331711.0
2021-07-27 08:30:00	AAPL	Stock	149.31	149.44	149.19	149.3399	119233.0
2021-07-27 09:00:00	AAPL	Stock	149.3399	149.3501	149.01	149.14	245470.0
2021-07-27 09:30:00	AAPL	Stock	149.14	149.21	148.25	148.65	9870174.0
2021-07-27 10:00:00	AAPL	Stock	148.645	148.73	146.88	147.38	8424908.0
2021-07-27 10:30:00	AAPL	Stock	147.37	147.56	146.6	147.42	6639450.0
2021-07-27 11:00:00	AAPL	Stock	147.41	147.66	146.56	146.8684	5091970.0
2021-07-27 11:30:00	AAPL	Stock	146.8699	146.87	146.17	146.355	5428145.0
2021-07-27 12:00:00	AAPL	Stock	146.35	146.4	145.55	146.39	5988107.0
2021-07-27 12:30:00	AAPL	Stock	146.38	146.47	145.91	146.06	3507640.0
2021-07-27 13:00:00	AAPL	Stock	146.06	146.3	145.7189	145.945	3905460.0
2021-07-27 13:30:00	AAPL	Stock	145.925	146.245	145.86	145.98	3141396.0
2021-07-27 14:00:00	AAPL	Stock	145.9794	146.68	145.92	146.665	3488160.0
2021-07-27 14:30:00	AAPL	Stock	146.665	147.07	146.44	147.06	5228209.0
2021-07-27 15:00:00	AAPL	Stock	147.065	147.32	146.58	146.615	4992303.0
2021-07-27 15:30:00	AAPL	Stock	146.61	146.89	146.28	146.78	8639843.0
2021-07-27 16:00:00	AAPL	Stock	146.77	147.35	145.39	147.2	8585418.0
2021-07-27 16:30:00	AAPL	Stock	147.2	149.32	145.11	145.49	4797042.0
2021-07-27 17:00:00	AAPL	Stock	145.48	145.69	142.8	143.2	1383118.0
2021-07-27 17:30:00	AAPL	Stock	143.13	146.77	142.5	144.42	1125131.0
2021-07-27 18:00:00	AAPL	Stock	144.4	144.89	144.11	144.59	523758.0
2021-07-27 18:30:00	AAPL	Stock	144.59	145.1	144.25	144.25	368570.0
2021-07-27 19:00:00	AAPL	Stock	144.22	144.44	144.0	144.07	220599.0
2021-07-27 19:30:00	AAPL	Stock	144.07	144.07	143.54	143.7	327753.0
2021-07-27 04:00:00	MSFT	Stock	288.96	289.01	288.7	289.01	1345.0
2021-07-27 04:30:00	MSFT	Stock	288.5	288.7	288.5	288.7	763.0
2021-07-27 05:00:00	MSFT	Stock	288.76	288.76	288.5	288.5	2284.0
2021-07-27 05:30:00	MSFT	Stock	288.78	288.84	288.5	288.67	4826.0
2021-07-27 06:00:00	MSFT	Stock	288.92	288.92	288.92	288.92	100.0
2021-07-27 06:30:00	MSFT	Stock	289.2	289.2	289.11	289.15	1783.0
2021-07-27 07:00:00	MSFT	Stock	289.33	289.85	289.3	289.7	11365.0
2021-07-27 07:30:00	MSFT	Stock	289.67	289.8	289.32	289.65	18392.0
2021-07-27 08:00:00	MSFT	Stock	289.4	289.9	289.05	289.6305	26598.0
2021-07-27 08:30:00	MSFT	Stock	289.575	289.665	289.44	289.66	14571.0
2021-07-27 09:00:00	MSFT	Stock	289.67	289.79	288.89	289.32	24557.0
2021-07-27 09:30:00	MSFT	Stock	289.31	289.575	287.7183	288.67	2103860.0
2021-07-27 10:00:00	MSFT	Stock	288.64	288.77	286.3501	286.97	1426515.0
2021-07-27 10:30:00	MSFT	Stock	286.97	286.97	284.71	285.45	1703084.0
2021-07-27 11:00:00	MSFT	Stock	285.42	286.0	284.555	284.9	1398176.0
2021-07-27 11:30:00	MSFT	Stock	284.89	285.33	283.805	285.1	2614739.0
2021-07-27 12:00:00	MSFT	Stock	285.075	285.34	284.11	285.3	1191104.0
2021-07-27 12:30:00	MSFT	Stock	285.25	285.41	284.31	284.32	845962.0

> showing 50 of 109,043 rows — these rows as CSV

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