PREVIEW / stock_30min / 2018-12-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-24.parquet
  size:    1.1 MB
  rows:    51,880
  symbols: 2,694

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
2018-12-24 04:00:00	AAPL	Stock	37.6575	38.4325	37.6575	37.875	20496.0
2018-12-24 04:30:00	AAPL	Stock	37.875	37.9	37.8125	37.8625	4336.0
2018-12-24 05:00:00	AAPL	Stock	37.8125	37.8125	37.8125	37.8125	1200.0
2018-12-24 05:30:00	AAPL	Stock	37.82	37.8775	37.8125	37.8775	3936.0
2018-12-24 06:00:00	AAPL	Stock	37.8725	37.8725	37.75	37.8125	11856.0
2018-12-24 06:30:00	AAPL	Stock	37.865	37.875	37.725	37.725	24124.0
2018-12-24 07:00:00	AAPL	Stock	37.7	37.7325	37.2075	37.3375	217340.0
2018-12-24 07:30:00	AAPL	Stock	37.325	37.4	37.225	37.25	259056.0
2018-12-24 08:00:00	AAPL	Stock	37.3125	37.8	37.19	37.3725	693924.0
2018-12-24 08:30:00	AAPL	Stock	37.3675	37.3725	37.22	37.22	406536.0
2018-12-24 09:00:00	AAPL	Stock	37.245	37.3125	37.005	37.0375	851688.0
2018-12-24 09:30:00	AAPL	Stock	37.0375	37.5425	36.855	37.1072	35191256.0
2018-12-24 10:00:00	AAPL	Stock	37.1062	37.4575	36.815	37.406	21508956.0
2018-12-24 10:30:00	AAPL	Stock	37.41	37.8875	37.405	37.6875	17325984.0
2018-12-24 11:00:00	AAPL	Stock	37.6925	37.84	37.2032	37.265	9796200.0
2018-12-24 11:30:00	AAPL	Stock	37.255	37.4375	37.05	37.1375	8460536.0
2018-12-24 12:00:00	AAPL	Stock	37.1375	37.2675	36.995	37.075	8892764.0
2018-12-24 12:30:00	AAPL	Stock	37.083	37.1775	36.65	36.65	17410672.0
2018-12-24 13:00:00	AAPL	Stock	36.6475	36.885	36.625	36.65	10431692.0
2018-12-24 13:30:00	AAPL	Stock	36.65	36.6875	36.575	36.575	170396.0
2018-12-24 14:00:00	AAPL	Stock	36.57	36.6775	36.54	36.62	224624.0
2018-12-24 14:30:00	AAPL	Stock	36.625	36.6875	36.605	36.64	67080.0
2018-12-24 15:00:00	AAPL	Stock	36.6275	36.69	36.6125	36.69	21276.0
2018-12-24 15:30:00	AAPL	Stock	36.6618	36.69	36.6325	36.6625	19252.0
2018-12-24 16:00:00	AAPL	Stock	36.6675	36.6875	36.665	36.67	5420.0
2018-12-24 16:30:00	AAPL	Stock	36.685	36.6875	36.6325	36.6875	16076.0
2018-12-24 05:30:00	MSFT	Stock	98.6	98.6	98.6	98.6	200.0
2018-12-24 06:00:00	MSFT	Stock	98.7	98.71	98.55	98.7	550.0
2018-12-24 06:30:00	MSFT	Stock	98.85	98.95	98.79	98.79	4200.0
2018-12-24 07:00:00	MSFT	Stock	98.65	98.74	97.42	97.43	17376.0
2018-12-24 07:30:00	MSFT	Stock	97.83	98.0	97.25	97.25	15003.0
2018-12-24 08:00:00	MSFT	Stock	98.4	98.69	97.12	97.85	52048.0
2018-12-24 08:30:00	MSFT	Stock	97.763	97.85	97.37	97.55	21193.0
2018-12-24 09:00:00	MSFT	Stock	97.5	98.0	97.5	97.62	47392.0
2018-12-24 09:30:00	MSFT	Stock	97.68	97.97	94.53	95.72	8402651.0
2018-12-24 10:00:00	MSFT	Stock	95.72	96.63	94.86	96.55	5961344.0
2018-12-24 10:30:00	MSFT	Stock	96.56	97.85	96.06	96.76	4926820.0
2018-12-24 11:00:00	MSFT	Stock	96.77	97.01	95.69	95.89	3317388.0
2018-12-24 11:30:00	MSFT	Stock	95.875	96.11	94.93	95.16	3635324.0
2018-12-24 12:00:00	MSFT	Stock	95.155	95.63	94.747	95.1	4130425.0
2018-12-24 12:30:00	MSFT	Stock	95.11	95.46	93.98	94.01	5513290.0
2018-12-24 13:00:00	MSFT	Stock	94.0	94.7	93.75	94.035	3655373.0
2018-12-24 13:30:00	MSFT	Stock	94.01	94.05	93.85	93.85	17274.0
2018-12-24 14:00:00	MSFT	Stock	93.88	93.9	93.67	93.8	8853.0
2018-12-24 14:30:00	MSFT	Stock	93.8	93.85	93.76	93.76	15516.0
2018-12-24 15:00:00	MSFT	Stock	93.8	93.9	93.8	93.836	13255.0
2018-12-24 15:30:00	MSFT	Stock	93.83	93.95	93.76	93.78	2021.0
2018-12-24 16:00:00	MSFT	Stock	93.95	93.98	93.95	93.98	800.0
2018-12-24 16:30:00	MSFT	Stock	93.84	93.84	93.8	93.8	580.0
2018-12-24 04:00:00	NVDA	Stock	3.25	3.25	3.25	3.25	4000.0

> showing 50 of 51,880 rows — these rows as CSV

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