PREVIEW / stock_30min / 2018-10-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-11.parquet
  size:    1.8 MB
  rows:    87,039
  symbols: 2,784

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
2018-10-11 04:00:00	AAPL	Stock	53.5	53.5	53.1	53.375	27808.0
2018-10-11 04:30:00	AAPL	Stock	53.2875	53.3975	53.1375	53.1625	98344.0
2018-10-11 05:00:00	AAPL	Stock	53.125	53.15	53.0	53.07	42448.0
2018-10-11 05:30:00	AAPL	Stock	53.0875	53.3	53.07	53.205	55320.0
2018-10-11 06:00:00	AAPL	Stock	53.2125	53.3075	53.0875	53.1	20976.0
2018-10-11 06:30:00	AAPL	Stock	53.1	53.2375	53.0625	53.2075	63552.0
2018-10-11 07:00:00	AAPL	Stock	53.21	53.375	53.125	53.2675	263144.0
2018-10-11 07:30:00	AAPL	Stock	53.225	53.415	53.055	53.275	309560.0
2018-10-11 08:00:00	AAPL	Stock	53.175	53.5	53.055	53.5	922112.0
2018-10-11 08:30:00	AAPL	Stock	53.4975	53.8725	53.4975	53.72	1001800.0
2018-10-11 09:00:00	AAPL	Stock	53.73	54.2	53.625	53.6325	1165228.0
2018-10-11 09:30:00	AAPL	Stock	53.63	54.87	53.1925	54.8175	33576680.0
2018-10-11 10:00:00	AAPL	Stock	54.8225	54.875	53.8925	54.2802	14971444.0
2018-10-11 10:30:00	AAPL	Stock	54.295	54.4925	53.9275	54.0425	9045896.0
2018-10-11 11:00:00	AAPL	Stock	54.055	54.11	53.4875	53.955	11491136.0
2018-10-11 11:30:00	AAPL	Stock	53.955	54.5075	53.67	54.185	8738424.0
2018-10-11 12:00:00	AAPL	Stock	54.1812	54.6925	54.07	54.435	7256784.0
2018-10-11 12:30:00	AAPL	Stock	54.4125	54.52	54.06	54.24	5448704.0
2018-10-11 13:00:00	AAPL	Stock	54.2325	54.44	53.9725	54.386	5817292.0
2018-10-11 13:30:00	AAPL	Stock	54.385	54.5	53.94	54.2612	5030396.0
2018-10-11 14:00:00	AAPL	Stock	54.2575	54.2725	53.795	53.955	6609676.0
2018-10-11 14:30:00	AAPL	Stock	53.955	53.97	53.08	53.4675	16931748.0
2018-10-11 15:00:00	AAPL	Stock	53.4525	54.425	53.3125	54.185	13870220.0
2018-10-11 15:30:00	AAPL	Stock	54.1725	54.375	53.54	53.6125	16401564.0
2018-10-11 16:00:00	AAPL	Stock	53.6475	54.0	53.55	53.85	13242676.0
2018-10-11 16:30:00	AAPL	Stock	53.875	54.0	53.6125	53.925	338008.0
2018-10-11 17:00:00	AAPL	Stock	53.9975	53.9975	53.825	53.9425	68928.0
2018-10-11 17:30:00	AAPL	Stock	53.95	54.0175	53.85	54.015	24412.0
2018-10-11 18:00:00	AAPL	Stock	53.9875	54.06	53.9625	54.06	116792.0
2018-10-11 18:30:00	AAPL	Stock	54.06	54.1875	54.0375	54.1875	29436.0
2018-10-11 19:00:00	AAPL	Stock	54.1875	54.25	54.1025	54.24	68340.0
2018-10-11 19:30:00	AAPL	Stock	54.2	54.25	54.175	54.245	48908.0
2018-10-11 04:00:00	MSFT	Stock	105.0	105.0	104.04	104.69	2550.0
2018-10-11 04:30:00	MSFT	Stock	104.51	104.77	104.51	104.75	11082.0
2018-10-11 05:00:00	MSFT	Stock	104.36	104.75	104.15	104.75	10208.0
2018-10-11 05:30:00	MSFT	Stock	104.8	104.8	104.55	104.8	1670.0
2018-10-11 06:00:00	MSFT	Stock	104.73	104.73	104.5	104.5	1234.0
2018-10-11 06:30:00	MSFT	Stock	104.4	104.75	104.28	104.7	12698.0
2018-10-11 07:00:00	MSFT	Stock	104.53	105.2	104.53	104.8	38617.0
2018-10-11 07:30:00	MSFT	Stock	104.73	105.18	104.11	105.14	43400.0
2018-10-11 08:00:00	MSFT	Stock	104.75	105.7	104.18	105.68	77607.0
2018-10-11 08:30:00	MSFT	Stock	105.53	106.2	105.21	105.66	137418.0
2018-10-11 09:00:00	MSFT	Stock	105.66	106.69	105.24	105.44	261022.0
2018-10-11 09:30:00	MSFT	Stock	105.23	108.24	105.23	108.11	8845691.0
2018-10-11 10:00:00	MSFT	Stock	108.12	108.204	106.54	107.213	4522874.0
2018-10-11 10:30:00	MSFT	Stock	107.22	107.53	106.34	106.6	2865229.0
2018-10-11 11:00:00	MSFT	Stock	106.62	107.89	105.9	107.46	3808934.0
2018-10-11 11:30:00	MSFT	Stock	107.46	108.85	106.75	108.2	3333034.0
2018-10-11 12:00:00	MSFT	Stock	108.2	108.93	108.08	108.22	2609445.0
2018-10-11 12:30:00	MSFT	Stock	108.21	108.354	106.5	107.6	2255974.0

> showing 50 of 87,039 rows — these rows as CSV

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