PREVIEW / stock_30min / 2019-02-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-12.parquet
  size:    1.7 MB
  rows:    83,380
  symbols: 2,663

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-12 04:00:00	AAPL	Stock	42.62	42.6625	42.5825	42.65	3460.0
2019-02-12 04:30:00	AAPL	Stock	42.65	42.65	42.65	42.65	2668.0
2019-02-12 05:00:00	AAPL	Stock	42.6725	42.6875	42.6725	42.6875	2552.0
2019-02-12 05:30:00	AAPL	Stock	42.6775	42.6875	42.67	42.675	16584.0
2019-02-12 06:30:00	AAPL	Stock	42.6375	42.6825	42.6375	42.675	2508.0
2019-02-12 07:00:00	AAPL	Stock	42.65	42.675	42.5975	42.605	65756.0
2019-02-12 07:30:00	AAPL	Stock	42.625	42.7025	42.6175	42.6275	61008.0
2019-02-12 08:00:00	AAPL	Stock	42.67	42.7	42.5475	42.6375	142108.0
2019-02-12 08:30:00	AAPL	Stock	42.5975	42.62	42.5325	42.5475	159004.0
2019-02-12 09:00:00	AAPL	Stock	42.57	42.61	42.5125	42.535	199108.0
2019-02-12 09:30:00	AAPL	Stock	42.5325	42.7375	42.4375	42.53	11601456.0
2019-02-12 10:00:00	AAPL	Stock	42.53	42.6625	42.425	42.4525	6717120.0
2019-02-12 10:30:00	AAPL	Stock	42.455	42.6175	42.4525	42.6048	4866752.0
2019-02-12 11:00:00	AAPL	Stock	42.6025	42.67	42.4375	42.51	7159948.0
2019-02-12 11:30:00	AAPL	Stock	42.5125	42.545	42.46	42.4675	3528484.0
2019-02-12 12:00:00	AAPL	Stock	42.4675	42.4975	42.445	42.4775	3515264.0
2019-02-12 12:30:00	AAPL	Stock	42.48	42.585	42.455	42.5025	3773328.0
2019-02-12 13:00:00	AAPL	Stock	42.4975	42.5925	42.48	42.5712	2468168.0
2019-02-12 13:30:00	AAPL	Stock	42.5725	42.6625	42.5625	42.63	3380676.0
2019-02-12 14:00:00	AAPL	Stock	42.6325	42.6475	42.5625	42.6088	2874680.0
2019-02-12 14:30:00	AAPL	Stock	42.6078	42.6625	42.5925	42.615	2912316.0
2019-02-12 15:00:00	AAPL	Stock	42.615	42.75	42.61	42.74	4477384.0
2019-02-12 15:30:00	AAPL	Stock	42.7375	42.7425	42.65	42.7225	8264680.0
2019-02-12 16:00:00	AAPL	Stock	42.7225	42.7225	42.6625	42.7225	9376012.0
2019-02-12 16:30:00	AAPL	Stock	42.73	42.735	42.7025	42.71	57048.0
2019-02-12 17:00:00	AAPL	Stock	42.72	42.7225	42.7075	42.715	9976.0
2019-02-12 17:30:00	AAPL	Stock	42.7	42.7168	42.69	42.6925	17096.0
2019-02-12 18:00:00	AAPL	Stock	42.695	42.7125	42.6925	42.71	9376.0
2019-02-12 18:30:00	AAPL	Stock	42.71	42.765	42.71	42.765	60200.0
2019-02-12 19:00:00	AAPL	Stock	42.77	42.845	42.75	42.8375	96244.0
2019-02-12 19:30:00	AAPL	Stock	42.8375	42.875	42.8125	42.875	33416.0
2019-02-12 05:00:00	MSFT	Stock	106.0	106.08	106.0	106.08	2145.0
2019-02-12 05:30:00	MSFT	Stock	106.12	106.12	106.12	106.12	100.0
2019-02-12 06:00:00	MSFT	Stock	106.12	106.12	106.12	106.12	100.0
2019-02-12 06:30:00	MSFT	Stock	106.16	106.18	106.16	106.18	350.0
2019-02-12 07:00:00	MSFT	Stock	106.1	106.25	106.04	106.21	7234.0
2019-02-12 07:30:00	MSFT	Stock	106.22	106.38	106.22	106.3	14717.0
2019-02-12 08:00:00	MSFT	Stock	106.24	106.4	106.02	106.19	31443.0
2019-02-12 08:30:00	MSFT	Stock	106.15	106.28	106.1	106.15	25556.0
2019-02-12 09:00:00	MSFT	Stock	106.17	106.2	106.02	106.1	72681.0
2019-02-12 09:30:00	MSFT	Stock	106.07	106.4	105.48	106.108	2693997.0
2019-02-12 10:00:00	MSFT	Stock	106.105	106.62	106.09	106.345	1804525.0
2019-02-12 10:30:00	MSFT	Stock	106.35	106.96	106.29	106.96	1901111.0
2019-02-12 11:00:00	MSFT	Stock	106.965	107.03	106.8	106.972	1819433.0
2019-02-12 11:30:00	MSFT	Stock	106.98	107.14	106.92	107.075	1375266.0
2019-02-12 12:00:00	MSFT	Stock	107.074	107.12	106.845	106.91	1210457.0
2019-02-12 12:30:00	MSFT	Stock	106.9	107.12	106.79	106.845	970926.0
2019-02-12 13:00:00	MSFT	Stock	106.85	106.865	106.66	106.665	917202.0
2019-02-12 13:30:00	MSFT	Stock	106.67	106.9	106.61	106.81	1201991.0
2019-02-12 14:00:00	MSFT	Stock	106.81	106.815	106.65	106.701	797330.0

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

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