PREVIEW / stock_30min / 2017-11-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-24.parquet
  size:    1.0 MB
  rows:    48,690
  symbols: 2,837

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
2017-11-24 04:00:00	AAPL	Stock	43.75	43.7875	43.75	43.7875	19904.0
2017-11-24 04:30:00	AAPL	Stock	43.7875	43.7875	43.7725	43.7725	800.0
2017-11-24 05:30:00	AAPL	Stock	43.7875	43.7875	43.775	43.775	1196.0
2017-11-24 06:00:00	AAPL	Stock	43.7875	43.8375	43.7875	43.8375	1716.0
2017-11-24 06:30:00	AAPL	Stock	43.8	43.8	43.7675	43.7675	9312.0
2017-11-24 07:00:00	AAPL	Stock	43.75	43.8175	43.75	43.815	63748.0
2017-11-24 07:30:00	AAPL	Stock	43.82	43.8275	43.7975	43.805	40696.0
2017-11-24 08:00:00	AAPL	Stock	43.8175	43.91	43.75	43.9	260700.0
2017-11-24 08:30:00	AAPL	Stock	43.86	43.8925	43.855	43.855	89588.0
2017-11-24 09:00:00	AAPL	Stock	43.865	43.8775	43.7625	43.79	420492.0
2017-11-24 09:30:00	AAPL	Stock	43.775	43.875	43.6615	43.8	11757156.0
2017-11-24 10:00:00	AAPL	Stock	43.8	43.83	43.72	43.786	4374324.0
2017-11-24 10:30:00	AAPL	Stock	43.7875	43.805	43.7425	43.765	3143508.0
2017-11-24 11:00:00	AAPL	Stock	43.765	43.82	43.75	43.7592	3894976.0
2017-11-24 11:30:00	AAPL	Stock	43.7588	43.8275	43.755	43.785	4076808.0
2017-11-24 12:00:00	AAPL	Stock	43.785	43.8125	43.7575	43.7712	3387920.0
2017-11-24 12:30:00	AAPL	Stock	43.7712	43.7725	43.7275	43.74	5653624.0
2017-11-24 13:00:00	AAPL	Stock	43.7425	43.75	43.725	43.745	4712772.0
2017-11-24 13:30:00	AAPL	Stock	43.7415	43.745	43.7165	43.7175	177736.0
2017-11-24 14:00:00	AAPL	Stock	43.7175	43.72	43.7	43.7	14896.0
2017-11-24 14:30:00	AAPL	Stock	43.7	43.7125	43.675	43.7125	9352.0
2017-11-24 15:00:00	AAPL	Stock	43.7125	43.7425	43.6975	43.7425	41940.0
2017-11-24 15:30:00	AAPL	Stock	43.738	43.738	43.7058	43.7125	2068.0
2017-11-24 16:00:00	AAPL	Stock	43.7025	43.7025	43.7025	43.7025	1200.0
2017-11-24 16:30:00	AAPL	Stock	43.7225	43.7225	43.7225	43.7225	400.0
2017-11-24 06:00:00	MSFT	Stock	83.36	83.36	83.36	83.36	100.0
2017-11-24 06:30:00	MSFT	Stock	83.34	83.35	83.34	83.35	600.0
2017-11-24 07:00:00	MSFT	Stock	83.15	83.4	83.15	83.4	421.0
2017-11-24 07:30:00	MSFT	Stock	83.23	83.23	83.23	83.23	800.0
2017-11-24 08:00:00	MSFT	Stock	83.35	83.4	83.21	83.4	3733.0
2017-11-24 08:30:00	MSFT	Stock	83.3	83.39	83.25	83.31	3032.0
2017-11-24 09:00:00	MSFT	Stock	83.27	83.31	82.77	83.03	35569.0
2017-11-24 09:30:00	MSFT	Stock	83.01	83.31	82.78	82.88	1548010.0
2017-11-24 10:00:00	MSFT	Stock	82.89	83.05	82.88	82.945	527243.0
2017-11-24 10:30:00	MSFT	Stock	82.945	83.26	82.94	83.225	558996.0
2017-11-24 11:00:00	MSFT	Stock	83.22	83.36	83.22	83.27	529408.0
2017-11-24 11:30:00	MSFT	Stock	83.27	83.33	83.26	83.274	384827.0
2017-11-24 12:00:00	MSFT	Stock	83.27	83.35	83.25	83.26	598362.0
2017-11-24 12:30:00	MSFT	Stock	83.265	83.43	83.21	83.27	967094.0
2017-11-24 13:00:00	MSFT	Stock	83.26	83.3	83.2	83.3	1541265.0
2017-11-24 13:30:00	MSFT	Stock	83.38	83.38	83.156	83.156	3038.0
2017-11-24 14:30:00	MSFT	Stock	83.203	83.203	83.203	83.203	309.0
2017-11-24 15:00:00	MSFT	Stock	83.26	83.26	83.26	83.26	176.0
2017-11-24 15:30:00	MSFT	Stock	83.26	83.26	83.251	83.251	481.0
2017-11-24 16:30:00	MSFT	Stock	83.2	83.2	83.2	83.2	100.0
2017-11-24 04:00:00	NVDA	Stock	5.3875	5.3912	5.3875	5.3912	15800.0
2017-11-24 04:30:00	NVDA	Stock	5.3908	5.3908	5.3908	5.3908	4000.0
2017-11-24 06:00:00	NVDA	Stock	5.3908	5.3908	5.3875	5.3875	10160.0
2017-11-24 06:30:00	NVDA	Stock	5.393	5.393	5.393	5.393	4000.0
2017-11-24 07:00:00	NVDA	Stock	5.39	5.405	5.39	5.3975	357360.0

> showing 50 of 48,690 rows — these rows as CSV

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