PREVIEW / stock_30min / 2019-02-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-08.parquet
  size:    1.7 MB
  rows:    82,363
  symbols: 2,641

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
2019-02-08 04:00:00	AAPL	Stock	42.185	42.45	42.1675	42.425	32160.0
2019-02-08 04:30:00	AAPL	Stock	42.3775	42.3775	42.2575	42.275	12676.0
2019-02-08 05:00:00	AAPL	Stock	42.275	42.32	42.25	42.3	25184.0
2019-02-08 05:30:00	AAPL	Stock	42.3	42.3	42.225	42.25	19072.0
2019-02-08 06:00:00	AAPL	Stock	42.255	42.3125	42.25	42.25	10104.0
2019-02-08 06:30:00	AAPL	Stock	42.225	42.2375	42.105	42.1375	11296.0
2019-02-08 07:00:00	AAPL	Stock	42.2225	42.2525	42.125	42.2175	111696.0
2019-02-08 07:30:00	AAPL	Stock	42.2175	42.295	42.1875	42.2725	162308.0
2019-02-08 08:00:00	AAPL	Stock	42.13	42.84	42.125	42.3125	219496.0
2019-02-08 08:30:00	AAPL	Stock	42.325	42.3625	42.2675	42.2975	161832.0
2019-02-08 09:00:00	AAPL	Stock	42.2825	42.35	42.225	42.2275	251856.0
2019-02-08 09:30:00	AAPL	Stock	42.23	42.42	42.105	42.2975	13349172.0
2019-02-08 10:00:00	AAPL	Stock	42.295	42.505	42.22	42.4125	9043404.0
2019-02-08 10:30:00	AAPL	Stock	42.4092	42.59	42.295	42.387	6937588.0
2019-02-08 11:00:00	AAPL	Stock	42.39	42.45	42.3125	42.3625	4576204.0
2019-02-08 11:30:00	AAPL	Stock	42.3625	42.4575	42.255	42.444	4892236.0
2019-02-08 12:00:00	AAPL	Stock	42.445	42.49	42.3225	42.4188	4214408.0
2019-02-08 12:30:00	AAPL	Stock	42.42	42.51	42.4	42.45	2907596.0
2019-02-08 13:00:00	AAPL	Stock	42.4525	42.5425	42.445	42.48	3565224.0
2019-02-08 13:30:00	AAPL	Stock	42.4775	42.5765	42.4365	42.5625	3586172.0
2019-02-08 14:00:00	AAPL	Stock	42.56	42.64	42.5125	42.6262	3897668.0
2019-02-08 14:30:00	AAPL	Stock	42.625	42.665	42.5875	42.62	4153088.0
2019-02-08 15:00:00	AAPL	Stock	42.6175	42.63	42.535	42.56	4011792.0
2019-02-08 15:30:00	AAPL	Stock	42.5625	42.63	42.4575	42.625	10979368.0
2019-02-08 16:00:00	AAPL	Stock	42.6325	42.6325	42.525	42.55	7765276.0
2019-02-08 16:30:00	AAPL	Stock	42.55	42.55	42.52	42.55	179080.0
2019-02-08 17:00:00	AAPL	Stock	42.5625	42.5825	42.5375	42.575	48032.0
2019-02-08 17:30:00	AAPL	Stock	42.55	42.5675	42.55	42.5525	15884.0
2019-02-08 18:00:00	AAPL	Stock	42.5675	42.575	42.5525	42.575	11980.0
2019-02-08 18:30:00	AAPL	Stock	42.57	42.5725	42.5675	42.5725	3848.0
2019-02-08 19:00:00	AAPL	Stock	42.5725	42.5875	42.5575	42.5875	23008.0
2019-02-08 19:30:00	AAPL	Stock	42.5875	42.595	42.575	42.58	33844.0
2019-02-08 05:00:00	MSFT	Stock	104.72	104.72	104.23	104.66	1696.0
2019-02-08 05:30:00	MSFT	Stock	104.74	104.74	104.74	104.74	100.0
2019-02-08 06:30:00	MSFT	Stock	104.53	104.53	104.42	104.5	10564.0
2019-02-08 07:00:00	MSFT	Stock	104.5	104.57	104.38	104.43	8255.0
2019-02-08 07:30:00	MSFT	Stock	104.42	104.67	104.4	104.5	16383.0
2019-02-08 08:00:00	MSFT	Stock	104.38	105.53	104.38	104.62	15725.0
2019-02-08 08:30:00	MSFT	Stock	104.62	104.7	104.5	104.63	11459.0
2019-02-08 09:00:00	MSFT	Stock	104.55	104.65	104.25	104.34	13912.0
2019-02-08 09:30:00	MSFT	Stock	104.39	105.218	104.26	104.81	2576000.0
2019-02-08 10:00:00	MSFT	Stock	104.81	105.075	104.63	104.93	1578254.0
2019-02-08 10:30:00	MSFT	Stock	104.935	105.34	104.9	105.03	1382496.0
2019-02-08 11:00:00	MSFT	Stock	105.03	105.16	104.81	104.935	1279919.0
2019-02-08 11:30:00	MSFT	Stock	104.93	105.12	104.61	105.0	1078378.0
2019-02-08 12:00:00	MSFT	Stock	105.01	105.12	104.714	104.89	864044.0
2019-02-08 12:30:00	MSFT	Stock	104.894	104.93	104.71	104.77	722081.0
2019-02-08 13:00:00	MSFT	Stock	104.77	104.99	104.7	104.9	746115.0
2019-02-08 13:30:00	MSFT	Stock	104.895	104.989	104.795	104.925	594780.0
2019-02-08 14:00:00	MSFT	Stock	104.93	105.25	104.902	105.177	847166.0

> showing 50 of 82,363 rows — these rows as CSV

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