PREVIEW / stock_30min / 2019-07-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-30.parquet
  size:    1.7 MB
  rows:    86,048
  symbols: 2,570

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
2019-07-30 04:00:00	AAPL	Stock	52.35	52.4	52.295	52.295	20016.0
2019-07-30 04:30:00	AAPL	Stock	52.27	52.27	52.18	52.195	11444.0
2019-07-30 05:00:00	AAPL	Stock	52.195	52.2	52.1375	52.1375	5184.0
2019-07-30 05:30:00	AAPL	Stock	52.16	52.165	52.1275	52.14	3320.0
2019-07-30 06:00:00	AAPL	Stock	52.13	52.175	52.0825	52.0825	20544.0
2019-07-30 06:30:00	AAPL	Stock	52.2225	52.225	52.2225	52.225	6088.0
2019-07-30 07:00:00	AAPL	Stock	52.22	52.275	52.08	52.085	130388.0
2019-07-30 07:30:00	AAPL	Stock	52.08	52.0825	51.97	51.9975	177356.0
2019-07-30 08:00:00	AAPL	Stock	51.985	52.2875	51.9725	52.08	185040.0
2019-07-30 08:30:00	AAPL	Stock	52.0625	52.075	51.905	51.9375	160720.0
2019-07-30 09:00:00	AAPL	Stock	51.95	52.2	51.9375	52.18	215064.0
2019-07-30 09:30:00	AAPL	Stock	52.19	52.3975	51.955	51.9688	13567128.0
2019-07-30 10:00:00	AAPL	Stock	51.9712	52.0952	51.885	51.8925	6768432.0
2019-07-30 10:30:00	AAPL	Stock	51.893	51.9825	51.8275	51.9188	5765532.0
2019-07-30 11:00:00	AAPL	Stock	51.92	52.0425	51.9175	52.01	4565144.0
2019-07-30 11:30:00	AAPL	Stock	52.0085	52.0775	51.9525	51.9762	3578488.0
2019-07-30 12:00:00	AAPL	Stock	51.975	52.0675	51.9375	52.0025	2817676.0
2019-07-30 12:30:00	AAPL	Stock	52.005	52.04	51.945	51.975	3583472.0
2019-07-30 13:00:00	AAPL	Stock	51.9762	52.1225	51.9738	52.1075	4914392.0
2019-07-30 13:30:00	AAPL	Stock	52.1075	52.215	52.1025	52.195	4645096.0
2019-07-30 14:00:00	AAPL	Stock	52.195	52.54	52.1925	52.46	10526972.0
2019-07-30 14:30:00	AAPL	Stock	52.4575	52.4675	52.3475	52.3775	5681752.0
2019-07-30 15:00:00	AAPL	Stock	52.375	52.4825	52.325	52.3538	4862184.0
2019-07-30 15:30:00	AAPL	Stock	52.3538	52.3675	52.086	52.221	12738504.0
2019-07-30 16:00:00	AAPL	Stock	52.215	52.75	52.055	52.325	6106280.0
2019-07-30 16:30:00	AAPL	Stock	52.3025	54.495	51.3725	54.355	14899740.0
2019-07-30 17:00:00	AAPL	Stock	54.355	54.625	54.25	54.45	3521224.0
2019-07-30 17:30:00	AAPL	Stock	54.4625	54.535	54.345	54.4475	1197008.0
2019-07-30 18:00:00	AAPL	Stock	54.45	54.45	54.2875	54.3875	490036.0
2019-07-30 18:30:00	AAPL	Stock	54.4	54.4375	54.3625	54.3825	388836.0
2019-07-30 19:00:00	AAPL	Stock	54.4125	54.435	54.395	54.42	203916.0
2019-07-30 19:30:00	AAPL	Stock	54.42	54.5325	54.42	54.5325	573292.0
2019-07-30 04:00:00	MSFT	Stock	141.23	141.23	141.22	141.22	200.0
2019-07-30 04:30:00	MSFT	Stock	141.03	141.1	140.73	140.73	402.0
2019-07-30 05:30:00	MSFT	Stock	140.52	140.72	140.52	140.72	313.0
2019-07-30 06:00:00	MSFT	Stock	140.67	140.67	140.4	140.65	2403.0
2019-07-30 07:00:00	MSFT	Stock	140.43	140.45	140.3	140.45	2464.0
2019-07-30 07:30:00	MSFT	Stock	140.25	140.25	139.94	140.04	7909.0
2019-07-30 08:00:00	MSFT	Stock	140.09	141.38	139.76	139.9	34199.0
2019-07-30 08:30:00	MSFT	Stock	140.0	140.0	139.69	139.722	9287.0
2019-07-30 09:00:00	MSFT	Stock	139.934	140.09	139.7	140.09	15243.0
2019-07-30 09:30:00	MSFT	Stock	140.11	140.81	139.8	140.62	1862566.0
2019-07-30 10:00:00	MSFT	Stock	140.59	140.99	140.476	140.87	853949.0
2019-07-30 10:30:00	MSFT	Stock	140.875	141.0	140.81	140.93	1168931.0
2019-07-30 11:00:00	MSFT	Stock	140.94	141.19	140.86	140.875	631330.0
2019-07-30 11:30:00	MSFT	Stock	140.89	140.99	140.17	140.253	776980.0
2019-07-30 12:00:00	MSFT	Stock	140.26	140.49	140.23	140.46	778418.0
2019-07-30 12:30:00	MSFT	Stock	140.465	140.645	140.43	140.57	774192.0
2019-07-30 13:00:00	MSFT	Stock	140.589	140.66	140.41	140.44	461661.0
2019-07-30 13:30:00	MSFT	Stock	140.44	140.73	140.41	140.69	645861.0

> showing 50 of 86,048 rows — these rows as CSV

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