PREVIEW / stock_30min / 2014-03-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-03.parquet
  size:    1.6 MB
  rows:    83,700
  symbols: 3,537

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
2014-03-03 04:00:00	AAPL	Stock	18.6436	18.6436	18.5536	18.6164	139272.0
2014-03-03 04:30:00	AAPL	Stock	18.6246	18.6246	18.6229	18.6229	22400.0
2014-03-03 05:00:00	AAPL	Stock	18.625	18.625	18.6114	18.6114	17500.0
2014-03-03 05:30:00	AAPL	Stock	18.6082	18.6104	18.5893	18.6104	56000.0
2014-03-03 06:00:00	AAPL	Stock	18.5989	18.6071	18.5982	18.6071	25200.0
2014-03-03 06:30:00	AAPL	Stock	18.6139	18.6411	18.5896	18.5896	79996.0
2014-03-03 07:00:00	AAPL	Stock	18.5821	18.6189	18.5821	18.5982	201012.0
2014-03-03 07:30:00	AAPL	Stock	18.5986	18.6604	18.5986	18.6393	337652.0
2014-03-03 08:00:00	AAPL	Stock	18.6429	18.7943	18.5821	18.6764	663852.0
2014-03-03 08:30:00	AAPL	Stock	18.6657	18.7139	18.6468	18.6714	601944.0
2014-03-03 09:00:00	AAPL	Stock	18.6696	18.7471	18.6696	18.6793	1235556.0
2014-03-03 09:30:00	AAPL	Stock	18.6936	18.9518	18.6786	18.8771	47356624.0
2014-03-03 10:00:00	AAPL	Stock	18.8771	18.9186	18.775	18.8411	20271328.0
2014-03-03 10:30:00	AAPL	Stock	18.8336	18.8889	18.8214	18.8671	11071732.0
2014-03-03 11:00:00	AAPL	Stock	18.8718	18.8761	18.7564	18.7636	12143208.0
2014-03-03 11:30:00	AAPL	Stock	18.7605	18.7704	18.6907	18.6946	11945724.0
2014-03-03 12:00:00	AAPL	Stock	18.6962	18.7546	18.6718	18.6982	12726896.0
2014-03-03 12:30:00	AAPL	Stock	18.6982	18.7493	18.6939	18.7382	7258188.0
2014-03-03 13:00:00	AAPL	Stock	18.7414	18.8125	18.7332	18.7989	8754732.0
2014-03-03 13:30:00	AAPL	Stock	18.8014	18.8046	18.7379	18.7589	5772368.0
2014-03-03 14:00:00	AAPL	Stock	18.7589	18.8321	18.7564	18.7636	8171240.0
2014-03-03 14:30:00	AAPL	Stock	18.7657	18.83	18.75	18.7857	5986008.0
2014-03-03 15:00:00	AAPL	Stock	18.7864	18.8018	18.7436	18.7768	8634136.0
2014-03-03 15:30:00	AAPL	Stock	18.7725	18.8486	18.7621	18.8486	19606244.0
2014-03-03 16:00:00	AAPL	Stock	18.8468	18.8546	18.7732	18.8436	4887344.0
2014-03-03 16:30:00	AAPL	Stock	18.8496	18.85	18.8176	18.85	321272.0
2014-03-03 17:00:00	AAPL	Stock	18.8436	18.8464	18.8414	18.8432	77448.0
2014-03-03 17:30:00	AAPL	Stock	18.85	18.8557	18.8489	18.8504	72016.0
2014-03-03 18:00:00	AAPL	Stock	18.8504	18.8536	18.8446	18.845	59136.0
2014-03-03 18:30:00	AAPL	Stock	18.8525	18.8589	18.8496	18.8546	141400.0
2014-03-03 19:00:00	AAPL	Stock	18.8518	18.8643	18.8504	18.8643	27720.0
2014-03-03 19:30:00	AAPL	Stock	18.8561	18.8675	18.8561	18.8607	36960.0
2014-03-03 05:30:00	MSFT	Stock	37.91	37.91	37.91	37.91	100.0
2014-03-03 06:30:00	MSFT	Stock	37.93	37.94	37.93	37.94	2000.0
2014-03-03 07:00:00	MSFT	Stock	37.78	37.78	37.78	37.78	342.0
2014-03-03 07:30:00	MSFT	Stock	37.78	37.85	37.78	37.83	6400.0
2014-03-03 08:00:00	MSFT	Stock	37.78	37.89	37.78	37.85	8853.0
2014-03-03 08:30:00	MSFT	Stock	37.8	37.87	37.8	37.87	8166.0
2014-03-03 09:00:00	MSFT	Stock	37.86	37.94	37.86	37.89	28641.0
2014-03-03 09:30:00	MSFT	Stock	37.92	38.13	37.88	38.03	3485837.0
2014-03-03 10:00:00	MSFT	Stock	38.03	38.085	37.58	37.76	2525261.0
2014-03-03 10:30:00	MSFT	Stock	37.755	37.77	37.65	37.72	1506710.0
2014-03-03 11:00:00	MSFT	Stock	37.73	37.73	37.51	37.6	1669472.0
2014-03-03 11:30:00	MSFT	Stock	37.59	37.62	37.5	37.51	1557160.0
2014-03-03 12:00:00	MSFT	Stock	37.51	37.64	37.495	37.605	2404719.0
2014-03-03 12:30:00	MSFT	Stock	37.6	37.65	37.57	37.629	839542.0
2014-03-03 13:00:00	MSFT	Stock	37.62	37.73	37.62	37.68	1126032.0
2014-03-03 13:30:00	MSFT	Stock	37.68	37.69	37.58	37.67	1095164.0
2014-03-03 14:00:00	MSFT	Stock	37.67	37.72	37.63	37.635	992997.0
2014-03-03 14:30:00	MSFT	Stock	37.63	37.81	37.625	37.7	1387221.0

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

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