PREVIEW / stock_30min / 2018-03-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-02.parquet
  size:    1.7 MB
  rows:    83,134
  symbols: 2,863

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-02 04:00:00	AAPL	Stock	43.5925	43.5925	43.5925	43.5925	7476.0
2018-03-02 04:30:00	AAPL	Stock	43.5925	43.5925	43.575	43.575	4800.0
2018-03-02 05:00:00	AAPL	Stock	43.5125	43.5325	43.4925	43.4925	23352.0
2018-03-02 05:30:00	AAPL	Stock	43.5325	43.5375	43.3875	43.415	33444.0
2018-03-02 06:00:00	AAPL	Stock	43.4	43.4	43.215	43.215	116040.0
2018-03-02 06:30:00	AAPL	Stock	43.19	43.3225	43.1675	43.3225	57764.0
2018-03-02 07:00:00	AAPL	Stock	43.275	43.375	43.2375	43.3175	180268.0
2018-03-02 07:30:00	AAPL	Stock	43.3125	43.325	43.1375	43.15	311760.0
2018-03-02 08:00:00	AAPL	Stock	43.175	43.3425	43.05	43.1125	512488.0
2018-03-02 08:30:00	AAPL	Stock	43.1	43.325	43.065	43.275	497588.0
2018-03-02 09:00:00	AAPL	Stock	43.275	43.3	43.1	43.185	524372.0
2018-03-02 09:30:00	AAPL	Stock	43.2	43.5775	43.1125	43.3907	22715824.0
2018-03-02 10:00:00	AAPL	Stock	43.38	43.5425	43.3215	43.4512	11745244.0
2018-03-02 10:30:00	AAPL	Stock	43.45	43.8125	43.3525	43.635	14189732.0
2018-03-02 11:00:00	AAPL	Stock	43.6325	43.7925	43.5025	43.759	7836764.0
2018-03-02 11:30:00	AAPL	Stock	43.7625	43.82	43.575	43.7725	8485208.0
2018-03-02 12:00:00	AAPL	Stock	43.765	43.905	43.7175	43.8925	6991056.0
2018-03-02 12:30:00	AAPL	Stock	43.895	44.0325	43.76	43.9525	6703072.0
2018-03-02 13:00:00	AAPL	Stock	43.95	43.98	43.67	43.675	6753440.0
2018-03-02 13:30:00	AAPL	Stock	43.67	43.77	43.53	43.6975	6185432.0
2018-03-02 14:00:00	AAPL	Stock	43.7	43.89	43.7	43.785	4996028.0
2018-03-02 14:30:00	AAPL	Stock	43.785	43.945	43.6825	43.7575	5962416.0
2018-03-02 15:00:00	AAPL	Stock	43.7625	43.8475	43.6525	43.8	6928376.0
2018-03-02 15:30:00	AAPL	Stock	43.799	44.075	43.78	44.07	17845708.0
2018-03-02 16:00:00	AAPL	Stock	44.0525	44.0525	43.95	44.025	10168212.0
2018-03-02 16:30:00	AAPL	Stock	44.0275	44.0525	43.4075	44.025	406500.0
2018-03-02 17:00:00	AAPL	Stock	44.015	44.02	43.995	43.995	64908.0
2018-03-02 17:30:00	AAPL	Stock	44.0	44.035	43.9875	43.9875	13868.0
2018-03-02 18:00:00	AAPL	Stock	43.9975	44.025	43.9975	44.025	11772.0
2018-03-02 18:30:00	AAPL	Stock	44.0125	44.0125	44.0	44.0	7064.0
2018-03-02 19:00:00	AAPL	Stock	44.025	44.025	43.9875	43.9875	11388.0
2018-03-02 19:30:00	AAPL	Stock	44.025	44.025	43.975	44.0125	28416.0
2018-03-02 04:30:00	MSFT	Stock	92.5	92.5	92.5	92.5	100.0
2018-03-02 05:00:00	MSFT	Stock	92.23	92.49	92.22	92.49	3795.0
2018-03-02 05:30:00	MSFT	Stock	92.5	92.5	92.24	92.24	400.0
2018-03-02 06:00:00	MSFT	Stock	92.25	92.25	92.15	92.15	7991.0
2018-03-02 06:30:00	MSFT	Stock	92.18	92.18	92.18	92.18	1000.0
2018-03-02 07:00:00	MSFT	Stock	92.29	92.45	92.18	92.45	21306.0
2018-03-02 07:30:00	MSFT	Stock	92.17	92.17	91.75	91.9	23023.0
2018-03-02 08:00:00	MSFT	Stock	92.0	92.5	91.85	92.01	35380.0
2018-03-02 08:30:00	MSFT	Stock	91.82	92.25	91.82	92.1	32268.0
2018-03-02 09:00:00	MSFT	Stock	92.05	92.06	91.5	91.51	37810.0
2018-03-02 09:30:00	MSFT	Stock	91.58	91.93	90.86	91.65	4517447.0
2018-03-02 10:00:00	MSFT	Stock	91.66	91.98	91.21	91.505	2309140.0
2018-03-02 10:30:00	MSFT	Stock	91.505	92.14	91.42	91.805	1845326.0
2018-03-02 11:00:00	MSFT	Stock	91.8	92.09	91.46	92.04	1388970.0
2018-03-02 11:30:00	MSFT	Stock	92.04	92.36	91.72	92.354	1454844.0
2018-03-02 12:00:00	MSFT	Stock	92.34	92.5	92.09	92.33	1393413.0
2018-03-02 12:30:00	MSFT	Stock	92.34	92.38	91.97	92.25	1698109.0
2018-03-02 13:00:00	MSFT	Stock	92.24	92.31	91.63	91.64	1239296.0

> showing 50 of 83,134 rows — these rows as CSV

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