PREVIEW / stock_30min / 2013-12-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-17.parquet
  size:    1.6 MB
  rows:    81,251
  symbols: 3,560

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
2013-12-17 04:00:00	AAPL	Stock	19.9011	19.9011	19.9011	19.9011	2800.0
2013-12-17 05:00:00	AAPL	Stock	19.9089	19.9089	19.9089	19.9089	2800.0
2013-12-17 06:30:00	AAPL	Stock	19.9089	19.9089	19.9089	19.9089	2800.0
2013-12-17 07:00:00	AAPL	Stock	19.9125	19.9475	19.9107	19.9379	45052.0
2013-12-17 07:30:00	AAPL	Stock	19.9493	19.9493	19.9296	19.9375	78120.0
2013-12-17 08:00:00	AAPL	Stock	19.9393	19.9682	19.9036	19.9464	593152.0
2013-12-17 08:30:00	AAPL	Stock	19.9464	19.95	19.8929	19.9107	616616.0
2013-12-17 09:00:00	AAPL	Stock	19.9021	19.9218	19.85	19.85	763728.0
2013-12-17 09:30:00	AAPL	Stock	19.8518	19.98	19.85	19.8562	34223560.0
2013-12-17 10:00:00	AAPL	Stock	19.8539	19.9118	19.8168	19.8861	17544940.0
2013-12-17 10:30:00	AAPL	Stock	19.8871	19.8871	19.7982	19.8191	15560636.0
2013-12-17 11:00:00	AAPL	Stock	19.8164	19.8382	19.7634	19.8025	16805376.0
2013-12-17 11:30:00	AAPL	Stock	19.8046	19.8879	19.7857	19.8689	14526736.0
2013-12-17 12:00:00	AAPL	Stock	19.8704	19.8907	19.8457	19.8511	11144700.0
2013-12-17 12:30:00	AAPL	Stock	19.8504	19.8755	19.8214	19.8609	9180332.0
2013-12-17 13:00:00	AAPL	Stock	19.8636	19.8893	19.8607	19.8814	4604992.0
2013-12-17 13:30:00	AAPL	Stock	19.8811	19.9107	19.8586	19.8754	7477764.0
2013-12-17 14:00:00	AAPL	Stock	19.8754	19.9461	19.8686	19.9018	9729860.0
2013-12-17 14:30:00	AAPL	Stock	19.9018	19.9032	19.8461	19.8789	8145480.0
2013-12-17 15:00:00	AAPL	Stock	19.8736	19.9011	19.8396	19.8425	8967728.0
2013-12-17 15:30:00	AAPL	Stock	19.8436	19.8642	19.8061	19.8205	17770424.0
2013-12-17 16:00:00	AAPL	Stock	19.8211	19.8654	19.7935	19.8168	11156152.0
2013-12-17 16:30:00	AAPL	Stock	19.8154	19.8621	19.7946	19.8211	650132.0
2013-12-17 17:00:00	AAPL	Stock	19.8171	19.8171	19.8007	19.8064	77084.0
2013-12-17 17:30:00	AAPL	Stock	19.8089	19.8175	19.8064	19.8064	39060.0
2013-12-17 18:00:00	AAPL	Stock	19.8171	19.8211	19.8082	19.8179	107324.0
2013-12-17 18:30:00	AAPL	Stock	19.8161	19.8179	19.8161	19.8161	36680.0
2013-12-17 19:00:00	AAPL	Stock	19.8196	19.8221	19.8093	19.8114	90328.0
2013-12-17 19:30:00	AAPL	Stock	19.815	19.8339	19.815	19.8264	112588.0
2013-12-17 06:30:00	MSFT	Stock	36.93	36.93	36.91	36.91	700.0
2013-12-17 07:30:00	MSFT	Stock	37.0	37.0	37.0	37.0	700.0
2013-12-17 08:00:00	MSFT	Stock	37.0	37.0	36.98	37.0	1700.0
2013-12-17 08:30:00	MSFT	Stock	36.98	37.0	36.88	36.88	2821.0
2013-12-17 09:00:00	MSFT	Stock	36.89	36.99	36.88	36.96	32008.0
2013-12-17 09:30:00	MSFT	Stock	36.96	37.0	36.61	36.75	5282969.0
2013-12-17 10:00:00	MSFT	Stock	36.75	36.81	36.66	36.8	2829556.0
2013-12-17 10:30:00	MSFT	Stock	36.805	37.11	36.78	36.91	2921001.0
2013-12-17 11:00:00	MSFT	Stock	36.91	37.01	36.83	36.84	2452175.0
2013-12-17 11:30:00	MSFT	Stock	36.84	36.88	36.62	36.635	2266656.0
2013-12-17 12:00:00	MSFT	Stock	36.64	36.7	36.61	36.68	1593201.0
2013-12-17 12:30:00	MSFT	Stock	36.67	36.775	36.65	36.65	1538342.0
2013-12-17 13:00:00	MSFT	Stock	36.65	36.72	36.53	36.635	4315514.0
2013-12-17 13:30:00	MSFT	Stock	36.63	36.63	36.34	36.354	3114344.0
2013-12-17 14:00:00	MSFT	Stock	36.35	36.59	36.334	36.5	2839095.0
2013-12-17 14:30:00	MSFT	Stock	36.51	36.62	36.47	36.53	1394313.0
2013-12-17 15:00:00	MSFT	Stock	36.53	36.57	36.49	36.54	2402069.0
2013-12-17 15:30:00	MSFT	Stock	36.55	36.595	36.49	36.53	4942413.0
2013-12-17 16:00:00	MSFT	Stock	36.54	36.755	36.5	36.55	2625088.0
2013-12-17 16:30:00	MSFT	Stock	36.86	36.86	36.53	36.54	151037.0
2013-12-17 17:00:00	MSFT	Stock	36.525	36.58	36.525	36.58	500.0

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

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