PREVIEW / stock_30min / 2021-04-01

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-01.parquet
  size:    2.3 MB
  rows:    114,686
  symbols: 2,949

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-04-01 04:00:00	AAPL	Stock	123.45	123.78	123.3	123.72	33196.0
2021-04-01 04:30:00	AAPL	Stock	123.72	123.79	123.2	123.63	19084.0
2021-04-01 05:00:00	AAPL	Stock	123.56	123.56	123.33	123.4	11594.0
2021-04-01 05:30:00	AAPL	Stock	123.39	123.64	123.36	123.5	19380.0
2021-04-01 06:00:00	AAPL	Stock	123.6	123.61	123.4	123.41	6401.0
2021-04-01 06:30:00	AAPL	Stock	123.39	123.4	123.18	123.23	6204.0
2021-04-01 07:00:00	AAPL	Stock	123.15	123.53	123.09	123.42	136912.0
2021-04-01 07:30:00	AAPL	Stock	123.42	123.48	123.3	123.32	75962.0
2021-04-01 08:00:00	AAPL	Stock	123.2899	123.68	122.15	123.51	316892.0
2021-04-01 08:30:00	AAPL	Stock	123.51	123.6	122.15	123.52	162290.0
2021-04-01 09:00:00	AAPL	Stock	123.51	123.64	122.15	123.62	199504.0
2021-04-01 09:30:00	AAPL	Stock	123.64	124.18	123.26	123.59	11227634.0
2021-04-01 10:00:00	AAPL	Stock	123.58	123.67	123.0	123.3991	6596552.0
2021-04-01 10:30:00	AAPL	Stock	123.4	123.56	123.23	123.452	3861651.0
2021-04-01 11:00:00	AAPL	Stock	123.45	123.7	123.16	123.2783	4331665.0
2021-04-01 11:30:00	AAPL	Stock	123.2751	123.31	122.89	122.9005	3918273.0
2021-04-01 12:00:00	AAPL	Stock	122.9	123.3714	122.84	123.355	3393504.0
2021-04-01 12:30:00	AAPL	Stock	123.36	123.44	123.09	123.188	2585527.0
2021-04-01 13:00:00	AAPL	Stock	123.185	123.2426	122.67	122.675	3465277.0
2021-04-01 13:30:00	AAPL	Stock	122.67	122.8684	122.62	122.67	2770958.0
2021-04-01 14:00:00	AAPL	Stock	122.67	122.9	122.57	122.87	2868630.0
2021-04-01 14:30:00	AAPL	Stock	122.87	122.96	122.66	122.675	2892162.0
2021-04-01 15:00:00	AAPL	Stock	122.674	122.79	122.49	122.53	3218034.0
2021-04-01 15:30:00	AAPL	Stock	122.525	123.0	122.49	122.99	7106959.0
2021-04-01 16:00:00	AAPL	Stock	123.0	123.01	122.92	122.98	6069513.0
2021-04-01 16:30:00	AAPL	Stock	123.0	123.0	122.9	122.92	74668.0
2021-04-01 17:00:00	AAPL	Stock	122.9499	122.99	122.93	122.93	14132.0
2021-04-01 17:30:00	AAPL	Stock	122.95	123.0	122.93	122.98	20319.0
2021-04-01 18:00:00	AAPL	Stock	122.99	123.06	122.95	122.99	45325.0
2021-04-01 18:30:00	AAPL	Stock	122.98	122.99	122.94	122.98	15524.0
2021-04-01 19:00:00	AAPL	Stock	122.98	123.0	122.85	122.94	44212.0
2021-04-01 19:30:00	AAPL	Stock	122.96	123.09	122.94	123.0	44444.0
2021-04-01 04:00:00	MSFT	Stock	238.82	238.97	238.65	238.65	5835.0
2021-04-01 04:30:00	MSFT	Stock	238.68	238.68	238.5	238.5	1044.0
2021-04-01 05:00:00	MSFT	Stock	238.5	238.5	238.3	238.45	6541.0
2021-04-01 05:30:00	MSFT	Stock	238.58	238.75	238.55	238.56	4188.0
2021-04-01 06:00:00	MSFT	Stock	238.53	238.53	238.25	238.4	4673.0
2021-04-01 06:30:00	MSFT	Stock	238.33	238.56	238.01	238.53	14888.0
2021-04-01 07:00:00	MSFT	Stock	238.56	238.65	238.3	238.5	29252.0
2021-04-01 07:30:00	MSFT	Stock	238.35	238.6	238.27	238.47	7856.0
2021-04-01 08:00:00	MSFT	Stock	238.4504	238.8	235.77	238.5	56344.0
2021-04-01 08:30:00	MSFT	Stock	238.5	238.65	235.77	238.33	30816.0
2021-04-01 09:00:00	MSFT	Stock	238.32	238.7	235.77	238.56	41740.0
2021-04-01 09:30:00	MSFT	Stock	238.52	241.425	238.0501	241.4238	4255150.0
2021-04-01 10:00:00	MSFT	Stock	241.425	241.91	240.56	241.64	2768778.0
2021-04-01 10:30:00	MSFT	Stock	241.67	242.06	241.3	241.83	1759004.0
2021-04-01 11:00:00	MSFT	Stock	241.81	241.9656	241.01	241.5814	1458726.0
2021-04-01 11:30:00	MSFT	Stock	241.59	241.72	240.75	241.46	952226.0
2021-04-01 12:00:00	MSFT	Stock	241.45	241.67	240.82	241.07	903850.0
2021-04-01 12:30:00	MSFT	Stock	241.08	241.66	240.8741	241.61	786502.0

> showing 50 of 114,686 rows — these rows as CSV

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