PREVIEW / stock_30min / 2019-01-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-16.parquet
  size:    1.7 MB
  rows:    83,889
  symbols: 2,684

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-01-16 04:00:00	AAPL	Stock	38.375	38.415	38.3125	38.3225	10508.0
2019-01-16 04:30:00	AAPL	Stock	38.3	38.3	38.275	38.275	2764.0
2019-01-16 05:30:00	AAPL	Stock	38.3025	38.3025	38.235	38.235	7788.0
2019-01-16 06:00:00	AAPL	Stock	38.205	38.205	38.15	38.15	10088.0
2019-01-16 06:30:00	AAPL	Stock	38.2375	38.2375	38.2375	38.2375	800.0
2019-01-16 07:00:00	AAPL	Stock	38.2475	38.25	38.195	38.2325	60068.0
2019-01-16 07:30:00	AAPL	Stock	38.245	38.35	38.245	38.3	100980.0
2019-01-16 08:00:00	AAPL	Stock	38.275	38.345	38.2	38.275	277712.0
2019-01-16 08:30:00	AAPL	Stock	38.3	38.3	38.23	38.23	276128.0
2019-01-16 09:00:00	AAPL	Stock	38.2325	38.2725	38.19	38.2625	199936.0
2019-01-16 09:30:00	AAPL	Stock	38.25	38.97	38.25	38.8125	20659224.0
2019-01-16 10:00:00	AAPL	Stock	38.813	38.9375	38.655	38.68	12745096.0
2019-01-16 10:30:00	AAPL	Stock	38.6775	38.765	38.5825	38.73	8594940.0
2019-01-16 11:00:00	AAPL	Stock	38.7325	38.8475	38.5975	38.76	7496384.0
2019-01-16 11:30:00	AAPL	Stock	38.7588	38.8075	38.6575	38.6862	5354560.0
2019-01-16 12:00:00	AAPL	Stock	38.6875	38.74	38.625	38.67	4056400.0
2019-01-16 12:30:00	AAPL	Stock	38.6725	38.7925	38.6425	38.7775	3560376.0
2019-01-16 13:00:00	AAPL	Stock	38.7775	38.7775	38.6825	38.745	3561436.0
2019-01-16 13:30:00	AAPL	Stock	38.745	38.8375	38.7425	38.8175	3800960.0
2019-01-16 14:00:00	AAPL	Stock	38.816	38.8525	38.7525	38.795	3947264.0
2019-01-16 14:30:00	AAPL	Stock	38.795	38.85	38.75	38.79	4372116.0
2019-01-16 15:00:00	AAPL	Stock	38.79	38.845	38.765	38.805	3859000.0
2019-01-16 15:30:00	AAPL	Stock	38.8062	38.82	38.6475	38.73	12588952.0
2019-01-16 16:00:00	AAPL	Stock	38.735	38.755	38.625	38.6575	8503288.0
2019-01-16 16:30:00	AAPL	Stock	38.655	38.735	38.3725	38.665	1587300.0
2019-01-16 17:00:00	AAPL	Stock	38.6625	38.6625	38.625	38.6475	10268.0
2019-01-16 17:30:00	AAPL	Stock	38.655	38.707	38.655	38.707	19432.0
2019-01-16 18:00:00	AAPL	Stock	38.6725	38.6725	38.655	38.6725	17524.0
2019-01-16 18:30:00	AAPL	Stock	38.6675	38.675	38.655	38.655	15864.0
2019-01-16 19:00:00	AAPL	Stock	38.655	38.655	38.5875	38.625	31168.0
2019-01-16 19:30:00	AAPL	Stock	38.6375	38.6625	38.5875	38.6125	10872.0
2019-01-16 04:00:00	MSFT	Stock	105.21	105.21	105.02	105.02	1495.0
2019-01-16 04:30:00	MSFT	Stock	104.85	104.85	104.85	104.85	100.0
2019-01-16 05:00:00	MSFT	Stock	105.0	105.2	105.0	105.14	800.0
2019-01-16 06:00:00	MSFT	Stock	104.98	104.98	104.98	104.98	400.0
2019-01-16 07:00:00	MSFT	Stock	105.04	105.23	104.99	105.1	6046.0
2019-01-16 07:30:00	MSFT	Stock	105.11	105.35	105.1	105.2	14816.0
2019-01-16 08:00:00	MSFT	Stock	104.9	105.35	104.9	105.1	10614.0
2019-01-16 08:30:00	MSFT	Stock	105.17	105.2	105.01	105.2	65767.0
2019-01-16 09:00:00	MSFT	Stock	105.2	105.41	105.2	105.38	15664.0
2019-01-16 09:30:00	MSFT	Stock	105.3	106.11	105.26	106.1	4271617.0
2019-01-16 10:00:00	MSFT	Stock	106.105	106.255	105.54	105.67	2630743.0
2019-01-16 10:30:00	MSFT	Stock	105.67	105.7	104.99	105.119	2425062.0
2019-01-16 11:00:00	MSFT	Stock	105.12	105.54	104.96	105.53	1658535.0
2019-01-16 11:30:00	MSFT	Stock	105.53	105.71	105.06	105.25	1204787.0
2019-01-16 12:00:00	MSFT	Stock	105.26	105.41	105.07	105.21	1136620.0
2019-01-16 12:30:00	MSFT	Stock	105.21	105.472	104.99	105.4	1090002.0
2019-01-16 13:00:00	MSFT	Stock	105.395	105.406	105.1	105.118	895296.0
2019-01-16 13:30:00	MSFT	Stock	105.12	105.28	105.09	105.2	840256.0
2019-01-16 14:00:00	MSFT	Stock	105.209	105.49	105.07	105.48	925563.0

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

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