PREVIEW / stock_30min / 2012-08-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-17.parquet
  size:    1.4 MB
  rows:    73,645
  symbols: 3,480

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-17 04:00:00	AAPL	Stock	22.7214	22.7214	22.7214	22.7214	11200.0
2012-08-17 04:30:00	AAPL	Stock	22.7214	22.7214	22.7214	22.7214	16800.0
2012-08-17 05:00:00	AAPL	Stock	22.7507	22.7657	22.7493	22.7589	39200.0
2012-08-17 05:30:00	AAPL	Stock	22.7589	22.7843	22.7589	22.7643	138880.0
2012-08-17 06:00:00	AAPL	Stock	22.7843	22.7943	22.7843	22.7943	22680.0
2012-08-17 06:30:00	AAPL	Stock	22.8118	22.8118	22.8118	22.8118	11200.0
2012-08-17 07:00:00	AAPL	Stock	22.7911	22.7964	22.775	22.7854	231084.0
2012-08-17 07:30:00	AAPL	Stock	22.7821	22.8054	22.7714	22.8054	396452.0
2012-08-17 08:00:00	AAPL	Stock	22.8014	22.8318	22.7821	22.7911	1564724.0
2012-08-17 08:30:00	AAPL	Stock	22.7911	22.8071	22.7264	22.7946	1405768.0
2012-08-17 09:00:00	AAPL	Stock	22.7946	22.8896	22.7946	22.815	7531384.0
2012-08-17 09:30:00	AAPL	Stock	22.8146	22.9896	22.8136	22.9843	111830796.0
2012-08-17 10:00:00	AAPL	Stock	22.9857	23.0046	22.9346	22.9486	50088780.0
2012-08-17 10:30:00	AAPL	Stock	22.9486	22.9693	22.9164	22.9661	25663484.0
2012-08-17 11:00:00	AAPL	Stock	22.9661	22.9821	22.94	22.9604	15535772.0
2012-08-17 11:30:00	AAPL	Stock	22.9561	22.9886	22.9518	22.9854	15942108.0
2012-08-17 12:00:00	AAPL	Stock	22.9871	23.0529	22.9825	23.0243	35411292.0
2012-08-17 12:30:00	AAPL	Stock	23.0243	23.0446	23.0	23.0008	19754112.0
2012-08-17 13:00:00	AAPL	Stock	23.0007	23.0439	22.9907	23.0321	16773876.0
2012-08-17 13:30:00	AAPL	Stock	23.0307	23.0418	23.0257	23.0336	9098684.0
2012-08-17 14:00:00	AAPL	Stock	23.0318	23.0446	23.0218	23.0418	12922952.0
2012-08-17 14:30:00	AAPL	Stock	23.0416	23.0832	23.04	23.0818	22658832.0
2012-08-17 15:00:00	AAPL	Stock	23.0821	23.1146	23.0786	23.1039	31412248.0
2012-08-17 15:30:00	AAPL	Stock	23.1039	23.1496	23.0661	23.1486	47444012.0
2012-08-17 16:00:00	AAPL	Stock	23.1464	23.1821	22.991	23.1589	7580664.0
2012-08-17 16:30:00	AAPL	Stock	23.1654	23.1732	23.1	23.1732	851536.0
2012-08-17 17:00:00	AAPL	Stock	23.1721	23.1786	23.1668	23.1696	883624.0
2012-08-17 17:30:00	AAPL	Stock	23.1768	23.1768	23.1629	23.1629	78904.0
2012-08-17 18:00:00	AAPL	Stock	23.1661	23.1739	23.1589	23.1589	178948.0
2012-08-17 18:30:00	AAPL	Stock	23.1625	23.1711	23.1536	23.1704	61152.0
2012-08-17 19:00:00	AAPL	Stock	23.1707	23.175	23.1686	23.175	97720.0
2012-08-17 19:30:00	AAPL	Stock	23.1768	23.18	23.1714	23.175	148960.0
2012-08-17 07:00:00	MSFT	Stock	30.96	30.97	30.92	30.92	3000.0
2012-08-17 08:00:00	MSFT	Stock	30.82	30.9	30.81	30.9	800.0
2012-08-17 08:30:00	MSFT	Stock	30.86	30.88	30.86	30.88	2900.0
2012-08-17 09:00:00	MSFT	Stock	30.78	30.98	30.78	30.9	285883.0
2012-08-17 09:30:00	MSFT	Stock	30.88	30.92	30.65	30.784	10185604.0
2012-08-17 10:00:00	MSFT	Stock	30.79	30.8	30.66	30.7	2851672.0
2012-08-17 10:30:00	MSFT	Stock	30.7	30.7	30.59	30.655	2568720.0
2012-08-17 11:00:00	MSFT	Stock	30.66	30.74	30.61	30.739	2160272.0
2012-08-17 11:30:00	MSFT	Stock	30.73	30.83	30.71	30.819	1613027.0
2012-08-17 12:00:00	MSFT	Stock	30.81	30.82	30.79	30.799	629831.0
2012-08-17 12:30:00	MSFT	Stock	30.79	30.8	30.72	30.745	861442.0
2012-08-17 13:00:00	MSFT	Stock	30.74	30.79	30.74	30.76	694737.0
2012-08-17 13:30:00	MSFT	Stock	30.765	30.81	30.76	30.766	679727.0
2012-08-17 14:00:00	MSFT	Stock	30.77	30.83	30.76	30.815	840032.0
2012-08-17 14:30:00	MSFT	Stock	30.82	30.86	30.81	30.855	796637.0
2012-08-17 15:00:00	MSFT	Stock	30.85	30.88	30.82	30.86	1358902.0
2012-08-17 15:30:00	MSFT	Stock	30.865	30.91	30.84	30.9	4194155.0
2012-08-17 16:00:00	MSFT	Stock	30.9	30.93	30.798	30.93	2206640.0

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

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