PREVIEW / stock_30min / 2011-07-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-18.parquet
  size:    1.4 MB
  rows:    76,368
  symbols: 3,540

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
2011-07-18 04:00:00	AAPL	Stock	13.0571	13.0571	12.9857	12.9857	28000.0
2011-07-18 04:30:00	AAPL	Stock	12.9929	12.9929	12.9643	12.9893	16800.0
2011-07-18 05:00:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	19572.0
2011-07-18 05:30:00	AAPL	Stock	12.9929	12.9982	12.9929	12.9929	11200.0
2011-07-18 06:00:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	5600.0
2011-07-18 06:30:00	AAPL	Stock	12.9829	13.0089	12.9736	12.9739	105420.0
2011-07-18 07:00:00	AAPL	Stock	13.0	13.0289	12.9843	12.995	426328.0
2011-07-18 07:30:00	AAPL	Stock	12.9961	13.0114	12.9861	13.0032	522760.0
2011-07-18 08:00:00	AAPL	Stock	13.0	13.0964	12.9964	13.0725	3480988.0
2011-07-18 08:30:00	AAPL	Stock	13.0725	13.0829	13.0561	13.0625	2415224.0
2011-07-18 09:00:00	AAPL	Stock	13.0625	13.0743	13.0443	13.05	1805440.0
2011-07-18 09:30:00	AAPL	Stock	13.0511	13.2021	13.0457	13.163	113841924.0
2011-07-18 10:00:00	AAPL	Stock	13.1639	13.2025	13.1111	13.1493	56380884.0
2011-07-18 10:30:00	AAPL	Stock	13.15	13.175	13.1396	13.15	34735120.0
2011-07-18 11:00:00	AAPL	Stock	13.151	13.1846	13.1468	13.1779	25621400.0
2011-07-18 11:30:00	AAPL	Stock	13.1796	13.1814	13.1357	13.1407	25830672.0
2011-07-18 12:00:00	AAPL	Stock	13.14	13.1571	13.1375	13.1514	13535732.0
2011-07-18 12:30:00	AAPL	Stock	13.1529	13.1607	13.14	13.1564	15064280.0
2011-07-18 13:00:00	AAPL	Stock	13.1564	13.1689	13.1486	13.1611	16869524.0
2011-07-18 13:30:00	AAPL	Stock	13.1611	13.2121	13.16	13.2114	27652072.0
2011-07-18 14:00:00	AAPL	Stock	13.2096	13.2593	13.1921	13.2539	43640520.0
2011-07-18 14:30:00	AAPL	Stock	13.2543	13.2905	13.2371	13.2854	40906488.0
2011-07-18 15:00:00	AAPL	Stock	13.2854	13.3179	13.2679	13.3179	46934972.0
2011-07-18 15:30:00	AAPL	Stock	13.3179	13.3804	13.3107	13.3507	80829952.0
2011-07-18 16:00:00	AAPL	Stock	13.3516	13.3736	13.1949	13.3732	15446760.0
2011-07-18 16:30:00	AAPL	Stock	13.3714	13.3846	13.1746	13.3736	929852.0
2011-07-18 17:00:00	AAPL	Stock	13.3743	13.3836	13.3732	13.3821	347620.0
2011-07-18 17:30:00	AAPL	Stock	13.3821	13.3893	13.3754	13.3893	450212.0
2011-07-18 18:00:00	AAPL	Stock	13.385	13.3979	13.35	13.3979	526232.0
2011-07-18 18:30:00	AAPL	Stock	13.3929	13.3975	13.3871	13.3896	486052.0
2011-07-18 19:00:00	AAPL	Stock	13.3914	13.3929	13.3839	13.3875	171724.0
2011-07-18 19:30:00	AAPL	Stock	13.3911	13.3975	13.3886	13.3954	231924.0
2011-07-18 06:30:00	MSFT	Stock	26.62	26.62	26.55	26.55	1000.0
2011-07-18 07:00:00	MSFT	Stock	26.56	26.56	26.55	26.56	1100.0
2011-07-18 07:30:00	MSFT	Stock	26.55	26.59	26.55	26.58	1978.0
2011-07-18 08:00:00	MSFT	Stock	26.59	26.67	26.58	26.67	24108.0
2011-07-18 08:30:00	MSFT	Stock	26.67	26.67	26.65	26.67	3248.0
2011-07-18 09:00:00	MSFT	Stock	26.67	26.68	26.62	26.67	43780.0
2011-07-18 09:30:00	MSFT	Stock	26.67	26.9	26.55	26.57	4653655.0
2011-07-18 10:00:00	MSFT	Stock	26.57	26.6	26.34	26.42	4737079.0
2011-07-18 10:30:00	MSFT	Stock	26.41	26.5	26.36	26.39	4000426.0
2011-07-18 11:00:00	MSFT	Stock	26.39	26.48	26.31	26.47	2521454.0
2011-07-18 11:30:00	MSFT	Stock	26.47	26.48	26.26	26.27	3125431.0
2011-07-18 12:00:00	MSFT	Stock	26.27	26.455	26.27	26.395	2389846.0
2011-07-18 12:30:00	MSFT	Stock	26.395	26.4	26.34	26.4	1638760.0
2011-07-18 13:00:00	MSFT	Stock	26.39	26.4	26.315	26.375	1810463.0
2011-07-18 13:30:00	MSFT	Stock	26.372	26.46	26.37	26.44	2092700.0
2011-07-18 14:00:00	MSFT	Stock	26.449	26.5	26.4	26.475	2108527.0
2011-07-18 14:30:00	MSFT	Stock	26.47	26.515	26.41	26.51	2519644.0
2011-07-18 15:00:00	MSFT	Stock	26.51	26.61	26.51	26.55	3598215.0

> showing 50 of 76,368 rows — these rows as CSV

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