PREVIEW / stock_30min / 2018-07-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-23.parquet
  size:    1.6 MB
  rows:    82,108
  symbols: 2,802

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-07-23 04:00:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	400.0
2018-07-23 04:30:00	AAPL	Stock	47.675	47.675	47.675	47.675	1228.0
2018-07-23 07:00:00	AAPL	Stock	47.6975	47.715	47.65	47.6875	53644.0
2018-07-23 07:30:00	AAPL	Stock	47.6875	47.75	47.6625	47.75	43720.0
2018-07-23 08:00:00	AAPL	Stock	47.6575	47.965	47.6575	47.7875	75020.0
2018-07-23 08:30:00	AAPL	Stock	47.7575	47.86	47.7525	47.7625	282200.0
2018-07-23 09:00:00	AAPL	Stock	47.7625	47.7825	47.625	47.6675	113260.0
2018-07-23 09:30:00	AAPL	Stock	47.6675	47.75	47.415	47.52	9216944.0
2018-07-23 10:00:00	AAPL	Stock	47.52	47.585	47.42	47.4362	4820876.0
2018-07-23 10:30:00	AAPL	Stock	47.44	47.59	47.39	47.5325	4284308.0
2018-07-23 11:00:00	AAPL	Stock	47.535	47.6025	47.495	47.5825	2789464.0
2018-07-23 11:30:00	AAPL	Stock	47.5825	47.695	47.57	47.6725	2887256.0
2018-07-23 12:00:00	AAPL	Stock	47.675	47.855	47.6625	47.805	3177152.0
2018-07-23 12:30:00	AAPL	Stock	47.8058	47.825	47.745	47.7762	1712420.0
2018-07-23 13:00:00	AAPL	Stock	47.775	47.8095	47.745	47.79	1739824.0
2018-07-23 13:30:00	AAPL	Stock	47.79	47.88	47.7725	47.855	2303124.0
2018-07-23 14:00:00	AAPL	Stock	47.8575	47.935	47.84	47.8925	2882656.0
2018-07-23 14:30:00	AAPL	Stock	47.891	47.9575	47.8757	47.955	1863464.0
2018-07-23 15:00:00	AAPL	Stock	47.955	47.9762	47.9275	47.9282	2034756.0
2018-07-23 15:30:00	AAPL	Stock	47.9325	47.99	47.8775	47.9	4107388.0
2018-07-23 16:00:00	AAPL	Stock	47.9025	48.0225	47.85	47.95	12661552.0
2018-07-23 16:30:00	AAPL	Stock	47.95	47.95	47.85	47.9175	81424.0
2018-07-23 17:00:00	AAPL	Stock	47.9	47.925	47.9	47.925	1600.0
2018-07-23 17:30:00	AAPL	Stock	47.875	47.9125	47.8625	47.895	43124.0
2018-07-23 18:00:00	AAPL	Stock	47.9075	47.9375	47.8975	47.925	23788.0
2018-07-23 18:30:00	AAPL	Stock	47.9375	47.9375	47.925	47.925	4012.0
2018-07-23 19:00:00	AAPL	Stock	47.945	47.945	47.915	47.9375	7012.0
2018-07-23 19:30:00	AAPL	Stock	47.95	47.9875	47.93	47.9725	21220.0
2018-07-23 04:00:00	MSFT	Stock	106.2	106.34	106.11	106.11	861.0
2018-07-23 05:00:00	MSFT	Stock	106.32	106.35	106.3	106.35	1000.0
2018-07-23 05:30:00	MSFT	Stock	106.16	106.16	106.16	106.16	100.0
2018-07-23 06:00:00	MSFT	Stock	106.29	106.29	106.27	106.27	1100.0
2018-07-23 06:30:00	MSFT	Stock	106.15	106.2	106.02	106.1	2057.0
2018-07-23 07:00:00	MSFT	Stock	106.0	106.1	106.0	106.1	3147.0
2018-07-23 07:30:00	MSFT	Stock	106.01	106.1	105.95	106.1	3034.0
2018-07-23 08:00:00	MSFT	Stock	106.12	106.32	106.0	106.32	10613.0
2018-07-23 08:30:00	MSFT	Stock	106.39	106.4	106.23	106.29	11133.0
2018-07-23 09:00:00	MSFT	Stock	106.27	106.35	106.17	106.35	18668.0
2018-07-23 09:30:00	MSFT	Stock	106.35	107.49	106.13	107.476	4225075.0
2018-07-23 10:00:00	MSFT	Stock	107.48	107.9	107.32	107.69	3147357.0
2018-07-23 10:30:00	MSFT	Stock	107.69	107.96	107.51	107.8	2060146.0
2018-07-23 11:00:00	MSFT	Stock	107.8	107.85	107.36	107.68	1804451.0
2018-07-23 11:30:00	MSFT	Stock	107.675	107.93	107.6	107.76	1432371.0
2018-07-23 12:00:00	MSFT	Stock	107.76	107.85	107.59	107.765	1135400.0
2018-07-23 12:30:00	MSFT	Stock	107.77	107.87	107.67	107.75	907846.0
2018-07-23 13:00:00	MSFT	Stock	107.74	107.775	107.552	107.605	701056.0
2018-07-23 13:30:00	MSFT	Stock	107.6	107.78	107.51	107.697	1093791.0
2018-07-23 14:00:00	MSFT	Stock	107.699	108.02	107.67	107.985	1644947.0
2018-07-23 14:30:00	MSFT	Stock	107.99	108.105	107.951	108.02	1358340.0
2018-07-23 15:00:00	MSFT	Stock	108.01	108.12	108.0	108.01	1104141.0

> showing 50 of 82,108 rows — these rows as CSV

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