PREVIEW / stock_30min / 2020-06-29

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-29.parquet
  size:    2.0 MB
  rows:    99,644
  symbols: 2,451

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
2020-06-29 04:00:00	AAPL	Stock	88.5	88.5	88.45	88.5	4400.0
2020-06-29 04:30:00	AAPL	Stock	88.6625	88.6625	88.6625	88.6625	1200.0
2020-06-29 05:00:00	AAPL	Stock	88.6625	88.75	88.575	88.75	3800.0
2020-06-29 05:30:00	AAPL	Stock	88.75	88.7725	88.575	88.7725	11012.0
2020-06-29 06:00:00	AAPL	Stock	88.6275	88.6375	88.595	88.6	47900.0
2020-06-29 06:30:00	AAPL	Stock	88.5875	88.745	88.5075	88.745	39952.0
2020-06-29 07:00:00	AAPL	Stock	88.68	88.7625	88.0875	88.425	228248.0
2020-06-29 07:30:00	AAPL	Stock	88.4525	88.8	88.3875	88.75	124864.0
2020-06-29 08:00:00	AAPL	Stock	88.755	88.8675	88.215	88.66	275588.0
2020-06-29 08:30:00	AAPL	Stock	88.6075	88.735	88.4375	88.475	140388.0
2020-06-29 09:00:00	AAPL	Stock	88.48	88.6175	88.31	88.3375	177624.0
2020-06-29 09:30:00	AAPL	Stock	88.3625	89.12	87.82	88.77	17890536.0
2020-06-29 10:00:00	AAPL	Stock	88.7732	89.38	88.6725	89.3025	10005056.0
2020-06-29 10:30:00	AAPL	Stock	89.3075	89.7725	89.2	89.5498	8336500.0
2020-06-29 11:00:00	AAPL	Stock	89.55	89.965	89.2275	89.9175	7099772.0
2020-06-29 11:30:00	AAPL	Stock	89.9275	90.2375	89.8625	90.01	8349496.0
2020-06-29 12:00:00	AAPL	Stock	90.02	90.316	89.95	90.2985	5175308.0
2020-06-29 12:30:00	AAPL	Stock	90.305	90.5435	90.2675	90.345	5364832.0
2020-06-29 13:00:00	AAPL	Stock	90.35	90.405	89.9875	90.044	4354948.0
2020-06-29 13:30:00	AAPL	Stock	90.0325	90.45	89.9775	90.1963	4231412.0
2020-06-29 14:00:00	AAPL	Stock	90.2025	90.36	90.02	90.1325	3153528.0
2020-06-29 14:30:00	AAPL	Stock	90.1175	90.1675	89.74	89.8582	4641304.0
2020-06-29 15:00:00	AAPL	Stock	89.8625	89.9825	89.63	89.9675	5451180.0
2020-06-29 15:30:00	AAPL	Stock	89.965	90.5075	89.7225	90.5	10269916.0
2020-06-29 16:00:00	AAPL	Stock	90.445	90.535	90.375	90.465	9249876.0
2020-06-29 16:30:00	AAPL	Stock	90.475	90.7175	90.4575	90.6625	108028.0
2020-06-29 17:00:00	AAPL	Stock	90.6625	90.6625	90.5	90.575	33444.0
2020-06-29 17:30:00	AAPL	Stock	90.51	90.5575	90.5	90.55	10984.0
2020-06-29 18:00:00	AAPL	Stock	90.5575	90.7	90.5575	90.7	52884.0
2020-06-29 18:30:00	AAPL	Stock	90.65	90.81	90.65	90.75	84956.0
2020-06-29 19:00:00	AAPL	Stock	90.7625	90.8	90.7	90.725	39144.0
2020-06-29 19:30:00	AAPL	Stock	90.75	90.8	90.625	90.625	96008.0
2020-06-29 04:00:00	MSFT	Stock	195.5	196.33	195.5	196.28	2350.0
2020-06-29 05:00:00	MSFT	Stock	196.6	196.6	196.6	196.6	822.0
2020-06-29 05:30:00	MSFT	Stock	196.4	196.41	196.16	196.16	1085.0
2020-06-29 06:00:00	MSFT	Stock	196.35	196.6	196.04	196.25	3066.0
2020-06-29 06:30:00	MSFT	Stock	196.25	197.4	196.25	197.0	2554.0
2020-06-29 07:00:00	MSFT	Stock	196.25	196.96	196.0	196.72	30565.0
2020-06-29 07:30:00	MSFT	Stock	196.52	197.4	196.4	196.92	9195.0
2020-06-29 08:00:00	MSFT	Stock	196.4	197.4	195.923	196.4	26625.0
2020-06-29 08:30:00	MSFT	Stock	196.41	196.838	196.23	196.5	26853.0
2020-06-29 09:00:00	MSFT	Stock	196.305	196.48	195.07	195.77	41623.0
2020-06-29 09:30:00	MSFT	Stock	195.77	196.15	193.55	194.88	3615374.0
2020-06-29 10:00:00	MSFT	Stock	194.88	196.1	194.38	195.67	1818781.0
2020-06-29 10:30:00	MSFT	Stock	195.72	196.84	195.34	196.09	1627969.0
2020-06-29 11:00:00	MSFT	Stock	196.11	197.36	195.63	197.303	1322128.0
2020-06-29 11:30:00	MSFT	Stock	197.3	197.76	197.04	197.399	1339505.0
2020-06-29 12:00:00	MSFT	Stock	197.4	198.07	197.4	197.77	1074094.0
2020-06-29 12:30:00	MSFT	Stock	197.8	198.1	197.44	197.5	751881.0
2020-06-29 13:00:00	MSFT	Stock	197.5	197.63	197.23	197.256	665465.0

> showing 50 of 99,644 rows — these rows as CSV

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