PREVIEW / stock_30min / 2019-02-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-07.parquet
  size:    1.7 MB
  rows:    82,930
  symbols: 2,645

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-07 04:00:00	AAPL	Stock	43.4025	43.4025	43.4025	43.4025	400.0
2019-02-07 05:00:00	AAPL	Stock	43.4225	43.445	43.265	43.265	11952.0
2019-02-07 06:00:00	AAPL	Stock	43.305	43.3275	43.225	43.2275	19004.0
2019-02-07 06:30:00	AAPL	Stock	43.25	43.2725	43.2175	43.24	14380.0
2019-02-07 07:00:00	AAPL	Stock	43.275	43.345	43.2425	43.3	60032.0
2019-02-07 07:30:00	AAPL	Stock	43.3	43.3125	43.0725	43.1	244888.0
2019-02-07 08:00:00	AAPL	Stock	43.3	43.6675	43.0	43.0875	343796.0
2019-02-07 08:30:00	AAPL	Stock	43.075	43.125	43.075	43.0875	213796.0
2019-02-07 09:00:00	AAPL	Stock	43.1	43.135	43.025	43.0625	164348.0
2019-02-07 09:30:00	AAPL	Stock	43.0925	43.2975	42.95	43.28	14379212.0
2019-02-07 10:00:00	AAPL	Stock	43.28	43.46	43.1425	43.4225	8847116.0
2019-02-07 10:30:00	AAPL	Stock	43.4225	43.485	43.13	43.135	7380316.0
2019-02-07 11:00:00	AAPL	Stock	43.1375	43.2028	42.9425	42.95	9187928.0
2019-02-07 11:30:00	AAPL	Stock	42.95	42.955	42.77	42.8032	8947984.0
2019-02-07 12:00:00	AAPL	Stock	42.8	42.9175	42.72	42.8625	6293624.0
2019-02-07 12:30:00	AAPL	Stock	42.8625	42.9475	42.585	42.68	7542388.0
2019-02-07 13:00:00	AAPL	Stock	42.675	42.8375	42.645	42.7275	5393712.0
2019-02-07 13:30:00	AAPL	Stock	42.7312	42.83	42.6925	42.7925	4555388.0
2019-02-07 14:00:00	AAPL	Stock	42.7875	42.8125	42.6725	42.795	4128888.0
2019-02-07 14:30:00	AAPL	Stock	42.8025	42.845	42.72	42.745	3640328.0
2019-02-07 15:00:00	AAPL	Stock	42.7435	42.7925	42.6425	42.6625	5293484.0
2019-02-07 15:30:00	AAPL	Stock	42.66	42.76	42.6175	42.7475	12801896.0
2019-02-07 16:00:00	AAPL	Stock	42.7475	43.2875	42.735	42.745	8429384.0
2019-02-07 16:30:00	AAPL	Stock	42.7525	42.77	42.74	42.7675	36392.0
2019-02-07 17:00:00	AAPL	Stock	42.7525	42.77	42.7475	42.75	50788.0
2019-02-07 17:30:00	AAPL	Stock	42.7625	42.765	42.72	42.7475	42532.0
2019-02-07 18:00:00	AAPL	Stock	42.7475	42.7475	42.665	42.6675	53792.0
2019-02-07 18:30:00	AAPL	Stock	42.6775	42.7	42.65	42.65	38884.0
2019-02-07 19:00:00	AAPL	Stock	42.6825	42.6825	42.6425	42.655	58316.0
2019-02-07 19:30:00	AAPL	Stock	42.67	42.6825	42.65	42.6725	45524.0
2019-02-07 05:00:00	MSFT	Stock	105.72	105.72	105.4	105.4	252.0
2019-02-07 05:30:00	MSFT	Stock	105.34	105.44	105.34	105.44	379.0
2019-02-07 06:00:00	MSFT	Stock	105.4	105.4	105.29	105.29	1457.0
2019-02-07 06:30:00	MSFT	Stock	105.19	105.19	105.19	105.19	200.0
2019-02-07 07:00:00	MSFT	Stock	105.19	105.4	105.19	105.28	18915.0
2019-02-07 07:30:00	MSFT	Stock	105.3	105.35	105.24	105.3	6962.0
2019-02-07 08:00:00	MSFT	Stock	105.24	106.29	105.11	105.3	28305.0
2019-02-07 08:30:00	MSFT	Stock	105.45	105.45	105.19	105.34	3771.0
2019-02-07 09:00:00	MSFT	Stock	105.25	105.4	105.04	105.1	19407.0
2019-02-07 09:30:00	MSFT	Stock	105.185	105.33	104.95	105.29	2379956.0
2019-02-07 10:00:00	MSFT	Stock	105.29	105.508	105.082	105.4	1544867.0
2019-02-07 10:30:00	MSFT	Stock	105.41	105.59	104.92	105.015	1598251.0
2019-02-07 11:00:00	MSFT	Stock	105.02	105.16	104.94	105.01	1695200.0
2019-02-07 11:30:00	MSFT	Stock	105.0	105.09	104.64	104.64	2709188.0
2019-02-07 12:00:00	MSFT	Stock	104.645	104.92	104.52	104.73	1351428.0
2019-02-07 12:30:00	MSFT	Stock	104.73	104.9	104.29	104.4	993433.0
2019-02-07 13:00:00	MSFT	Stock	104.39	104.95	104.37	104.82	1013401.0
2019-02-07 13:30:00	MSFT	Stock	104.84	105.0	104.76	104.83	867649.0
2019-02-07 14:00:00	MSFT	Stock	104.82	105.04	104.57	105.025	981914.0
2019-02-07 14:30:00	MSFT	Stock	105.03	105.14	104.97	104.99	957903.0

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

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