PREVIEW / stock_30min / 2020-02-03

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-03.parquet
  size:    1.8 MB
  rows:    87,302
  symbols: 2,431

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-02-03 04:00:00	AAPL	Stock	77.5525	77.6875	77.465	77.465	44696.0
2020-02-03 04:30:00	AAPL	Stock	77.4625	77.4625	76.76	76.8	66312.0
2020-02-03 05:00:00	AAPL	Stock	76.6875	76.6875	76.25	76.5525	67480.0
2020-02-03 05:30:00	AAPL	Stock	76.5575	76.71	76.5075	76.71	21816.0
2020-02-03 06:00:00	AAPL	Stock	76.68	76.8875	76.68	76.75	39356.0
2020-02-03 06:30:00	AAPL	Stock	76.7225	76.845	76.7225	76.8425	40452.0
2020-02-03 07:00:00	AAPL	Stock	76.7875	76.9	76.375	76.675	295400.0
2020-02-03 07:30:00	AAPL	Stock	76.7	77.02	76.7	76.75	390620.0
2020-02-03 08:00:00	AAPL	Stock	76.5	77.0225	76.375	76.905	706528.0
2020-02-03 08:30:00	AAPL	Stock	76.925	76.975	76.7148	76.7375	549848.0
2020-02-03 09:00:00	AAPL	Stock	76.7485	76.75	76.0275	76.055	1115904.0
2020-02-03 09:30:00	AAPL	Stock	76.0725	77.75	75.555	77.694	36449600.0
2020-02-03 10:00:00	AAPL	Stock	77.7	78.2275	77.68	78.1075	16194820.0
2020-02-03 10:30:00	AAPL	Stock	78.1112	78.3125	77.81	78.0833	8786260.0
2020-02-03 11:00:00	AAPL	Stock	78.09	78.365	77.925	78.195	7550880.0
2020-02-03 11:30:00	AAPL	Stock	78.2	78.3725	77.9075	77.995	6901808.0
2020-02-03 12:00:00	AAPL	Stock	77.9825	78.03	77.6082	77.735	7169908.0
2020-02-03 12:30:00	AAPL	Stock	77.74	77.8	77.1625	77.18	7452752.0
2020-02-03 13:00:00	AAPL	Stock	77.1825	77.255	76.53	76.7175	10101732.0
2020-02-03 13:30:00	AAPL	Stock	76.715	77.0775	76.66	76.9475	6756992.0
2020-02-03 14:00:00	AAPL	Stock	76.9512	77.0575	76.6675	76.8375	5845880.0
2020-02-03 14:30:00	AAPL	Stock	76.8363	76.99	76.7275	76.77	4496044.0
2020-02-03 15:00:00	AAPL	Stock	76.7725	77.2275	76.755	77.2238	5420252.0
2020-02-03 15:30:00	AAPL	Stock	77.2262	77.325	76.8375	77.1775	11157912.0
2020-02-03 16:00:00	AAPL	Stock	77.1775	77.1875	76.8425	77.085	8046472.0
2020-02-03 16:30:00	AAPL	Stock	77.0825	77.165	77.0125	77.0725	165152.0
2020-02-03 17:00:00	AAPL	Stock	77.07	77.07	77.0025	77.0025	36088.0
2020-02-03 17:30:00	AAPL	Stock	77.0225	77.025	77.0	77.0125	30936.0
2020-02-03 18:00:00	AAPL	Stock	77.0075	77.0075	76.8125	76.8375	92264.0
2020-02-03 18:30:00	AAPL	Stock	76.835	76.995	76.8325	76.95	33320.0
2020-02-03 19:00:00	AAPL	Stock	76.9325	77.035	76.925	77.0	50144.0
2020-02-03 19:30:00	AAPL	Stock	77.0	77.045	77.0	77.025	40552.0
2020-02-03 04:00:00	MSFT	Stock	171.01	171.2	170.94	170.94	6101.0
2020-02-03 04:30:00	MSFT	Stock	170.97	171.1	170.8	170.8	4474.0
2020-02-03 05:00:00	MSFT	Stock	170.8	170.8	170.54	170.6	4070.0
2020-02-03 05:30:00	MSFT	Stock	170.55	170.75	170.5	170.75	5110.0
2020-02-03 06:00:00	MSFT	Stock	170.66	171.0	170.66	170.95	4646.0
2020-02-03 06:30:00	MSFT	Stock	170.95	171.3	170.94	171.3	2922.0
2020-02-03 07:00:00	MSFT	Stock	171.16	171.23	170.85	171.05	26827.0
2020-02-03 07:30:00	MSFT	Stock	171.04	171.23	170.98	171.0	10773.0
2020-02-03 08:00:00	MSFT	Stock	171.104	171.48	170.85	171.48	64647.0
2020-02-03 08:30:00	MSFT	Stock	171.47	171.47	171.2	171.375	28774.0
2020-02-03 09:00:00	MSFT	Stock	171.375	171.375	170.25	170.45	70842.0
2020-02-03 09:30:00	MSFT	Stock	170.43	172.22	170.4	172.22	3643401.0
2020-02-03 10:00:00	MSFT	Stock	172.23	173.13	171.95	173.05	2435600.0
2020-02-03 10:30:00	MSFT	Stock	173.055	173.075	172.38	172.57	1418276.0
2020-02-03 11:00:00	MSFT	Stock	172.58	172.95	172.5	172.58	1183864.0
2020-02-03 11:30:00	MSFT	Stock	172.57	172.64	172.08	172.57	1205980.0
2020-02-03 12:00:00	MSFT	Stock	172.57	173.45	172.4	173.32	1098938.0
2020-02-03 12:30:00	MSFT	Stock	173.32	174.02	173.23	173.87	1167486.0

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

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