PREVIEW / stock_30min / 2014-01-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-16.parquet
  size:    1.6 MB
  rows:    80,777
  symbols: 3,518

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-01-16 05:00:00	AAPL	Stock	19.9339	19.9368	19.9339	19.9368	14000.0
2014-01-16 06:30:00	AAPL	Stock	19.9336	19.9336	19.9179	19.9179	8120.0
2014-01-16 07:00:00	AAPL	Stock	19.9179	19.9379	19.8929	19.9	63420.0
2014-01-16 07:30:00	AAPL	Stock	19.8929	19.9286	19.8496	19.8629	257768.0
2014-01-16 08:00:00	AAPL	Stock	19.8786	19.9379	19.7932	19.8193	993496.0
2014-01-16 08:30:00	AAPL	Stock	19.8214	19.8214	19.8111	19.8179	398272.0
2014-01-16 09:00:00	AAPL	Stock	19.8143	19.835	19.8089	19.8207	473284.0
2014-01-16 09:30:00	AAPL	Stock	19.8211	19.8875	19.7029	19.7869	47404252.0
2014-01-16 10:00:00	AAPL	Stock	19.7886	19.85	19.7432	19.8414	20737920.0
2014-01-16 10:30:00	AAPL	Stock	19.845	19.8486	19.7604	19.7843	13363392.0
2014-01-16 11:00:00	AAPL	Stock	19.7873	19.8748	19.7754	19.8471	14216720.0
2014-01-16 11:30:00	AAPL	Stock	19.8482	19.8593	19.8075	19.8404	7770196.0
2014-01-16 12:00:00	AAPL	Stock	19.8407	19.8439	19.7839	19.8071	7139608.0
2014-01-16 12:30:00	AAPL	Stock	19.8054	19.8407	19.7996	19.8321	4567500.0
2014-01-16 13:00:00	AAPL	Stock	19.8336	19.86	19.8146	19.8589	6396124.0
2014-01-16 13:30:00	AAPL	Stock	19.8589	19.8654	19.8136	19.8146	6879012.0
2014-01-16 14:00:00	AAPL	Stock	19.8154	19.8364	19.8036	19.8232	5052460.0
2014-01-16 14:30:00	AAPL	Stock	19.8239	19.8554	19.8172	19.8518	7289520.0
2014-01-16 15:00:00	AAPL	Stock	19.8518	19.8551	19.7954	19.8032	7250936.0
2014-01-16 15:30:00	AAPL	Stock	19.8039	19.8179	19.7786	19.7936	17864672.0
2014-01-16 16:00:00	AAPL	Stock	19.7946	19.8188	19.7679	19.78	9986844.0
2014-01-16 16:30:00	AAPL	Stock	19.7761	19.8205	19.7761	19.7875	451108.0
2014-01-16 17:00:00	AAPL	Stock	19.7882	19.7964	19.7875	19.7929	64400.0
2014-01-16 17:30:00	AAPL	Stock	19.7893	19.7893	19.7589	19.7857	110656.0
2014-01-16 18:00:00	AAPL	Stock	19.7857	19.7946	19.7857	19.79	115920.0
2014-01-16 18:30:00	AAPL	Stock	19.79	19.7911	19.7714	19.7714	86072.0
2014-01-16 19:00:00	AAPL	Stock	19.7846	19.7854	19.7743	19.7743	12320.0
2014-01-16 19:30:00	AAPL	Stock	19.7679	19.7679	19.7339	19.7439	129892.0
2014-01-16 04:30:00	MSFT	Stock	36.83	36.83	36.78	36.82	1169.0
2014-01-16 05:00:00	MSFT	Stock	36.83	36.83	36.83	36.83	100.0
2014-01-16 06:00:00	MSFT	Stock	36.83	36.88	36.83	36.86	1400.0
2014-01-16 06:30:00	MSFT	Stock	36.84	36.84	36.8	36.8	200.0
2014-01-16 07:00:00	MSFT	Stock	36.8	36.8	36.75	36.78	1345.0
2014-01-16 07:30:00	MSFT	Stock	36.79	36.79	36.66	36.66	4395.0
2014-01-16 08:00:00	MSFT	Stock	36.66	36.75	36.66	36.71	3150.0
2014-01-16 08:30:00	MSFT	Stock	36.66	36.72	36.66	36.7	1851.0
2014-01-16 09:00:00	MSFT	Stock	36.72	36.78	36.68	36.78	12133.0
2014-01-16 09:30:00	MSFT	Stock	36.69	37.0	36.528	36.574	4279232.0
2014-01-16 10:00:00	MSFT	Stock	36.57	36.655	36.49	36.61	2026332.0
2014-01-16 10:30:00	MSFT	Stock	36.6	36.61	36.39	36.42	2327460.0
2014-01-16 11:00:00	MSFT	Stock	36.42	36.47	36.33	36.37	2138098.0
2014-01-16 11:30:00	MSFT	Stock	36.37	36.49	36.34	36.46	1567645.0
2014-01-16 12:00:00	MSFT	Stock	36.47	36.47	36.33	36.35	1730727.0
2014-01-16 12:30:00	MSFT	Stock	36.352	36.4	36.31	36.385	1552272.0
2014-01-16 13:00:00	MSFT	Stock	36.38	36.55	36.37	36.545	1586225.0
2014-01-16 13:30:00	MSFT	Stock	36.54	36.67	36.53	36.605	2417593.0
2014-01-16 14:00:00	MSFT	Stock	36.605	36.62	36.52	36.61	1222468.0
2014-01-16 14:30:00	MSFT	Stock	36.61	36.63	36.53	36.63	1161830.0
2014-01-16 15:00:00	MSFT	Stock	36.63	36.72	36.61	36.65	3096602.0
2014-01-16 15:30:00	MSFT	Stock	36.65	36.89	36.64	36.88	6303027.0

> showing 50 of 80,777 rows — these rows as CSV

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