PREVIEW / stock_30min / 2010-10-20

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-20.parquet
  size:    1.4 MB
  rows:    73,293
  symbols: 3,493

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-10-20 04:00:00	AAPL	Stock	11.0318	11.0571	11.0318	11.0321	22400.0
2010-10-20 05:00:00	AAPL	Stock	11.0446	11.0489	11.0446	11.0489	5600.0
2010-10-20 05:30:00	AAPL	Stock	11.0346	11.0346	11.0346	11.0346	31052.0
2010-10-20 06:00:00	AAPL	Stock	11.0446	11.0536	11.0318	11.0368	42000.0
2010-10-20 06:30:00	AAPL	Stock	11.0293	11.0536	11.0179	11.0357	57036.0
2010-10-20 07:00:00	AAPL	Stock	11.0268	11.0439	11.0232	11.0418	269164.0
2010-10-20 07:30:00	AAPL	Stock	11.0411	11.0639	11.035	11.0536	513492.0
2010-10-20 08:00:00	AAPL	Stock	11.05	11.0686	11.0196	11.0268	2989868.0
2010-10-20 08:30:00	AAPL	Stock	11.0261	11.0421	11.0	11.0279	3497340.0
2010-10-20 09:00:00	AAPL	Stock	11.0275	11.0486	11.0189	11.0354	1582196.0
2010-10-20 09:30:00	AAPL	Stock	11.0357	11.1	10.9968	11.0314	98304920.0
2010-10-20 10:00:00	AAPL	Stock	11.0321	11.0432	10.9596	11.0125	64715448.0
2010-10-20 10:30:00	AAPL	Stock	11.0114	11.0775	10.9964	11.0582	60078228.0
2010-10-20 11:00:00	AAPL	Stock	11.06	11.1471	11.0411	11.1275	57533840.0
2010-10-20 11:30:00	AAPL	Stock	11.1264	11.1964	11.1257	11.1604	55621664.0
2010-10-20 12:00:00	AAPL	Stock	11.1593	11.2232	11.1571	11.1984	47988864.0
2010-10-20 12:30:00	AAPL	Stock	11.1993	11.2093	11.1643	11.1721	26048680.0
2010-10-20 13:00:00	AAPL	Stock	11.1721	11.1943	11.1446	11.1857	33002900.0
2010-10-20 13:30:00	AAPL	Stock	11.1864	11.1918	11.1486	11.1525	23030784.0
2010-10-20 14:00:00	AAPL	Stock	11.1532	11.1839	11.1143	11.1407	60433604.0
2010-10-20 14:30:00	AAPL	Stock	11.1418	11.1679	11.1321	11.1521	40325796.0
2010-10-20 15:00:00	AAPL	Stock	11.1521	11.1743	11.1325	11.1743	37687272.0
2010-10-20 15:30:00	AAPL	Stock	11.1736	11.1757	11.0686	11.0904	81242084.0
2010-10-20 16:00:00	AAPL	Stock	11.0879	11.1096	11.0768	11.095	8888040.0
2010-10-20 16:30:00	AAPL	Stock	11.0946	11.1717	11.0946	11.1104	876764.0
2010-10-20 17:00:00	AAPL	Stock	11.1075	11.1107	11.0904	11.1064	1028244.0
2010-10-20 17:30:00	AAPL	Stock	11.1064	11.1071	11.0832	11.0882	571760.0
2010-10-20 18:00:00	AAPL	Stock	11.0929	11.1	11.0739	11.0739	846916.0
2010-10-20 18:30:00	AAPL	Stock	11.0739	11.0814	11.0682	11.0682	470736.0
2010-10-20 19:00:00	AAPL	Stock	11.0732	11.0882	11.07	11.0843	323092.0
2010-10-20 19:30:00	AAPL	Stock	11.0779	11.0857	11.0768	11.0857	547736.0
2010-10-20 20:00:00	AAPL	Stock	11.1714	11.1714	11.1714	11.1714	1181600.0
2010-10-20 04:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	300.0
2010-10-20 07:00:00	MSFT	Stock	25.3	25.3	25.2	25.2	2600.0
2010-10-20 07:30:00	MSFT	Stock	25.19	25.25	25.17	25.25	38800.0
2010-10-20 08:00:00	MSFT	Stock	25.2	25.23	25.2	25.21	272796.0
2010-10-20 08:30:00	MSFT	Stock	25.21	25.22	25.13	25.13	66461.0
2010-10-20 09:00:00	MSFT	Stock	25.15	25.29	25.12	25.24	62314.0
2010-10-20 09:30:00	MSFT	Stock	25.26	25.3	25.21	25.26	4446771.0
2010-10-20 10:00:00	MSFT	Stock	25.26	25.27	25.1	25.2	3516470.0
2010-10-20 10:30:00	MSFT	Stock	25.201	25.31	25.2	25.28	4872836.0
2010-10-20 11:00:00	MSFT	Stock	25.28	25.28	25.19	25.245	2687290.0
2010-10-20 11:30:00	MSFT	Stock	25.245	25.28	25.21	25.21	2339107.0
2010-10-20 12:00:00	MSFT	Stock	25.21	25.32	25.2	25.318	2895358.0
2010-10-20 12:30:00	MSFT	Stock	25.31	25.34	25.2	25.22	1847662.0
2010-10-20 13:00:00	MSFT	Stock	25.224	25.26	25.2	25.215	2055282.0
2010-10-20 13:30:00	MSFT	Stock	25.215	25.22	25.18	25.2	1447486.0
2010-10-20 14:00:00	MSFT	Stock	25.2	25.25	25.15	25.193	3385585.0
2010-10-20 14:30:00	MSFT	Stock	25.191	25.26	25.155	25.22	3533361.0
2010-10-20 15:00:00	MSFT	Stock	25.215	25.4	25.205	25.37	8545254.0

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

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