PREVIEW / stock_30min / 2018-03-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-20.parquet
  size:    1.6 MB
  rows:    81,750
  symbols: 2,889

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-03-20 04:30:00	AAPL	Stock	43.8775	43.8775	43.875	43.875	1200.0
2018-03-20 05:30:00	AAPL	Stock	43.8675	43.8725	43.8675	43.8725	5196.0
2018-03-20 06:00:00	AAPL	Stock	43.835	43.835	43.835	43.835	420.0
2018-03-20 06:30:00	AAPL	Stock	43.7875	43.895	43.7875	43.895	3004.0
2018-03-20 07:00:00	AAPL	Stock	43.85	44.0425	43.85	44.04	66024.0
2018-03-20 07:30:00	AAPL	Stock	44.0425	44.0575	44.0	44.0	36072.0
2018-03-20 08:00:00	AAPL	Stock	44.045	44.0625	43.835	43.975	215084.0
2018-03-20 08:30:00	AAPL	Stock	43.975	43.9825	43.95	43.9725	90432.0
2018-03-20 09:00:00	AAPL	Stock	43.975	43.98	43.805	43.805	208512.0
2018-03-20 09:30:00	AAPL	Stock	43.82	44.2	43.8	44.0575	10514256.0
2018-03-20 10:00:00	AAPL	Stock	44.0612	44.1	43.88	43.9925	6072532.0
2018-03-20 10:30:00	AAPL	Stock	43.995	44.07	43.96	44.035	4765796.0
2018-03-20 11:00:00	AAPL	Stock	44.04	44.09	43.9825	44.0475	4095728.0
2018-03-20 11:30:00	AAPL	Stock	44.0525	44.068	43.8425	43.915	4730608.0
2018-03-20 12:00:00	AAPL	Stock	43.9225	44.0475	43.89	44.0325	3553940.0
2018-03-20 12:30:00	AAPL	Stock	44.0275	44.075	43.9238	43.965	2949276.0
2018-03-20 13:00:00	AAPL	Stock	43.965	43.9875	43.76	43.78	4142120.0
2018-03-20 13:30:00	AAPL	Stock	43.7775	43.8125	43.7488	43.7775	3311692.0
2018-03-20 14:00:00	AAPL	Stock	43.7825	43.906	43.735	43.9025	3140184.0
2018-03-20 14:30:00	AAPL	Stock	43.8998	43.9425	43.86	43.925	3026564.0
2018-03-20 15:00:00	AAPL	Stock	43.92	43.9875	43.91	43.925	3520512.0
2018-03-20 15:30:00	AAPL	Stock	43.926	43.935	43.785	43.8125	7401216.0
2018-03-20 16:00:00	AAPL	Stock	43.81	43.8325	43.8075	43.8325	8215336.0
2018-03-20 16:30:00	AAPL	Stock	43.8325	43.84	43.8225	43.8375	42048.0
2018-03-20 17:00:00	AAPL	Stock	43.8275	43.835	43.8175	43.8225	8076.0
2018-03-20 17:30:00	AAPL	Stock	43.8275	43.84	43.8225	43.84	26952.0
2018-03-20 18:00:00	AAPL	Stock	43.835	43.8425	43.825	43.8325	42868.0
2018-03-20 18:30:00	AAPL	Stock	43.8325	43.8375	43.8125	43.825	15328.0
2018-03-20 19:00:00	AAPL	Stock	43.815	43.825	43.815	43.825	3600.0
2018-03-20 19:30:00	AAPL	Stock	43.8425	43.8425	43.8275	43.8425	9116.0
2018-03-20 04:00:00	MSFT	Stock	93.05	93.11	93.05	93.11	331.0
2018-03-20 04:30:00	MSFT	Stock	93.02	93.02	93.02	93.02	110.0
2018-03-20 05:00:00	MSFT	Stock	93.02	93.02	92.95	92.95	400.0
2018-03-20 05:30:00	MSFT	Stock	92.88	93.02	92.88	93.02	748.0
2018-03-20 06:00:00	MSFT	Stock	92.98	92.98	92.98	92.98	100.0
2018-03-20 07:00:00	MSFT	Stock	93.08	93.11	93.08	93.11	200.0
2018-03-20 07:30:00	MSFT	Stock	93.25	93.4	93.25	93.4	600.0
2018-03-20 08:00:00	MSFT	Stock	93.467	93.49	93.15	93.4	19717.0
2018-03-20 08:30:00	MSFT	Stock	93.4	93.4	93.23	93.26	10650.0
2018-03-20 09:00:00	MSFT	Stock	93.25	93.33	93.0	93.04	20728.0
2018-03-20 09:30:00	MSFT	Stock	93.05	93.77	93.0	93.54	2451052.0
2018-03-20 10:00:00	MSFT	Stock	93.545	93.66	93.07	93.42	1748678.0
2018-03-20 10:30:00	MSFT	Stock	93.42	93.59	93.25	93.425	1192484.0
2018-03-20 11:00:00	MSFT	Stock	93.42	93.455	93.21	93.43	968350.0
2018-03-20 11:30:00	MSFT	Stock	93.43	93.55	93.09	93.27	1209086.0
2018-03-20 12:00:00	MSFT	Stock	93.28	93.6	93.19	93.46	1128140.0
2018-03-20 12:30:00	MSFT	Stock	93.46	93.62	93.315	93.46	766944.0
2018-03-20 13:00:00	MSFT	Stock	93.466	93.59	93.3	93.395	609542.0
2018-03-20 13:30:00	MSFT	Stock	93.395	93.425	93.23	93.255	950635.0
2018-03-20 14:00:00	MSFT	Stock	93.26	93.54	93.16	93.522	821597.0

> showing 50 of 81,750 rows — these rows as CSV

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