PREVIEW / stock_30min / 2018-02-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-02.parquet
  size:    1.7 MB
  rows:    86,408
  symbols: 2,902

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-02-02 04:00:00	AAPL	Stock	42.8875	43.0825	42.8875	42.9625	135064.0
2018-02-02 04:30:00	AAPL	Stock	42.9675	42.975	42.875	42.8925	48776.0
2018-02-02 05:00:00	AAPL	Stock	42.9	42.9475	42.5	42.6	332468.0
2018-02-02 05:30:00	AAPL	Stock	42.545	42.625	42.0625	42.25	469772.0
2018-02-02 06:00:00	AAPL	Stock	42.2425	42.35	42.09	42.2	415896.0
2018-02-02 06:30:00	AAPL	Stock	42.2	42.2	41.825	42.185	844928.0
2018-02-02 07:00:00	AAPL	Stock	42.1825	42.3475	42.005	42.095	1397120.0
2018-02-02 07:30:00	AAPL	Stock	42.095	42.3625	42.0925	42.255	1330452.0
2018-02-02 08:00:00	AAPL	Stock	42.2125	42.345	41.8125	41.835	2987308.0
2018-02-02 08:30:00	AAPL	Stock	41.815	41.865	41.375	41.4375	3844428.0
2018-02-02 09:00:00	AAPL	Stock	41.445	41.6975	41.2	41.62	4910672.0
2018-02-02 09:30:00	AAPL	Stock	41.6175	41.7	40.8	40.905	61166996.0
2018-02-02 10:00:00	AAPL	Stock	40.9042	41.02	40.715	40.9225	28793728.0
2018-02-02 10:30:00	AAPL	Stock	40.92	41.05	40.8125	40.9125	16554176.0
2018-02-02 11:00:00	AAPL	Stock	40.91	40.9375	40.6825	40.795	17373324.0
2018-02-02 11:30:00	AAPL	Stock	40.7925	40.965	40.72	40.7362	14899832.0
2018-02-02 12:00:00	AAPL	Stock	40.735	40.7875	40.63	40.7488	14402704.0
2018-02-02 12:30:00	AAPL	Stock	40.7475	40.7625	40.605	40.6775	12543516.0
2018-02-02 13:00:00	AAPL	Stock	40.6725	40.6775	40.22	40.465	18917464.0
2018-02-02 13:30:00	AAPL	Stock	40.465	40.6225	40.4425	40.5925	11534004.0
2018-02-02 14:00:00	AAPL	Stock	40.595	40.605	40.25	40.32	14326608.0
2018-02-02 14:30:00	AAPL	Stock	40.3175	40.5675	40.3125	40.4125	13326396.0
2018-02-02 15:00:00	AAPL	Stock	40.4125	40.4675	40.25	40.3575	15955032.0
2018-02-02 15:30:00	AAPL	Stock	40.3595	40.3875	40.025	40.1025	31885984.0
2018-02-02 16:00:00	AAPL	Stock	40.0375	40.2125	40.0375	40.17	20651548.0
2018-02-02 16:30:00	AAPL	Stock	40.15	40.5535	40.125	40.17	176992.0
2018-02-02 17:00:00	AAPL	Stock	40.165	40.2125	40.15	40.165	172684.0
2018-02-02 17:30:00	AAPL	Stock	40.1825	40.195	40.15	40.1825	71696.0
2018-02-02 18:00:00	AAPL	Stock	40.175	40.175	40.0525	40.055	104360.0
2018-02-02 18:30:00	AAPL	Stock	40.1025	40.1025	40.0	40.0675	222828.0
2018-02-02 19:00:00	AAPL	Stock	40.07	40.085	40.025	40.08	71936.0
2018-02-02 19:30:00	AAPL	Stock	40.075	40.125	40.0	40.005	193812.0
2018-02-02 04:00:00	MSFT	Stock	94.64	94.64	93.18	93.4	16270.0
2018-02-02 04:30:00	MSFT	Stock	93.4	93.4	93.32	93.32	400.0
2018-02-02 05:00:00	MSFT	Stock	93.12	93.12	93.11	93.11	1947.0
2018-02-02 05:30:00	MSFT	Stock	93.35	93.4	93.35	93.4	380.0
2018-02-02 06:00:00	MSFT	Stock	93.31	93.4	93.31	93.4	1863.0
2018-02-02 06:30:00	MSFT	Stock	93.4	93.41	93.39	93.4	1700.0
2018-02-02 07:00:00	MSFT	Stock	93.53	93.6	93.33	93.44	16839.0
2018-02-02 07:30:00	MSFT	Stock	93.41	93.64	93.33	93.6	16145.0
2018-02-02 08:00:00	MSFT	Stock	93.45	94.45	93.35	93.78	26836.0
2018-02-02 08:30:00	MSFT	Stock	93.61	94.12	93.45	93.96	75435.0
2018-02-02 09:00:00	MSFT	Stock	93.99	94.15	93.63	93.64	38914.0
2018-02-02 09:30:00	MSFT	Stock	93.74	93.97	92.88	93.174	5659748.0
2018-02-02 10:00:00	MSFT	Stock	93.18	93.19	91.645	92.99	4941206.0
2018-02-02 10:30:00	MSFT	Stock	92.99	93.27	92.73	93.04	2397798.0
2018-02-02 11:00:00	MSFT	Stock	93.03	93.11	92.43	92.46	1976907.0
2018-02-02 11:30:00	MSFT	Stock	92.46	92.53	92.03	92.08	1913082.0
2018-02-02 12:00:00	MSFT	Stock	92.072	92.4	91.75	92.39	3224896.0
2018-02-02 12:30:00	MSFT	Stock	92.4	92.4	92.04	92.115	1564845.0

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

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