PREVIEW / stock_30min / 2010-11-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-23.parquet
  size:    1.4 MB
  rows:    73,884
  symbols: 3,498

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
2010-11-23 04:00:00	AAPL	Stock	11.1071	11.1161	11.1011	11.1071	22400.0
2010-11-23 04:30:00	AAPL	Stock	11.1171	11.1307	11.1143	11.1307	22400.0
2010-11-23 05:00:00	AAPL	Stock	11.1071	11.1071	11.1071	11.1071	33600.0
2010-11-23 06:00:00	AAPL	Stock	11.125	11.1321	11.125	11.1321	8400.0
2010-11-23 06:30:00	AAPL	Stock	11.125	11.125	11.0982	11.1071	25200.0
2010-11-23 07:00:00	AAPL	Stock	11.1071	11.1071	11.0893	11.0893	164528.0
2010-11-23 07:30:00	AAPL	Stock	11.0857	11.0982	11.0789	11.0896	208768.0
2010-11-23 08:00:00	AAPL	Stock	11.0929	11.1429	11.0893	11.1368	2380336.0
2010-11-23 08:30:00	AAPL	Stock	11.1368	11.1607	11.1229	11.1296	2885512.0
2010-11-23 09:00:00	AAPL	Stock	11.1286	11.1307	11.0875	11.0875	2021712.0
2010-11-23 09:30:00	AAPL	Stock	11.0893	11.1339	11.0286	11.0382	76710116.0
2010-11-23 10:00:00	AAPL	Stock	11.0382	11.0643	11.0071	11.0525	56219408.0
2010-11-23 10:30:00	AAPL	Stock	11.0536	11.07	11.0286	11.05	32221112.0
2010-11-23 11:00:00	AAPL	Stock	11.05	11.0518	11.0	11.0029	43352960.0
2010-11-23 11:30:00	AAPL	Stock	11.0018	11.0171	10.9714	11.0103	40729248.0
2010-11-23 12:00:00	AAPL	Stock	11.0104	11.0196	10.9861	11.0035	19336828.0
2010-11-23 12:30:00	AAPL	Stock	11.0021	11.016	10.9821	11.0071	21246204.0
2010-11-23 13:00:00	AAPL	Stock	11.0089	11.0118	10.9911	11.0	17431736.0
2010-11-23 13:30:00	AAPL	Stock	11.0014	11.0075	10.9764	10.9793	14950740.0
2010-11-23 14:00:00	AAPL	Stock	10.9793	10.9946	10.9486	10.9668	30566956.0
2010-11-23 14:30:00	AAPL	Stock	10.9686	11.0068	10.9518	10.9893	23350656.0
2010-11-23 15:00:00	AAPL	Stock	10.9896	11.0264	10.9843	10.996	29393028.0
2010-11-23 15:30:00	AAPL	Stock	10.9936	11.0479	10.9771	11.0257	55538140.0
2010-11-23 16:00:00	AAPL	Stock	11.0261	11.1861	10.9972	11.0364	44906848.0
2010-11-23 16:30:00	AAPL	Stock	11.0357	11.0375	10.9946	11.0221	522508.0
2010-11-23 17:00:00	AAPL	Stock	11.0232	11.0286	11.0186	11.0254	404208.0
2010-11-23 17:30:00	AAPL	Stock	11.0268	11.0311	11.0086	11.0096	363244.0
2010-11-23 18:00:00	AAPL	Stock	11.0161	11.0357	11.0161	11.0357	959140.0
2010-11-23 18:30:00	AAPL	Stock	11.0339	11.0346	11.0196	11.0321	326592.0
2010-11-23 19:00:00	AAPL	Stock	11.0336	11.0357	11.0214	11.0346	126280.0
2010-11-23 19:30:00	AAPL	Stock	11.0289	11.0346	11.025	11.025	167048.0
2010-11-23 08:00:00	MSFT	Stock	25.56	25.65	25.55	25.58	12164.0
2010-11-23 08:30:00	MSFT	Stock	25.57	25.6	25.55	25.58	7819.0
2010-11-23 09:00:00	MSFT	Stock	25.57	25.58	25.5	25.55	84747.0
2010-11-23 09:30:00	MSFT	Stock	25.57	25.6	25.26	25.27	9865901.0
2010-11-23 10:00:00	MSFT	Stock	25.27	25.38	25.1	25.25	10431311.0
2010-11-23 10:30:00	MSFT	Stock	25.24	25.3	25.16	25.275	4598657.0
2010-11-23 11:00:00	MSFT	Stock	25.28	25.28	25.16	25.16	2896709.0
2010-11-23 11:30:00	MSFT	Stock	25.16	25.16	25.1	25.12	3978776.0
2010-11-23 12:00:00	MSFT	Stock	25.13	25.17	25.11	25.15	2684192.0
2010-11-23 12:30:00	MSFT	Stock	25.15	25.268	25.12	25.251	3420491.0
2010-11-23 13:00:00	MSFT	Stock	25.26	25.29	25.192	25.285	2298325.0
2010-11-23 13:30:00	MSFT	Stock	25.29	25.34	25.22	25.26	3084061.0
2010-11-23 14:00:00	MSFT	Stock	25.26	25.32	25.17	25.21	3464552.0
2010-11-23 14:30:00	MSFT	Stock	25.219	25.27	25.2	25.22	1890188.0
2010-11-23 15:00:00	MSFT	Stock	25.22	25.28	25.14	25.16	4127836.0
2010-11-23 15:30:00	MSFT	Stock	25.155	25.23	25.09	25.12	11078018.0
2010-11-23 16:00:00	MSFT	Stock	25.12	25.888	25.098	25.13	2601736.0
2010-11-23 16:30:00	MSFT	Stock	25.14	25.18	25.13	25.14	44210.0
2010-11-23 17:00:00	MSFT	Stock	25.14	25.15	25.13	25.15	16741.0

> showing 50 of 73,884 rows — these rows as CSV

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