PREVIEW / stock_30min / 2020-03-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-04.parquet
  size:    1.8 MB
  rows:    89,172
  symbols: 2,414

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-03-04 04:00:00	AAPL	Stock	73.675	73.9875	73.45	73.755	70616.0
2020-03-04 04:30:00	AAPL	Stock	73.775	74.025	73.58	73.9625	48396.0
2020-03-04 05:00:00	AAPL	Stock	73.9725	74.1	73.85	74.09	15992.0
2020-03-04 05:30:00	AAPL	Stock	74.0875	74.105	73.895	73.9525	38272.0
2020-03-04 06:00:00	AAPL	Stock	73.9975	74.0025	73.75	74.0	53020.0
2020-03-04 06:30:00	AAPL	Stock	74.04	74.125	74.0	74.075	37116.0
2020-03-04 07:00:00	AAPL	Stock	74.0975	74.5375	73.95	74.375	766280.0
2020-03-04 07:30:00	AAPL	Stock	74.375	74.6225	74.29	74.3	382652.0
2020-03-04 08:00:00	AAPL	Stock	74.325	74.6225	73.835	74.025	1044508.0
2020-03-04 08:30:00	AAPL	Stock	73.9575	74.2	73.75	74.1	584824.0
2020-03-04 09:00:00	AAPL	Stock	74.125	74.345	73.79	74.1475	773120.0
2020-03-04 09:30:00	AAPL	Stock	74.11	74.62	73.2825	73.6825	26642104.0
2020-03-04 10:00:00	AAPL	Stock	73.705	74.545	73.59	74.255	18617708.0
2020-03-04 10:30:00	AAPL	Stock	74.27	74.32	73.635	73.7975	11646052.0
2020-03-04 11:00:00	AAPL	Stock	73.805	74.305	73.585	74.295	8714536.0
2020-03-04 11:30:00	AAPL	Stock	74.295	74.3575	73.6275	73.8475	8358576.0
2020-03-04 12:00:00	AAPL	Stock	73.8625	74.2125	73.8325	74.1925	5875476.0
2020-03-04 12:30:00	AAPL	Stock	74.191	74.7475	73.9225	74.735	8257412.0
2020-03-04 13:00:00	AAPL	Stock	74.73	75.185	74.67	74.9562	12805892.0
2020-03-04 13:30:00	AAPL	Stock	74.96	75.04	74.635	74.7345	9809452.0
2020-03-04 14:00:00	AAPL	Stock	74.74	74.9975	74.455	74.9425	8775068.0
2020-03-04 14:30:00	AAPL	Stock	74.945	75.0475	74.5425	74.774	8657536.0
2020-03-04 15:00:00	AAPL	Stock	74.77	75.12	74.5925	75.115	9852800.0
2020-03-04 15:30:00	AAPL	Stock	75.12	75.85	74.705	75.69	27142996.0
2020-03-04 16:00:00	AAPL	Stock	75.6625	75.7275	73.8398	75.4475	13654868.0
2020-03-04 16:30:00	AAPL	Stock	75.445	75.445	75.3175	75.4	234140.0
2020-03-04 17:00:00	AAPL	Stock	75.3775	75.4475	75.3675	75.3675	50504.0
2020-03-04 17:30:00	AAPL	Stock	75.3675	75.4375	75.3675	75.415	30924.0
2020-03-04 18:00:00	AAPL	Stock	75.4125	75.435	75.15	75.1625	82632.0
2020-03-04 18:30:00	AAPL	Stock	75.15	75.2525	75.1275	75.2525	123568.0
2020-03-04 19:00:00	AAPL	Stock	75.2225	75.2225	75.0	75.125	138528.0
2020-03-04 19:30:00	AAPL	Stock	75.075	75.2475	75.05	75.075	134688.0
2020-03-04 04:00:00	MSFT	Stock	167.9	168.25	167.64	168.1	13267.0
2020-03-04 04:30:00	MSFT	Stock	168.0	168.41	167.86	168.2	5250.0
2020-03-04 05:00:00	MSFT	Stock	168.3	168.93	168.2	168.93	6174.0
2020-03-04 05:30:00	MSFT	Stock	168.8	168.9	168.47	168.75	3422.0
2020-03-04 06:00:00	MSFT	Stock	168.5	168.5	167.9	168.3	5514.0
2020-03-04 06:30:00	MSFT	Stock	168.42	168.66	168.25	168.46	4766.0
2020-03-04 07:00:00	MSFT	Stock	168.3	168.95	167.75	168.63	76669.0
2020-03-04 07:30:00	MSFT	Stock	168.63	169.1	168.5	168.5	59043.0
2020-03-04 08:00:00	MSFT	Stock	168.43	169.1	167.25	167.85	162917.0
2020-03-04 08:30:00	MSFT	Stock	167.85	168.1	167.55	167.84	58296.0
2020-03-04 09:00:00	MSFT	Stock	167.85	168.78	167.25	168.66	112812.0
2020-03-04 09:30:00	MSFT	Stock	168.48	169.28	165.94	167.36	5966768.0
2020-03-04 10:00:00	MSFT	Stock	167.34	168.9	166.54	168.52	2956116.0
2020-03-04 10:30:00	MSFT	Stock	168.55	168.59	166.45	166.87	2099074.0
2020-03-04 11:00:00	MSFT	Stock	166.89	167.53	166.15	167.49	1674351.0
2020-03-04 11:30:00	MSFT	Stock	167.505	167.65	165.62	166.01	2242568.0
2020-03-04 12:00:00	MSFT	Stock	166.039	166.91	166.039	166.79	1461322.0
2020-03-04 12:30:00	MSFT	Stock	166.79	168.02	166.25	168.02	1474829.0

> showing 50 of 89,172 rows — these rows as CSV

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