PREVIEW / stock_30min / 2020-01-29

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-29.parquet
  size:    1.8 MB
  rows:    85,992
  symbols: 2,428

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-01-29 04:00:00	AAPL	Stock	81.0625	81.075	80.8	80.9775	89432.0
2020-01-29 04:30:00	AAPL	Stock	80.97	81.1625	80.97	81.1075	35172.0
2020-01-29 05:00:00	AAPL	Stock	81.08	81.1075	80.9375	81.0375	38124.0
2020-01-29 05:30:00	AAPL	Stock	81.0425	81.15	81.0375	81.1475	31336.0
2020-01-29 06:00:00	AAPL	Stock	81.1375	81.2675	81.125	81.2125	55860.0
2020-01-29 06:30:00	AAPL	Stock	81.2125	81.2125	80.92	80.9625	109308.0
2020-01-29 07:00:00	AAPL	Stock	80.9625	81.1025	80.69	80.78	523772.0
2020-01-29 07:30:00	AAPL	Stock	80.8	80.845	80.6475	80.775	247600.0
2020-01-29 08:00:00	AAPL	Stock	80.975	81.16	80.65	81.125	1075116.0
2020-01-29 08:30:00	AAPL	Stock	81.1275	81.2125	80.8225	80.8325	929944.0
2020-01-29 09:00:00	AAPL	Stock	80.8275	81.1362	80.775	81.1362	902540.0
2020-01-29 09:30:00	AAPL	Stock	81.13	81.8125	80.665	80.84	40690284.0
2020-01-29 10:00:00	AAPL	Stock	80.835	81.1975	80.345	81.0672	20890360.0
2020-01-29 10:30:00	AAPL	Stock	81.07	81.375	81.05	81.3475	15120764.0
2020-01-29 11:00:00	AAPL	Stock	81.345	81.75	81.31	81.7125	15886268.0
2020-01-29 11:30:00	AAPL	Stock	81.7125	81.95	81.55	81.7875	13142840.0
2020-01-29 12:00:00	AAPL	Stock	81.7917	81.9075	81.6325	81.6825	8751992.0
2020-01-29 12:30:00	AAPL	Stock	81.6875	81.75	81.53	81.585	6029248.0
2020-01-29 13:00:00	AAPL	Stock	81.585	81.705	81.365	81.69	6037180.0
2020-01-29 13:30:00	AAPL	Stock	81.6925	81.73	81.5525	81.6675	3859596.0
2020-01-29 14:00:00	AAPL	Stock	81.6675	81.9625	81.5625	81.7	9755160.0
2020-01-29 14:30:00	AAPL	Stock	81.7	81.845	81.575	81.7575	5812156.0
2020-01-29 15:00:00	AAPL	Stock	81.7612	81.8875	81.55	81.81	9281680.0
2020-01-29 15:30:00	AAPL	Stock	81.805	81.8225	81.0175	81.08	16130456.0
2020-01-29 16:00:00	AAPL	Stock	81.085	81.215	80.7775	80.9625	9321560.0
2020-01-29 16:30:00	AAPL	Stock	81.085	81.085	80.835	81.0	160572.0
2020-01-29 17:00:00	AAPL	Stock	80.995	81.05	80.9375	80.965	95564.0
2020-01-29 17:30:00	AAPL	Stock	80.965	81.0675	80.9625	81.045	49668.0
2020-01-29 18:00:00	AAPL	Stock	81.0625	81.1875	81.05	81.075	140052.0
2020-01-29 18:30:00	AAPL	Stock	81.085	81.165	80.97	81.025	44316.0
2020-01-29 19:00:00	AAPL	Stock	81.005	81.025	80.8575	80.9275	123188.0
2020-01-29 19:30:00	AAPL	Stock	80.9275	81.07	80.8125	81.0375	116924.0
2020-01-29 04:00:00	MSFT	Stock	166.55	166.99	166.55	166.86	7178.0
2020-01-29 04:30:00	MSFT	Stock	166.86	166.86	166.6	166.73	1449.0
2020-01-29 05:00:00	MSFT	Stock	166.75	166.75	166.75	166.75	722.0
2020-01-29 05:30:00	MSFT	Stock	166.75	166.75	166.66	166.75	3100.0
2020-01-29 06:00:00	MSFT	Stock	166.75	167.0	166.75	166.95	3711.0
2020-01-29 06:30:00	MSFT	Stock	166.95	166.98	166.7	166.7	5668.0
2020-01-29 07:00:00	MSFT	Stock	166.95	167.3	166.9	167.1	48104.0
2020-01-29 07:30:00	MSFT	Stock	167.13	167.4	167.01	167.28	57577.0
2020-01-29 08:00:00	MSFT	Stock	167.25	167.38	166.9	167.15	73463.0
2020-01-29 08:30:00	MSFT	Stock	167.26	167.42	166.99	167.3	82916.0
2020-01-29 09:00:00	MSFT	Stock	167.3	168.05	167.28	167.91	106984.0
2020-01-29 09:30:00	MSFT	Stock	167.84	168.0	166.09	166.37	4030704.0
2020-01-29 10:00:00	MSFT	Stock	166.36	166.63	165.69	166.48	1919901.0
2020-01-29 10:30:00	MSFT	Stock	166.47	167.15	166.44	167.08	1535087.0
2020-01-29 11:00:00	MSFT	Stock	167.075	167.27	166.89	167.06	1276958.0
2020-01-29 11:30:00	MSFT	Stock	167.06	167.3	166.9	167.23	987941.0
2020-01-29 12:00:00	MSFT	Stock	167.23	167.7	167.215	167.69	1148618.0
2020-01-29 12:30:00	MSFT	Stock	167.695	168.1	167.52	167.88	1209922.0

> showing 50 of 85,992 rows — these rows as CSV

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