PREVIEW / stock_30min / 2018-01-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-19.parquet
  size:    1.7 MB
  rows:    84,798
  symbols: 2,901

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-01-19 04:00:00	AAPL	Stock	44.725	44.875	44.725	44.875	6696.0
2018-01-19 04:30:00	AAPL	Stock	44.9175	44.9425	44.9175	44.9425	6280.0
2018-01-19 05:00:00	AAPL	Stock	44.8875	44.8875	44.88	44.88	3800.0
2018-01-19 06:00:00	AAPL	Stock	44.88	44.88	44.8725	44.8725	3860.0
2018-01-19 06:30:00	AAPL	Stock	44.8725	44.875	44.815	44.8225	51964.0
2018-01-19 07:00:00	AAPL	Stock	44.815	44.84	44.75	44.8125	100952.0
2018-01-19 07:30:00	AAPL	Stock	44.8125	44.83	44.79	44.8125	37860.0
2018-01-19 08:00:00	AAPL	Stock	44.825	44.85	44.75	44.75	198404.0
2018-01-19 08:30:00	AAPL	Stock	44.7425	44.7675	44.685	44.7125	152152.0
2018-01-19 09:00:00	AAPL	Stock	44.725	44.755	44.5625	44.6525	712004.0
2018-01-19 09:30:00	AAPL	Stock	44.63	44.895	44.5925	44.6875	22719320.0
2018-01-19 10:00:00	AAPL	Stock	44.6875	44.69	44.44	44.5275	9382716.0
2018-01-19 10:30:00	AAPL	Stock	44.53	44.545	44.3925	44.46	6830240.0
2018-01-19 11:00:00	AAPL	Stock	44.4575	44.5775	44.3525	44.5688	6361364.0
2018-01-19 11:30:00	AAPL	Stock	44.5688	44.6525	44.5	44.5108	5696616.0
2018-01-19 12:00:00	AAPL	Stock	44.5075	44.6	44.5035	44.5962	3040164.0
2018-01-19 12:30:00	AAPL	Stock	44.595	44.662	44.585	44.61	3302140.0
2018-01-19 13:00:00	AAPL	Stock	44.6125	44.6718	44.6125	44.6425	2647596.0
2018-01-19 13:30:00	AAPL	Stock	44.645	44.6475	44.575	44.5825	2630084.0
2018-01-19 14:00:00	AAPL	Stock	44.5825	44.645	44.5625	44.6075	3345336.0
2018-01-19 14:30:00	AAPL	Stock	44.61	44.6275	44.565	44.6115	2793040.0
2018-01-19 15:00:00	AAPL	Stock	44.6125	44.65	44.5762	44.6275	3856808.0
2018-01-19 15:30:00	AAPL	Stock	44.63	44.6475	44.49	44.6125	13265672.0
2018-01-19 16:00:00	AAPL	Stock	44.615	44.655	44.5585	44.625	26595768.0
2018-01-19 16:30:00	AAPL	Stock	44.6375	44.64	44.615	44.64	76996.0
2018-01-19 17:00:00	AAPL	Stock	44.6275	44.65	44.615	44.65	7324.0
2018-01-19 17:30:00	AAPL	Stock	44.65	44.6525	44.615	44.6525	694960.0
2018-01-19 18:00:00	AAPL	Stock	44.6325	44.65	44.6325	44.6425	4184.0
2018-01-19 18:30:00	AAPL	Stock	44.645	44.66	44.64	44.66	10000.0
2018-01-19 19:00:00	AAPL	Stock	44.6625	44.6625	44.65	44.6575	19160.0
2018-01-19 19:30:00	AAPL	Stock	44.655	44.675	44.65	44.67	49908.0
2018-01-19 04:00:00	MSFT	Stock	90.23	90.23	90.23	90.23	216.0
2018-01-19 05:30:00	MSFT	Stock	90.55	90.55	90.55	90.55	100.0
2018-01-19 06:00:00	MSFT	Stock	90.55	90.55	90.55	90.55	216.0
2018-01-19 06:30:00	MSFT	Stock	90.68	90.68	90.56	90.56	516.0
2018-01-19 07:00:00	MSFT	Stock	90.55	90.61	90.55	90.61	3749.0
2018-01-19 07:30:00	MSFT	Stock	90.6	90.6	90.43	90.43	2240.0
2018-01-19 08:00:00	MSFT	Stock	90.6	90.74	90.4	90.4	4815.0
2018-01-19 08:30:00	MSFT	Stock	90.4	90.44	90.3	90.44	12114.0
2018-01-19 09:00:00	MSFT	Stock	90.34	90.57	90.11	90.11	45278.0
2018-01-19 09:30:00	MSFT	Stock	90.12	90.61	89.98	90.0	6128357.0
2018-01-19 10:00:00	MSFT	Stock	90.005	90.26	89.66	90.19	1796121.0
2018-01-19 10:30:00	MSFT	Stock	90.2	90.255	89.86	89.945	1241831.0
2018-01-19 11:00:00	MSFT	Stock	89.94	90.04	89.85	90.0	805747.0
2018-01-19 11:30:00	MSFT	Stock	90.0	90.03	89.8	89.845	860359.0
2018-01-19 12:00:00	MSFT	Stock	89.85	89.91	89.81	89.85	632868.0
2018-01-19 12:30:00	MSFT	Stock	89.854	90.0	89.8	89.9	663211.0
2018-01-19 13:00:00	MSFT	Stock	89.895	89.94	89.8	89.921	502535.0
2018-01-19 13:30:00	MSFT	Stock	89.93	89.94	89.84	89.84	528816.0
2018-01-19 14:00:00	MSFT	Stock	89.845	89.98	89.83	89.895	995102.0

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

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