PREVIEW / stock_30min / 2021-09-29

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-29.parquet
  size:    2.2 MB
  rows:    109,584
  symbols: 2,717

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-09-29 04:00:00	AAPL	Stock	143.6	143.94	143.22	143.66	43867.0
2021-09-29 04:30:00	AAPL	Stock	143.61	143.61	143.34	143.57	8598.0
2021-09-29 05:00:00	AAPL	Stock	143.6	143.63	143.27	143.54	7075.0
2021-09-29 05:30:00	AAPL	Stock	143.51	143.6	143.37	143.6	6022.0
2021-09-29 06:00:00	AAPL	Stock	143.6	143.68	143.53	143.53	9666.0
2021-09-29 06:30:00	AAPL	Stock	143.55	143.55	143.3	143.3	3917.0
2021-09-29 07:00:00	AAPL	Stock	143.26	143.4	142.81	143.0	115892.0
2021-09-29 07:30:00	AAPL	Stock	143.0	143.05	142.75	142.86	238087.0
2021-09-29 08:00:00	AAPL	Stock	142.9501	143.39	142.264	142.89	308023.0
2021-09-29 08:30:00	AAPL	Stock	142.89	142.9	142.7	142.83	235954.0
2021-09-29 09:00:00	AAPL	Stock	142.82	142.82	142.45	142.51	250142.0
2021-09-29 09:30:00	AAPL	Stock	142.54	144.26	142.03	143.96	11160873.0
2021-09-29 10:00:00	AAPL	Stock	143.96	144.45	143.84	144.155	5908754.0
2021-09-29 10:30:00	AAPL	Stock	144.15	144.34	143.59	144.19	5124200.0
2021-09-29 11:00:00	AAPL	Stock	144.195	144.25	143.62	143.67	2953503.0
2021-09-29 11:30:00	AAPL	Stock	143.67	143.7174	142.96	143.4201	3432974.0
2021-09-29 12:00:00	AAPL	Stock	143.43	143.6381	142.885	143.06	3024957.0
2021-09-29 12:30:00	AAPL	Stock	143.06	143.62	143.04	143.405	2911068.0
2021-09-29 13:00:00	AAPL	Stock	143.41	143.4955	142.99	143.0	2638449.0
2021-09-29 13:30:00	AAPL	Stock	143.01	143.21	142.535	143.15	2965444.0
2021-09-29 14:00:00	AAPL	Stock	143.14	143.96	143.07	143.81	3013036.0
2021-09-29 14:30:00	AAPL	Stock	143.82	144.06	143.74	143.9445	3020336.0
2021-09-29 15:00:00	AAPL	Stock	143.94	144.01	143.515	143.57	2731139.0
2021-09-29 15:30:00	AAPL	Stock	143.56	143.565	142.51	142.84	6855775.0
2021-09-29 16:00:00	AAPL	Stock	142.84	143.06	142.8	142.91	5336088.0
2021-09-29 16:30:00	AAPL	Stock	142.93	143.0	142.9	142.95	20265.0
2021-09-29 17:00:00	AAPL	Stock	142.9886	143.05	142.9201	143.01	32418.0
2021-09-29 17:30:00	AAPL	Stock	143.01	143.2	143.0	143.2	84384.0
2021-09-29 18:00:00	AAPL	Stock	143.2	143.45	143.05	143.11	50504.0
2021-09-29 18:30:00	AAPL	Stock	143.11	143.17	143.0	143.14	15817.0
2021-09-29 19:00:00	AAPL	Stock	143.15	143.39	143.12	143.35	41364.0
2021-09-29 19:30:00	AAPL	Stock	143.37	143.4	143.3	143.37	22238.0
2021-09-29 04:00:00	MSFT	Stock	285.87	286.8	285.87	286.11	3876.0
2021-09-29 04:30:00	MSFT	Stock	286.63	286.67	286.52	286.6	2544.0
2021-09-29 05:00:00	MSFT	Stock	286.54	286.82	286.35	286.35	6670.0
2021-09-29 05:30:00	MSFT	Stock	286.39	286.39	286.2	286.35	9742.0
2021-09-29 06:00:00	MSFT	Stock	286.45	287.0	286.45	286.77	15849.0
2021-09-29 06:30:00	MSFT	Stock	286.85	286.85	286.5	286.5	2204.0
2021-09-29 07:00:00	MSFT	Stock	286.5	286.7	285.3	285.63	23991.0
2021-09-29 07:30:00	MSFT	Stock	285.74	285.95	285.24	285.93	15043.0
2021-09-29 08:00:00	MSFT	Stock	285.91	286.49	284.228	285.38	55465.0
2021-09-29 08:30:00	MSFT	Stock	285.36	285.36	284.55	285.27	31258.0
2021-09-29 09:00:00	MSFT	Stock	285.0	285.28	284.56	285.0	46203.0
2021-09-29 09:30:00	MSFT	Stock	285.0	286.32	283.14	286.025	2884979.0
2021-09-29 10:00:00	MSFT	Stock	286.0234	286.68	284.54	284.86	1870247.0
2021-09-29 10:30:00	MSFT	Stock	284.88	285.51	283.94	285.2	1163755.0
2021-09-29 11:00:00	MSFT	Stock	285.22	285.25	284.0	284.07	792891.0
2021-09-29 11:30:00	MSFT	Stock	284.08	284.54	283.48	284.0909	872043.0
2021-09-29 12:00:00	MSFT	Stock	284.13	284.43	283.02	283.09	810567.0
2021-09-29 12:30:00	MSFT	Stock	283.07	284.275	283.01	283.96	829633.0

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

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