PREVIEW / stock_30min / 2017-10-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-19.parquet
  size:    1.6 MB
  rows:    81,733
  symbols: 2,924

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-10-19 04:00:00	AAPL	Stock	39.625	39.625	39.2125	39.375	26640.0
2017-10-19 04:30:00	AAPL	Stock	39.425	39.425	39.275	39.42	26584.0
2017-10-19 05:00:00	AAPL	Stock	39.3625	39.3725	39.3575	39.3575	7700.0
2017-10-19 05:30:00	AAPL	Stock	39.3575	39.36	39.3125	39.3375	26320.0
2017-10-19 06:00:00	AAPL	Stock	39.335	39.3375	39.255	39.2575	44540.0
2017-10-19 06:30:00	AAPL	Stock	39.3025	39.3175	39.25	39.2875	94640.0
2017-10-19 07:00:00	AAPL	Stock	39.3175	39.4	39.265	39.3725	269956.0
2017-10-19 07:30:00	AAPL	Stock	39.3725	39.4425	39.3	39.37	394312.0
2017-10-19 08:00:00	AAPL	Stock	39.37	39.425	39.2125	39.25	608516.0
2017-10-19 08:30:00	AAPL	Stock	39.25	39.3225	39.2325	39.2825	371028.0
2017-10-19 09:00:00	AAPL	Stock	39.2825	39.3225	39.1625	39.1625	552864.0
2017-10-19 09:30:00	AAPL	Stock	39.1875	39.27	38.9125	38.9825	30747892.0
2017-10-19 10:00:00	AAPL	Stock	38.98	39.0538	38.815	38.998	15865792.0
2017-10-19 10:30:00	AAPL	Stock	39.0	39.015	38.8762	38.9875	9619508.0
2017-10-19 11:00:00	AAPL	Stock	38.9875	38.9938	38.89	38.9263	6656196.0
2017-10-19 11:30:00	AAPL	Stock	38.9263	39.005	38.8375	38.855	7839940.0
2017-10-19 12:00:00	AAPL	Stock	38.8525	38.9725	38.815	38.9263	8892544.0
2017-10-19 12:30:00	AAPL	Stock	38.93	38.93	38.7625	38.766	7446432.0
2017-10-19 13:00:00	AAPL	Stock	38.7662	38.855	38.755	38.8382	6571936.0
2017-10-19 13:30:00	AAPL	Stock	38.84	38.96	38.825	38.8675	5998444.0
2017-10-19 14:00:00	AAPL	Stock	38.8668	38.875	38.795	38.8	4420476.0
2017-10-19 14:30:00	AAPL	Stock	38.7975	38.8975	38.795	38.8688	5424036.0
2017-10-19 15:00:00	AAPL	Stock	38.87	39.0	38.8675	38.9782	7662044.0
2017-10-19 15:30:00	AAPL	Stock	38.98	39.005	38.88	38.995	13569724.0
2017-10-19 16:00:00	AAPL	Stock	38.995	39.0175	38.8125	38.995	20920252.0
2017-10-19 16:30:00	AAPL	Stock	38.995	39.0025	38.9875	39.0025	75700.0
2017-10-19 17:00:00	AAPL	Stock	39.0025	39.015	38.9725	38.995	171752.0
2017-10-19 17:30:00	AAPL	Stock	38.975	38.9775	38.925	38.94	39396.0
2017-10-19 18:00:00	AAPL	Stock	38.935	38.935	38.8825	38.9	53596.0
2017-10-19 18:30:00	AAPL	Stock	38.9	38.91	38.8525	38.9	66532.0
2017-10-19 19:00:00	AAPL	Stock	38.89	38.925	38.88	38.9125	15836.0
2017-10-19 19:30:00	AAPL	Stock	38.8875	38.9	38.8825	38.9	23824.0
2017-10-19 04:00:00	MSFT	Stock	77.99	77.99	77.25	77.35	6488.0
2017-10-19 06:00:00	MSFT	Stock	77.48	77.48	77.48	77.48	2657.0
2017-10-19 06:30:00	MSFT	Stock	77.24	77.24	77.11	77.11	3100.0
2017-10-19 07:00:00	MSFT	Stock	77.3	77.3	77.18	77.2	10662.0
2017-10-19 07:30:00	MSFT	Stock	77.24	77.25	77.18	77.18	3265.0
2017-10-19 08:00:00	MSFT	Stock	77.2	77.35	77.18	77.26	4989.0
2017-10-19 08:30:00	MSFT	Stock	77.21	77.38	77.2	77.38	10925.0
2017-10-19 09:00:00	MSFT	Stock	77.26	77.54	77.26	77.46	3958.0
2017-10-19 09:30:00	MSFT	Stock	77.48	77.85	77.35	77.56	1836108.0
2017-10-19 10:00:00	MSFT	Stock	77.57	77.64	77.38	77.6	1032862.0
2017-10-19 10:30:00	MSFT	Stock	77.6	77.78	77.47	77.771	1014509.0
2017-10-19 11:00:00	MSFT	Stock	77.77	77.78	77.68	77.74	687320.0
2017-10-19 11:30:00	MSFT	Stock	77.74	77.83	77.68	77.73	672373.0
2017-10-19 12:00:00	MSFT	Stock	77.73	77.767	77.66	77.765	488528.0
2017-10-19 12:30:00	MSFT	Stock	77.76	77.765	77.58	77.695	462712.0
2017-10-19 13:00:00	MSFT	Stock	77.694	77.72	77.63	77.696	478377.0
2017-10-19 13:30:00	MSFT	Stock	77.695	77.71	77.64	77.66	474887.0
2017-10-19 14:00:00	MSFT	Stock	77.66	77.74	77.63	77.645	503018.0

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

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