PREVIEW / stock_30min / 2018-10-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-02.parquet
  size:    1.7 MB
  rows:    84,415
  symbols: 2,786

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-10-02 06:00:00	AAPL	Stock	56.4375	56.56	56.4175	56.55	13604.0
2018-10-02 06:30:00	AAPL	Stock	56.5	56.5625	56.4575	56.5175	35520.0
2018-10-02 07:00:00	AAPL	Stock	56.5375	56.675	56.5125	56.65	125164.0
2018-10-02 07:30:00	AAPL	Stock	56.6525	56.6925	56.6375	56.66	11260.0
2018-10-02 08:00:00	AAPL	Stock	56.5562	56.95	56.5562	56.765	117112.0
2018-10-02 08:30:00	AAPL	Stock	56.765	56.78	56.7125	56.75	112456.0
2018-10-02 09:00:00	AAPL	Stock	56.77	56.8275	56.725	56.8275	96700.0
2018-10-02 09:30:00	AAPL	Stock	56.8275	57.335	56.6575	57.3075	13042064.0
2018-10-02 10:00:00	AAPL	Stock	57.31	57.3575	57.14	57.2965	7108584.0
2018-10-02 10:30:00	AAPL	Stock	57.295	57.3475	57.08	57.285	5676560.0
2018-10-02 11:00:00	AAPL	Stock	57.285	57.34	57.18	57.3105	4335920.0
2018-10-02 11:30:00	AAPL	Stock	57.3125	57.4625	57.2825	57.4525	6508048.0
2018-10-02 12:00:00	AAPL	Stock	57.4525	57.47	57.335	57.435	3639044.0
2018-10-02 12:30:00	AAPL	Stock	57.4375	57.5	57.2575	57.3	4610976.0
2018-10-02 13:00:00	AAPL	Stock	57.3025	57.36	57.2542	57.3488	2612332.0
2018-10-02 13:30:00	AAPL	Stock	57.3525	57.46	57.335	57.3825	3054340.0
2018-10-02 14:00:00	AAPL	Stock	57.381	57.5	57.3605	57.4665	3374448.0
2018-10-02 14:30:00	AAPL	Stock	57.4675	57.4738	57.3375	57.3962	3623660.0
2018-10-02 15:00:00	AAPL	Stock	57.3962	57.3975	56.98	57.165	7778320.0
2018-10-02 15:30:00	AAPL	Stock	57.1675	57.435	57.1675	57.3225	8138952.0
2018-10-02 16:00:00	AAPL	Stock	57.3225	57.3625	57.1635	57.325	8589456.0
2018-10-02 16:30:00	AAPL	Stock	57.3	57.3225	57.3	57.31	23452.0
2018-10-02 17:00:00	AAPL	Stock	57.315	57.315	57.275	57.3	9992.0
2018-10-02 17:30:00	AAPL	Stock	57.3075	57.3225	57.2775	57.29	5440.0
2018-10-02 18:00:00	AAPL	Stock	57.3125	57.3375	57.3125	57.325	6944.0
2018-10-02 18:30:00	AAPL	Stock	57.335	57.3625	57.325	57.36	16696.0
2018-10-02 19:00:00	AAPL	Stock	57.3475	57.3625	57.3475	57.35	27024.0
2018-10-02 19:30:00	AAPL	Stock	57.3475	57.375	57.2875	57.375	45228.0
2018-10-02 05:30:00	MSFT	Stock	115.25	115.25	115.25	115.25	475.0
2018-10-02 06:30:00	MSFT	Stock	115.37	115.38	115.37	115.38	500.0
2018-10-02 07:00:00	MSFT	Stock	115.37	115.4	115.15	115.2	2612.0
2018-10-02 07:30:00	MSFT	Stock	115.21	115.44	115.21	115.44	949.0
2018-10-02 08:00:00	MSFT	Stock	115.37	115.4	115.21	115.4	1409.0
2018-10-02 08:30:00	MSFT	Stock	115.4	115.4	115.38	115.39	2727.0
2018-10-02 09:00:00	MSFT	Stock	115.3	115.47	115.15	115.15	4416.0
2018-10-02 09:30:00	MSFT	Stock	115.3	115.5	114.44	115.132	2304326.0
2018-10-02 10:00:00	MSFT	Stock	115.14	115.393	114.98	115.39	1142654.0
2018-10-02 10:30:00	MSFT	Stock	115.39	115.59	115.07	115.38	1237380.0
2018-10-02 11:00:00	MSFT	Stock	115.38	115.71	115.26	115.56	867819.0
2018-10-02 11:30:00	MSFT	Stock	115.57	115.84	115.47	115.755	782500.0
2018-10-02 12:00:00	MSFT	Stock	115.76	115.84	115.54	115.63	647962.0
2018-10-02 12:30:00	MSFT	Stock	115.637	115.77	115.26	115.41	564067.0
2018-10-02 13:00:00	MSFT	Stock	115.41	115.6	115.375	115.58	425898.0
2018-10-02 13:30:00	MSFT	Stock	115.58	115.74	115.45	115.495	465915.0
2018-10-02 14:00:00	MSFT	Stock	115.5	115.67	115.46	115.605	546930.0
2018-10-02 14:30:00	MSFT	Stock	115.6	115.62	115.33	115.448	641906.0
2018-10-02 15:00:00	MSFT	Stock	115.45	115.45	114.78	114.99	1442792.0
2018-10-02 15:30:00	MSFT	Stock	114.99	115.52	114.99	115.14	2210653.0
2018-10-02 16:00:00	MSFT	Stock	115.15	115.605	115.01	115.17	4965062.0
2018-10-02 16:30:00	MSFT	Stock	115.17	115.25	115.17	115.25	2010.0

> showing 50 of 84,415 rows — these rows as CSV

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