PREVIEW / stock_30min / 2012-08-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-09.parquet
  size:    1.4 MB
  rows:    73,464
  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-09 04:00:00	AAPL	Stock	22.1179	22.1179	22.1179	22.1179	4200.0
2012-08-09 07:00:00	AAPL	Stock	22.0893	22.0907	22.0661	22.0679	87080.0
2012-08-09 07:30:00	AAPL	Stock	22.0664	22.0664	22.0021	22.05	662928.0
2012-08-09 08:00:00	AAPL	Stock	22.0536	22.0536	22.0179	22.045	762216.0
2012-08-09 08:30:00	AAPL	Stock	22.05	22.0889	22.0446	22.0714	960316.0
2012-08-09 09:00:00	AAPL	Stock	22.075	22.0986	22.0536	22.0661	1522584.0
2012-08-09 09:30:00	AAPL	Stock	22.0661	22.2	22.0643	22.1593	36130248.0
2012-08-09 10:00:00	AAPL	Stock	22.1554	22.1843	22.1311	22.1709	17794812.0
2012-08-09 10:30:00	AAPL	Stock	22.1721	22.2046	22.1643	22.1793	18061764.0
2012-08-09 11:00:00	AAPL	Stock	22.1786	22.1871	22.1429	22.1693	11753084.0
2012-08-09 11:30:00	AAPL	Stock	22.1671	22.1693	22.1089	22.1254	13043380.0
2012-08-09 12:00:00	AAPL	Stock	22.1254	22.1639	22.1175	22.1536	10023804.0
2012-08-09 12:30:00	AAPL	Stock	22.1532	22.1732	22.1236	22.1671	8673000.0
2012-08-09 13:00:00	AAPL	Stock	22.165	22.1782	22.1471	22.1679	6350092.0
2012-08-09 13:30:00	AAPL	Stock	22.167	22.1732	22.1546	22.1643	6294736.0
2012-08-09 14:00:00	AAPL	Stock	22.1657	22.1786	22.1511	22.1714	8374660.0
2012-08-09 14:30:00	AAPL	Stock	22.1711	22.1786	22.1482	22.1504	7170744.0
2012-08-09 15:00:00	AAPL	Stock	22.1504	22.1746	22.1314	22.1661	9300592.0
2012-08-09 15:30:00	AAPL	Stock	22.1664	22.1731	22.1429	22.1689	18196220.0
2012-08-09 16:00:00	AAPL	Stock	22.1689	22.1821	22.1536	22.1804	21227500.0
2012-08-09 16:30:00	AAPL	Stock	22.1821	22.1836	22.1634	22.1832	94472.0
2012-08-09 17:00:00	AAPL	Stock	22.1829	22.1836	22.1796	22.1832	31080.0
2012-08-09 17:30:00	AAPL	Stock	22.1768	22.1821	22.1689	22.1793	1310288.0
2012-08-09 18:00:00	AAPL	Stock	22.1789	22.1789	22.1757	22.1757	7000.0
2012-08-09 18:30:00	AAPL	Stock	22.1786	22.1786	22.1782	22.1786	50092.0
2012-08-09 19:00:00	AAPL	Stock	22.1768	22.1829	22.1768	22.1786	30100.0
2012-08-09 19:30:00	AAPL	Stock	22.1829	22.1829	22.1786	22.1786	85596.0
2012-08-09 08:00:00	MSFT	Stock	30.29	30.29	30.25	30.25	710.0
2012-08-09 08:30:00	MSFT	Stock	30.3	30.31	30.29	30.3	1749.0
2012-08-09 09:00:00	MSFT	Stock	30.35	30.47	30.26	30.43	13710.0
2012-08-09 09:30:00	MSFT	Stock	30.43	30.57	30.34	30.53	2335815.0
2012-08-09 10:00:00	MSFT	Stock	30.53	30.63	30.495	30.58	2531904.0
2012-08-09 10:30:00	MSFT	Stock	30.58	30.65	30.58	30.61	1613237.0
2012-08-09 11:00:00	MSFT	Stock	30.62	30.62	30.49	30.51	1598417.0
2012-08-09 11:30:00	MSFT	Stock	30.511	30.54	30.3	30.35	2579569.0
2012-08-09 12:00:00	MSFT	Stock	30.35	30.44	30.332	30.41	1362766.0
2012-08-09 12:30:00	MSFT	Stock	30.415	30.47	30.41	30.46	1028628.0
2012-08-09 13:00:00	MSFT	Stock	30.46	30.47	30.43	30.46	748346.0
2012-08-09 13:30:00	MSFT	Stock	30.457	30.48	30.42	30.425	654799.0
2012-08-09 14:00:00	MSFT	Stock	30.43	30.48	30.42	30.475	1394145.0
2012-08-09 14:30:00	MSFT	Stock	30.48	30.53	30.47	30.48	1092345.0
2012-08-09 15:00:00	MSFT	Stock	30.48	30.5	30.42	30.47	1404430.0
2012-08-09 15:30:00	MSFT	Stock	30.47	30.5	30.43	30.5	3266728.0
2012-08-09 16:00:00	MSFT	Stock	30.5	30.55	30.463	30.5	1086995.0
2012-08-09 16:30:00	MSFT	Stock	30.551	30.551	30.466	30.466	20017.0
2012-08-09 17:00:00	MSFT	Stock	30.55	30.56	30.5	30.54	19120.0
2012-08-09 17:30:00	MSFT	Stock	30.5	30.55	30.5	30.55	365116.0
2012-08-09 18:00:00	MSFT	Stock	30.54	30.55	30.54	30.55	1100.0
2012-08-09 18:30:00	MSFT	Stock	30.54	30.54	30.54	30.54	9950.0
2012-08-09 19:00:00	MSFT	Stock	30.52	30.52	30.52	30.52	300.0

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

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