PREVIEW / stock_30min / 2012-08-08

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-08.parquet
  size:    1.4 MB
  rows:    74,153
  symbols: 3,482

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
2012-08-08 04:30:00	AAPL	Stock	22.1179	22.1179	22.0911	22.0971	11732.0
2012-08-08 05:30:00	AAPL	Stock	22.0971	22.0971	22.0971	22.0971	37800.0
2012-08-08 06:30:00	AAPL	Stock	22.0786	22.0857	22.0786	22.0857	25200.0
2012-08-08 07:00:00	AAPL	Stock	22.0968	22.1504	22.0968	22.1146	137284.0
2012-08-08 07:30:00	AAPL	Stock	22.1139	22.1214	22.0879	22.1071	121436.0
2012-08-08 08:00:00	AAPL	Stock	22.1504	22.1504	22.0775	22.0804	468076.0
2012-08-08 08:30:00	AAPL	Stock	22.0821	22.1161	22.0779	22.0989	588868.0
2012-08-08 09:00:00	AAPL	Stock	22.1018	22.1393	22.1	22.1071	757652.0
2012-08-08 09:30:00	AAPL	Stock	22.1071	22.1921	22.0393	22.1064	40432392.0
2012-08-08 10:00:00	AAPL	Stock	22.1064	22.1332	22.0821	22.1132	14875644.0
2012-08-08 10:30:00	AAPL	Stock	22.1132	22.1382	22.0714	22.1246	17836364.0
2012-08-08 11:00:00	AAPL	Stock	22.1279	22.2054	22.1146	22.1984	22730400.0
2012-08-08 11:30:00	AAPL	Stock	22.1996	22.2386	22.175	22.2196	16495556.0
2012-08-08 12:00:00	AAPL	Stock	22.2218	22.2814	22.2093	22.2382	19297432.0
2012-08-08 12:30:00	AAPL	Stock	22.2396	22.2489	22.1782	22.21	11801664.0
2012-08-08 13:00:00	AAPL	Stock	22.21	22.2229	22.1675	22.2061	12156872.0
2012-08-08 13:30:00	AAPL	Stock	22.2032	22.2093	22.1829	22.1918	5804484.0
2012-08-08 14:00:00	AAPL	Stock	22.1961	22.1975	22.1504	22.1825	9868628.0
2012-08-08 14:30:00	AAPL	Stock	22.1818	22.2089	22.1652	22.1743	8552908.0
2012-08-08 15:00:00	AAPL	Stock	22.1718	22.1964	22.1639	22.1901	9224040.0
2012-08-08 15:30:00	AAPL	Stock	22.1886	22.1932	22.1236	22.1375	28233856.0
2012-08-08 16:00:00	AAPL	Stock	22.1379	22.1518	22.1071	22.1393	8308076.0
2012-08-08 16:30:00	AAPL	Stock	22.1411	22.1859	22.1357	22.1389	464492.0
2012-08-08 17:00:00	AAPL	Stock	22.1825	22.1825	22.1304	22.1375	350896.0
2012-08-08 17:30:00	AAPL	Stock	22.1446	22.1489	22.1343	22.1429	154448.0
2012-08-08 18:00:00	AAPL	Stock	22.1443	22.1518	22.1443	22.1454	50064.0
2012-08-08 18:30:00	AAPL	Stock	22.145	22.1464	22.1436	22.1436	23436.0
2012-08-08 19:00:00	AAPL	Stock	22.1461	22.1564	22.1411	22.1432	96376.0
2012-08-08 19:30:00	AAPL	Stock	22.1464	22.1475	22.1368	22.1375	466844.0
2012-08-08 07:00:00	MSFT	Stock	30.2	30.2	30.2	30.2	180.0
2012-08-08 07:30:00	MSFT	Stock	30.25	30.25	30.22	30.22	3200.0
2012-08-08 08:00:00	MSFT	Stock	30.21	30.21	30.15	30.18	1350.0
2012-08-08 08:30:00	MSFT	Stock	30.16	30.16	30.15	30.15	1300.0
2012-08-08 09:00:00	MSFT	Stock	30.15	30.25	30.14	30.25	12611.0
2012-08-08 09:30:00	MSFT	Stock	30.2	30.3	30.11	30.277	3125464.0
2012-08-08 10:00:00	MSFT	Stock	30.27	30.39	30.265	30.28	2155201.0
2012-08-08 10:30:00	MSFT	Stock	30.29	30.34	30.25	30.295	1525190.0
2012-08-08 11:00:00	MSFT	Stock	30.295	30.45	30.27	30.43	2288340.0
2012-08-08 11:30:00	MSFT	Stock	30.433	30.47	30.281	30.446	1684790.0
2012-08-08 12:00:00	MSFT	Stock	30.445	30.46	30.41	30.425	1093122.0
2012-08-08 12:30:00	MSFT	Stock	30.42	30.45	30.36	30.425	1464084.0
2012-08-08 13:00:00	MSFT	Stock	30.42	30.47	30.41	30.445	1105952.0
2012-08-08 13:30:00	MSFT	Stock	30.45	30.47	30.42	30.43	760439.0
2012-08-08 14:00:00	MSFT	Stock	30.44	30.45	30.36	30.384	1354017.0
2012-08-08 14:30:00	MSFT	Stock	30.388	30.39	30.33	30.35	1121141.0
2012-08-08 15:00:00	MSFT	Stock	30.35	30.4	30.34	30.35	1823162.0
2012-08-08 15:30:00	MSFT	Stock	30.34	30.37	30.28	30.32	4318011.0
2012-08-08 16:00:00	MSFT	Stock	30.32	30.47	30.3	30.33	1940269.0
2012-08-08 16:30:00	MSFT	Stock	30.3	30.336	30.3	30.32	28700.0
2012-08-08 17:00:00	MSFT	Stock	30.32	30.32	30.29	30.29	1394.0

> showing 50 of 74,153 rows — these rows as CSV

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