PREVIEW / stock_30min / 2016-05-25

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-25.parquet
  size:    1.6 MB
  rows:    81,451
  symbols: 3,300

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
2016-05-25 04:00:00	AAPL	Stock	24.6125	24.6875	24.6125	24.6875	27308.0
2016-05-25 04:30:00	AAPL	Stock	24.685	24.6925	24.6525	24.6925	3932.0
2016-05-25 05:00:00	AAPL	Stock	24.7225	24.7375	24.7225	24.7375	2308.0
2016-05-25 05:30:00	AAPL	Stock	24.7325	24.7375	24.675	24.7125	7360.0
2016-05-25 06:00:00	AAPL	Stock	24.7	24.7125	24.67	24.6975	18124.0
2016-05-25 06:30:00	AAPL	Stock	24.7	24.7	24.665	24.665	32492.0
2016-05-25 07:00:00	AAPL	Stock	24.67	24.675	24.605	24.6425	146132.0
2016-05-25 07:30:00	AAPL	Stock	24.625	24.6375	24.595	24.6125	71116.0
2016-05-25 08:00:00	AAPL	Stock	24.5925	24.675	24.5875	24.6375	307344.0
2016-05-25 08:30:00	AAPL	Stock	24.64	24.6625	24.6175	24.6575	202544.0
2016-05-25 09:00:00	AAPL	Stock	24.6525	24.6875	24.625	24.6375	363096.0
2016-05-25 09:30:00	AAPL	Stock	24.6675	24.6725	24.5275	24.6475	20467892.0
2016-05-25 10:00:00	AAPL	Stock	24.6475	24.7525	24.635	24.698	13985464.0
2016-05-25 10:30:00	AAPL	Stock	24.6975	24.7875	24.68	24.7275	11264612.0
2016-05-25 11:00:00	AAPL	Stock	24.7275	24.7475	24.6475	24.68	7917420.0
2016-05-25 11:30:00	AAPL	Stock	24.6775	24.7575	24.6675	24.75	6187780.0
2016-05-25 12:00:00	AAPL	Stock	24.7488	24.82	24.7375	24.8125	8101164.0
2016-05-25 12:30:00	AAPL	Stock	24.8125	24.8725	24.7875	24.8675	6269372.0
2016-05-25 13:00:00	AAPL	Stock	24.8675	24.935	24.8575	24.8875	10512084.0
2016-05-25 13:30:00	AAPL	Stock	24.8892	24.9138	24.8612	24.8825	6124484.0
2016-05-25 14:00:00	AAPL	Stock	24.8838	24.8875	24.8325	24.84	6434284.0
2016-05-25 14:30:00	AAPL	Stock	24.8375	24.8972	24.825	24.83	7182604.0
2016-05-25 15:00:00	AAPL	Stock	24.83	24.8925	24.785	24.891	8268612.0
2016-05-25 15:30:00	AAPL	Stock	24.89	24.9325	24.8725	24.9	14177032.0
2016-05-25 16:00:00	AAPL	Stock	24.905	24.905	24.87	24.8875	10884492.0
2016-05-25 16:30:00	AAPL	Stock	24.895	24.905	24.8875	24.8975	16072.0
2016-05-25 17:00:00	AAPL	Stock	24.8975	24.8975	24.88	24.8925	78992.0
2016-05-25 17:30:00	AAPL	Stock	24.8825	24.905	24.88	24.8825	1391876.0
2016-05-25 18:00:00	AAPL	Stock	24.8825	24.8975	24.8675	24.8875	48480.0
2016-05-25 18:30:00	AAPL	Stock	24.8675	24.8875	24.8675	24.875	10100.0
2016-05-25 19:00:00	AAPL	Stock	24.8775	24.8825	24.875	24.8825	9208.0
2016-05-25 19:30:00	AAPL	Stock	24.885	24.89	24.8775	24.8875	46608.0
2016-05-25 05:00:00	MSFT	Stock	51.76	51.76	51.76	51.76	2000.0
2016-05-25 06:00:00	MSFT	Stock	51.85	51.85	51.81	51.81	1299.0
2016-05-25 06:30:00	MSFT	Stock	51.81	51.81	51.8	51.8	400.0
2016-05-25 07:00:00	MSFT	Stock	51.84	51.88	51.84	51.85	2180.0
2016-05-25 07:30:00	MSFT	Stock	51.85	51.88	51.85	51.87	1250.0
2016-05-25 08:00:00	MSFT	Stock	51.87	52.0	51.82	51.96	25243.0
2016-05-25 08:30:00	MSFT	Stock	51.99	52.0	51.94	51.94	11557.0
2016-05-25 09:00:00	MSFT	Stock	51.9	52.0	51.86	51.95	27188.0
2016-05-25 09:30:00	MSFT	Stock	51.95	52.2	51.79	52.13	3337043.0
2016-05-25 10:00:00	MSFT	Stock	52.13	52.31	52.065	52.17	1872621.0
2016-05-25 10:30:00	MSFT	Stock	52.175	52.25	52.08	52.205	1637720.0
2016-05-25 11:00:00	MSFT	Stock	52.21	52.3	52.17	52.196	1527409.0
2016-05-25 11:30:00	MSFT	Stock	52.19	52.25	52.11	52.18	1100820.0
2016-05-25 12:00:00	MSFT	Stock	52.18	52.27	52.17	52.25	947777.0
2016-05-25 12:30:00	MSFT	Stock	52.25	52.35	52.215	52.345	839859.0
2016-05-25 13:00:00	MSFT	Stock	52.34	52.485	52.33	52.445	1694472.0
2016-05-25 13:30:00	MSFT	Stock	52.44	52.49	52.315	52.39	1245416.0
2016-05-25 14:00:00	MSFT	Stock	52.39	52.44	52.295	52.37	922376.0

> showing 50 of 81,451 rows — these rows as CSV

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