PREVIEW / stock_30min / 2010-02-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-12.parquet
  size:    1.3 MB
  rows:    72,365
  symbols: 3,433

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-02-12 04:30:00	AAPL	Stock	7.0964	7.0964	7.0964	7.0964	2800.0
2010-02-12 05:00:00	AAPL	Stock	7.0604	7.0604	7.0604	7.0604	5600.0
2010-02-12 05:30:00	AAPL	Stock	7.0511	7.0511	7.0511	7.0511	5292.0
2010-02-12 06:00:00	AAPL	Stock	7.0439	7.0439	7.0439	7.0439	2800.0
2010-02-12 06:30:00	AAPL	Stock	7.0361	7.0361	7.0236	7.0236	16800.0
2010-02-12 07:00:00	AAPL	Stock	7.0511	7.0779	7.0511	7.0764	60676.0
2010-02-12 07:30:00	AAPL	Stock	7.0714	7.0714	7.0625	7.0682	362460.0
2010-02-12 08:00:00	AAPL	Stock	7.0714	7.0811	7.0496	7.0671	1127168.0
2010-02-12 08:30:00	AAPL	Stock	7.0679	7.0786	7.0607	7.0729	1422652.0
2010-02-12 09:00:00	AAPL	Stock	7.075	7.0864	7.0593	7.0786	2251088.0
2010-02-12 09:30:00	AAPL	Stock	7.0782	7.0868	7.0279	7.0521	73561180.0
2010-02-12 10:00:00	AAPL	Stock	7.0529	7.0757	7.0268	7.0721	52456964.0
2010-02-12 10:30:00	AAPL	Stock	7.0721	7.0786	7.0393	7.0543	31479784.0
2010-02-12 11:00:00	AAPL	Stock	7.0536	7.1057	7.0496	7.0911	35309316.0
2010-02-12 11:30:00	AAPL	Stock	7.0911	7.1314	7.0843	7.1254	35480872.0
2010-02-12 12:00:00	AAPL	Stock	7.1254	7.2014	7.125	7.1789	82671680.0
2010-02-12 12:30:00	AAPL	Stock	7.1779	7.1854	7.1636	7.175	29892492.0
2010-02-12 13:00:00	AAPL	Stock	7.1739	7.175	7.122	7.1286	41479340.0
2010-02-12 13:30:00	AAPL	Stock	7.1282	7.1554	7.1121	7.1456	36244516.0
2010-02-12 14:00:00	AAPL	Stock	7.1443	7.1857	7.1411	7.1793	37948680.0
2010-02-12 14:30:00	AAPL	Stock	7.1796	7.1832	7.1643	7.1686	33349428.0
2010-02-12 15:00:00	AAPL	Stock	7.1696	7.1732	7.1429	7.1593	41118532.0
2010-02-12 15:30:00	AAPL	Stock	7.1593	7.1743	6.9821	7.1643	66802120.0
2010-02-12 16:00:00	AAPL	Stock	7.1575	7.1661	7.1018	7.1625	27506080.0
2010-02-12 16:30:00	AAPL	Stock	7.1654	7.1661	7.1564	7.1632	1164100.0
2010-02-12 17:00:00	AAPL	Stock	7.1614	7.165	7.1614	7.1643	88872.0
2010-02-12 17:30:00	AAPL	Stock	7.1618	7.1657	7.1618	7.1646	71260.0
2010-02-12 18:00:00	AAPL	Stock	7.1646	7.165	7.1564	7.1646	101640.0
2010-02-12 18:30:00	AAPL	Stock	7.1625	7.1664	7.1625	7.1664	36036.0
2010-02-12 19:00:00	AAPL	Stock	7.165	7.1657	7.165	7.1657	34720.0
2010-02-12 19:30:00	AAPL	Stock	7.1657	7.1679	7.1625	7.1625	240352.0
2010-02-12 05:30:00	MSFT	Stock	27.85	27.85	27.85	27.85	100.0
2010-02-12 06:00:00	MSFT	Stock	27.84	27.84	27.75	27.75	200.0
2010-02-12 06:30:00	MSFT	Stock	27.84	27.84	27.8	27.8	800.0
2010-02-12 07:00:00	MSFT	Stock	27.91	27.96	27.91	27.96	690.0
2010-02-12 07:30:00	MSFT	Stock	27.96	27.96	27.9	27.9	912.0
2010-02-12 08:00:00	MSFT	Stock	27.94	28.12	27.9	27.98	15027.0
2010-02-12 08:30:00	MSFT	Stock	27.99	28.08	27.99	28.04	21988.0
2010-02-12 09:00:00	MSFT	Stock	28.02	28.04	27.78	27.8	42888.0
2010-02-12 09:30:00	MSFT	Stock	27.81	27.82	27.6	27.7	8151653.0
2010-02-12 10:00:00	MSFT	Stock	27.7	27.71	27.58	27.7	6068855.0
2010-02-12 10:30:00	MSFT	Stock	27.71	27.73	27.6	27.678	4458934.0
2010-02-12 11:00:00	MSFT	Stock	27.67	27.75	27.63	27.66	4360257.0
2010-02-12 11:30:00	MSFT	Stock	27.66	27.74	27.65	27.7	3876422.0
2010-02-12 12:00:00	MSFT	Stock	27.7	28.005	27.7	27.99	6902279.0
2010-02-12 12:30:00	MSFT	Stock	28.0	28.06	27.94	27.98	3561295.0
2010-02-12 13:00:00	MSFT	Stock	27.97	27.98	27.67	27.71	5158272.0
2010-02-12 13:30:00	MSFT	Stock	27.71	27.79	27.65	27.778	3749319.0
2010-02-12 14:00:00	MSFT	Stock	27.78	28.04	27.75	28.0	4000652.0
2010-02-12 14:30:00	MSFT	Stock	28.01	28.04	27.9	27.912	2877514.0

> showing 50 of 72,365 rows — these rows as CSV

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