PREVIEW / stock_30min / 2017-06-02

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-02.parquet
  size:    1.6 MB
  rows:    81,520
  symbols: 3,035

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-06-02 04:00:00	AAPL	Stock	38.41	38.41	38.41	38.41	2000.0
2017-06-02 05:30:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	3828.0
2017-06-02 06:00:00	AAPL	Stock	38.4575	38.4725	38.425	38.4275	11328.0
2017-06-02 06:30:00	AAPL	Stock	38.445	38.445	38.4425	38.4425	2800.0
2017-06-02 07:00:00	AAPL	Stock	38.435	38.45	38.4325	38.4375	16232.0
2017-06-02 07:30:00	AAPL	Stock	38.41	38.425	38.38	38.3825	8144.0
2017-06-02 08:00:00	AAPL	Stock	38.4375	38.45	38.3775	38.4175	78740.0
2017-06-02 08:30:00	AAPL	Stock	38.4	38.415	38.27	38.345	164680.0
2017-06-02 09:00:00	AAPL	Stock	38.3625	38.4	38.3325	38.4	154252.0
2017-06-02 09:30:00	AAPL	Stock	38.3975	38.41	38.2225	38.3225	10065924.0
2017-06-02 10:00:00	AAPL	Stock	38.3225	38.3975	38.3075	38.3862	5193820.0
2017-06-02 10:30:00	AAPL	Stock	38.3875	38.4288	38.355	38.4188	4280076.0
2017-06-02 11:00:00	AAPL	Stock	38.4175	38.47	38.4052	38.445	3875812.0
2017-06-02 11:30:00	AAPL	Stock	38.4455	38.502	38.43	38.5	3514256.0
2017-06-02 12:00:00	AAPL	Stock	38.5	38.6475	38.4988	38.645	6557400.0
2017-06-02 12:30:00	AAPL	Stock	38.6435	38.6692	38.6175	38.656	4818700.0
2017-06-02 13:00:00	AAPL	Stock	38.655	38.7625	38.65	38.735	7259152.0
2017-06-02 13:30:00	AAPL	Stock	38.7362	38.775	38.725	38.7738	5443056.0
2017-06-02 14:00:00	AAPL	Stock	38.775	38.8625	38.7675	38.7948	8794032.0
2017-06-02 14:30:00	AAPL	Stock	38.7975	38.8225	38.775	38.795	5008240.0
2017-06-02 15:00:00	AAPL	Stock	38.8	38.8	38.735	38.7612	7099744.0
2017-06-02 15:30:00	AAPL	Stock	38.7625	38.8625	38.7425	38.8625	19131428.0
2017-06-02 16:00:00	AAPL	Stock	38.8625	38.8625	38.7505	38.825	9556336.0
2017-06-02 16:30:00	AAPL	Stock	38.8625	38.8625	38.8125	38.8125	125416.0
2017-06-02 17:00:00	AAPL	Stock	38.825	38.845	38.81	38.835	50316.0
2017-06-02 17:30:00	AAPL	Stock	38.8325	38.845	38.83	38.845	29464.0
2017-06-02 18:00:00	AAPL	Stock	38.8375	38.84	38.8275	38.8375	41956.0
2017-06-02 18:30:00	AAPL	Stock	38.84	38.845	38.8225	38.83	11616.0
2017-06-02 19:00:00	AAPL	Stock	38.845	38.845	38.825	38.83	12556.0
2017-06-02 19:30:00	AAPL	Stock	38.8375	38.8375	38.825	38.8375	12368.0
2017-06-02 06:30:00	MSFT	Stock	70.39	70.39	70.39	70.39	142.0
2017-06-02 07:00:00	MSFT	Stock	70.39	70.45	70.15	70.15	372.0
2017-06-02 08:00:00	MSFT	Stock	70.25	70.25	70.25	70.25	500.0
2017-06-02 08:30:00	MSFT	Stock	70.14	70.2	70.1	70.2	3544.0
2017-06-02 09:00:00	MSFT	Stock	70.2	70.45	70.2	70.4	11526.0
2017-06-02 09:30:00	MSFT	Stock	70.44	70.74	70.24	70.68	3448276.0
2017-06-02 10:00:00	MSFT	Stock	70.68	70.877	70.67	70.83	2003690.0
2017-06-02 10:30:00	MSFT	Stock	70.84	70.98	70.725	70.94	1834003.0
2017-06-02 11:00:00	MSFT	Stock	70.94	71.14	70.93	71.085	2283972.0
2017-06-02 11:30:00	MSFT	Stock	71.08	71.33	71.04	71.3	1265418.0
2017-06-02 12:00:00	MSFT	Stock	71.3	71.305	71.15	71.18	934410.0
2017-06-02 12:30:00	MSFT	Stock	71.17	71.37	71.17	71.35	1207589.0
2017-06-02 13:00:00	MSFT	Stock	71.34	71.54	71.3	71.5	1074792.0
2017-06-02 13:30:00	MSFT	Stock	71.51	71.63	71.505	71.535	1327060.0
2017-06-02 14:00:00	MSFT	Stock	71.535	71.56	71.39	71.391	1361514.0
2017-06-02 14:30:00	MSFT	Stock	71.4	71.58	71.39	71.54	1836930.0
2017-06-02 15:00:00	MSFT	Stock	71.55	71.73	71.485	71.69	2521044.0
2017-06-02 15:30:00	MSFT	Stock	71.69	71.86	71.68	71.75	7863041.0
2017-06-02 16:00:00	MSFT	Stock	71.75	71.8	71.75	71.75	3122761.0
2017-06-02 16:30:00	MSFT	Stock	71.75	71.79	71.72	71.79	17322.0

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

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