PREVIEW / stock_30min / 2020-12-29

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-29.parquet
  size:    2.2 MB
  rows:    110,068
  symbols: 2,685

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-12-29 04:00:00	AAPL	Stock	137.5	137.95	137.15	137.54	54560.0
2020-12-29 04:30:00	AAPL	Stock	137.52	137.65	137.51	137.51	14407.0
2020-12-29 05:00:00	AAPL	Stock	137.5	137.6	137.49	137.58	5570.0
2020-12-29 05:30:00	AAPL	Stock	137.55	137.65	137.01	137.6	10527.0
2020-12-29 06:00:00	AAPL	Stock	137.61	137.63	137.3	137.3	9800.0
2020-12-29 06:30:00	AAPL	Stock	137.3	137.44	137.3	137.35	17962.0
2020-12-29 07:00:00	AAPL	Stock	137.33	138.25	137.33	138.2	396355.0
2020-12-29 07:30:00	AAPL	Stock	138.22	138.25	137.91	138.1	167653.0
2020-12-29 08:00:00	AAPL	Stock	137.7	138.25	137.35	138.06	528737.0
2020-12-29 08:30:00	AAPL	Stock	138.04	138.41	138.0	138.22	317816.0
2020-12-29 09:00:00	AAPL	Stock	138.22	138.41	138.0	138.07	431116.0
2020-12-29 09:30:00	AAPL	Stock	138.06	138.789	135.94	136.42	22585165.0
2020-12-29 10:00:00	AAPL	Stock	136.42	136.85	135.51	135.98	10814618.0
2020-12-29 10:30:00	AAPL	Stock	135.982	137.06	135.82	136.73	8332931.0
2020-12-29 11:00:00	AAPL	Stock	136.73	137.41	136.6	137.296	7533914.0
2020-12-29 11:30:00	AAPL	Stock	137.3	137.57	136.905	137.09	6282742.0
2020-12-29 12:00:00	AAPL	Stock	137.095	137.1	136.36	136.488	6894227.0
2020-12-29 12:30:00	AAPL	Stock	136.485	136.53	135.67	136.3	6543217.0
2020-12-29 13:00:00	AAPL	Stock	136.3	136.454	136.02	136.08	4036185.0
2020-12-29 13:30:00	AAPL	Stock	136.085	136.39	135.94	136.139	3559066.0
2020-12-29 14:00:00	AAPL	Stock	136.135	136.16	135.69	135.793	3751186.0
2020-12-29 14:30:00	AAPL	Stock	135.794	135.85	135.13	135.435	5724336.0
2020-12-29 15:00:00	AAPL	Stock	135.435	135.67	135.15	135.368	4602176.0
2020-12-29 15:30:00	AAPL	Stock	135.37	135.54	134.341	134.93	10395488.0
2020-12-29 16:00:00	AAPL	Stock	134.87	135.13	134.67	135.03	4520396.0
2020-12-29 16:30:00	AAPL	Stock	135.03	135.1	134.87	135.1	82597.0
2020-12-29 17:00:00	AAPL	Stock	135.08	135.25	135.07	135.22	86631.0
2020-12-29 17:30:00	AAPL	Stock	135.22	135.23	134.91	134.92	65583.0
2020-12-29 18:00:00	AAPL	Stock	134.96	135.0	134.68	134.84	96560.0
2020-12-29 18:30:00	AAPL	Stock	134.84	134.93	134.8	134.85	64544.0
2020-12-29 19:00:00	AAPL	Stock	134.85	134.85	134.63	134.75	58952.0
2020-12-29 19:30:00	AAPL	Stock	134.75	134.77	134.62	134.7	78488.0
2020-12-29 04:00:00	MSFT	Stock	226.0	226.0	226.0	226.0	799.0
2020-12-29 04:30:00	MSFT	Stock	225.72	225.95	225.72	225.95	363.0
2020-12-29 05:00:00	MSFT	Stock	225.95	225.95	225.95	225.95	3000.0
2020-12-29 05:30:00	MSFT	Stock	225.8	225.89	225.8	225.88	832.0
2020-12-29 06:00:00	MSFT	Stock	225.86	225.86	225.6	225.6	965.0
2020-12-29 06:30:00	MSFT	Stock	225.69	225.75	225.69	225.7	2149.0
2020-12-29 07:00:00	MSFT	Stock	225.71	225.84	225.69	225.77	4613.0
2020-12-29 07:30:00	MSFT	Stock	225.7	225.79	225.6	225.7	1570.0
2020-12-29 08:00:00	MSFT	Stock	225.8	225.875	225.58	225.76	10818.0
2020-12-29 08:30:00	MSFT	Stock	225.74	225.74	225.65	225.68	3527.0
2020-12-29 09:00:00	MSFT	Stock	225.7	226.26	225.6	226.06	15976.0
2020-12-29 09:30:00	MSFT	Stock	226.06	227.18	225.41	225.745	2165682.0
2020-12-29 10:00:00	MSFT	Stock	225.794	226.118	224.87	225.86	1175409.0
2020-12-29 10:30:00	MSFT	Stock	225.87	225.99	225.23	225.88	697566.0
2020-12-29 11:00:00	MSFT	Stock	225.88	226.19	225.18	225.99	1051804.0
2020-12-29 11:30:00	MSFT	Stock	226.0	226.11	225.13	225.4	660930.0
2020-12-29 12:00:00	MSFT	Stock	225.42	225.45	224.38	224.63	1008090.0
2020-12-29 12:30:00	MSFT	Stock	224.59	224.6	223.58	224.34	1171440.0

> showing 50 of 110,068 rows — these rows as CSV

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