PREVIEW / stock_30min / 2019-02-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-20.parquet
  size:    1.7 MB
  rows:    84,526
  symbols: 2,693

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-20 04:00:00	AAPL	Stock	42.7375	42.7375	42.7375	42.7375	544.0
2019-02-20 04:30:00	AAPL	Stock	42.675	42.7425	42.675	42.675	8144.0
2019-02-20 05:00:00	AAPL	Stock	42.69	42.69	42.69	42.69	400.0
2019-02-20 05:30:00	AAPL	Stock	42.7425	42.7425	42.74	42.74	800.0
2019-02-20 06:00:00	AAPL	Stock	42.6875	42.6875	42.675	42.675	5576.0
2019-02-20 06:30:00	AAPL	Stock	42.6525	42.6525	42.58	42.58	6412.0
2019-02-20 07:00:00	AAPL	Stock	42.685	42.7	42.66	42.7	44684.0
2019-02-20 07:30:00	AAPL	Stock	42.6875	42.72	42.655	42.6675	21600.0
2019-02-20 08:00:00	AAPL	Stock	42.6625	42.8375	42.6075	42.625	67600.0
2019-02-20 08:30:00	AAPL	Stock	42.6375	42.8	42.625	42.725	114860.0
2019-02-20 09:00:00	AAPL	Stock	42.7325	42.85	42.695	42.7775	94016.0
2019-02-20 09:30:00	AAPL	Stock	42.7975	43.055	42.7475	43.02	12620544.0
2019-02-20 10:00:00	AAPL	Stock	43.0212	43.33	42.9675	43.2975	9845824.0
2019-02-20 10:30:00	AAPL	Stock	43.295	43.3075	43.1675	43.18	6122624.0
2019-02-20 11:00:00	AAPL	Stock	43.1825	43.24	43.1325	43.2075	4769512.0
2019-02-20 11:30:00	AAPL	Stock	43.2075	43.2275	43.135	43.16	3213876.0
2019-02-20 12:00:00	AAPL	Stock	43.1625	43.1825	42.915	42.915	4548200.0
2019-02-20 12:30:00	AAPL	Stock	42.9225	43.0212	42.9025	42.9775	3421732.0
2019-02-20 13:00:00	AAPL	Stock	42.9775	43.1075	42.97	43.1062	2782696.0
2019-02-20 13:30:00	AAPL	Stock	43.106	43.1175	43.0175	43.0975	2519644.0
2019-02-20 14:00:00	AAPL	Stock	43.0965	43.2075	42.8375	42.9375	8264752.0
2019-02-20 14:30:00	AAPL	Stock	42.935	43.1025	42.9325	43.0625	4548812.0
2019-02-20 15:00:00	AAPL	Stock	43.065	43.075	43.0	43.0075	3058392.0
2019-02-20 15:30:00	AAPL	Stock	43.01	43.0925	42.91	43.0225	7042380.0
2019-02-20 16:00:00	AAPL	Stock	43.0075	43.0765	42.9475	42.9975	6999492.0
2019-02-20 16:30:00	AAPL	Stock	42.995	43.0	42.9825	42.9825	25604.0
2019-02-20 17:00:00	AAPL	Stock	43.0	43.0	42.98	42.98	14136.0
2019-02-20 17:30:00	AAPL	Stock	43.0075	43.0075	42.9775	42.9975	3116300.0
2019-02-20 18:00:00	AAPL	Stock	43.0	43.0	42.975	42.975	4544.0
2019-02-20 18:30:00	AAPL	Stock	42.98	42.9975	42.98	42.9975	1600.0
2019-02-20 19:00:00	AAPL	Stock	42.995	42.9975	42.975	42.975	13752.0
2019-02-20 19:30:00	AAPL	Stock	42.995	42.995	42.9725	42.9725	11272.0
2019-02-20 06:30:00	MSFT	Stock	107.79	107.85	107.76	107.76	850.0
2019-02-20 07:00:00	MSFT	Stock	107.79	107.87	107.79	107.81	3665.0
2019-02-20 07:30:00	MSFT	Stock	107.85	107.88	107.82	107.85	2762.0
2019-02-20 08:00:00	MSFT	Stock	107.601	107.84	107.601	107.78	5990.0
2019-02-20 08:30:00	MSFT	Stock	107.8	107.96	107.8	107.88	12208.0
2019-02-20 09:00:00	MSFT	Stock	107.92	107.95	107.86	107.86	5576.0
2019-02-20 09:30:00	MSFT	Stock	107.86	107.94	107.36	107.69	1836340.0
2019-02-20 10:00:00	MSFT	Stock	107.71	107.79	107.45	107.56	1220531.0
2019-02-20 10:30:00	MSFT	Stock	107.56	107.71	107.447	107.47	1153440.0
2019-02-20 11:00:00	MSFT	Stock	107.48	107.58	107.33	107.415	1056457.0
2019-02-20 11:30:00	MSFT	Stock	107.41	107.43	107.25	107.325	890859.0
2019-02-20 12:00:00	MSFT	Stock	107.321	107.39	106.36	106.37	1362132.0
2019-02-20 12:30:00	MSFT	Stock	106.37	106.677	106.29	106.56	1256056.0
2019-02-20 13:00:00	MSFT	Stock	106.56	106.91	106.54	106.906	728404.0
2019-02-20 13:30:00	MSFT	Stock	106.905	107.04	106.715	106.985	596690.0
2019-02-20 14:00:00	MSFT	Stock	106.98	107.31	106.34	106.56	1429720.0
2019-02-20 14:30:00	MSFT	Stock	106.56	107.11	106.549	107.03	956396.0
2019-02-20 15:00:00	MSFT	Stock	107.03	107.28	106.93	107.08	863252.0

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

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