PREVIEW / stock_30min / 2011-04-06

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-06.parquet
  size:    1.4 MB
  rows:    75,307
  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-04-06 04:00:00	AAPL	Stock	12.1471	12.1471	12.1429	12.1429	25200.0
2011-04-06 04:30:00	AAPL	Stock	12.1607	12.1607	12.15	12.15	47600.0
2011-04-06 05:00:00	AAPL	Stock	12.1679	12.1679	12.1679	12.1679	14000.0
2011-04-06 06:00:00	AAPL	Stock	12.1661	12.1714	12.1643	12.1643	14000.0
2011-04-06 06:30:00	AAPL	Stock	12.1711	12.1768	12.1604	12.1768	63980.0
2011-04-06 07:00:00	AAPL	Stock	12.1768	12.1768	12.1554	12.1607	156324.0
2011-04-06 07:30:00	AAPL	Stock	12.1679	12.1746	12.1554	12.1729	205408.0
2011-04-06 08:00:00	AAPL	Stock	12.1618	12.2143	12.1607	12.2093	1269492.0
2011-04-06 08:30:00	AAPL	Stock	12.2093	12.2179	12.1707	12.1821	902496.0
2011-04-06 09:00:00	AAPL	Stock	12.1793	12.1964	12.1032	12.1943	1527092.0
2011-04-06 09:30:00	AAPL	Stock	12.1943	12.2821	12.1621	12.2354	71776656.0
2011-04-06 10:00:00	AAPL	Stock	12.235	12.2589	12.1643	12.17	42548548.0
2011-04-06 10:30:00	AAPL	Stock	12.1696	12.2143	12.1532	12.1643	28070168.0
2011-04-06 11:00:00	AAPL	Stock	12.1643	12.1679	12.0871	12.1304	39596200.0
2011-04-06 11:30:00	AAPL	Stock	12.1311	12.1357	12.0582	12.0604	27985356.0
2011-04-06 12:00:00	AAPL	Stock	12.0604	12.1	12.0464	12.0893	22434216.0
2011-04-06 12:30:00	AAPL	Stock	12.0879	12.0896	12.0546	12.0686	15838900.0
2011-04-06 13:00:00	AAPL	Stock	12.0679	12.1071	12.0568	12.1018	17981544.0
2011-04-06 13:30:00	AAPL	Stock	12.101	12.1068	12.0714	12.095	11719652.0
2011-04-06 14:00:00	AAPL	Stock	12.0943	12.1161	12.0707	12.0725	17680152.0
2011-04-06 14:30:00	AAPL	Stock	12.0736	12.095	12.0464	12.0556	23492504.0
2011-04-06 15:00:00	AAPL	Stock	12.0561	12.0818	12.0407	12.0486	23931712.0
2011-04-06 15:30:00	AAPL	Stock	12.0479	12.0893	12.0446	12.0729	34954164.0
2011-04-06 16:00:00	AAPL	Stock	12.0729	12.1339	12.0643	12.0786	10021872.0
2011-04-06 16:30:00	AAPL	Stock	12.0786	12.2037	12.0625	12.0625	357392.0
2011-04-06 17:00:00	AAPL	Stock	12.0611	12.0679	12.0607	12.0643	54460.0
2011-04-06 17:30:00	AAPL	Stock	12.0611	12.0661	12.0536	12.0643	125468.0
2011-04-06 18:00:00	AAPL	Stock	12.0696	12.0729	12.0596	12.0714	162260.0
2011-04-06 18:30:00	AAPL	Stock	12.0714	12.0739	12.0714	12.0714	22456.0
2011-04-06 19:00:00	AAPL	Stock	12.0718	12.0857	12.0714	12.0754	254072.0
2011-04-06 19:30:00	AAPL	Stock	12.0782	12.0782	12.0646	12.0775	122836.0
2011-04-06 05:30:00	MSFT	Stock	25.9	25.9	25.9	25.9	200.0
2011-04-06 06:00:00	MSFT	Stock	25.9	25.95	25.9	25.95	600.0
2011-04-06 06:30:00	MSFT	Stock	25.95	25.95	25.95	25.95	100.0
2011-04-06 07:00:00	MSFT	Stock	25.91	25.94	25.9	25.91	4741.0
2011-04-06 07:30:00	MSFT	Stock	25.9	25.96	25.9	25.95	41732.0
2011-04-06 08:00:00	MSFT	Stock	25.95	25.95	25.9	25.93	76756.0
2011-04-06 08:30:00	MSFT	Stock	25.93	25.94	25.9	25.91	20380.0
2011-04-06 09:00:00	MSFT	Stock	25.78	26.02	25.78	25.99	182744.0
2011-04-06 09:30:00	MSFT	Stock	25.98	26.14	25.86	26.11	8163799.0
2011-04-06 10:00:00	MSFT	Stock	26.11	26.26	26.1	26.25	8022853.0
2011-04-06 10:30:00	MSFT	Stock	26.25	26.31	26.17	26.28	7657822.0
2011-04-06 11:00:00	MSFT	Stock	26.29	26.29	26.08	26.1	6148610.0
2011-04-06 11:30:00	MSFT	Stock	26.1	26.13	26.08	26.09	3401510.0
2011-04-06 12:00:00	MSFT	Stock	26.08	26.15	26.05	26.14	3106541.0
2011-04-06 12:30:00	MSFT	Stock	26.14	26.15	26.04	26.07	2806931.0
2011-04-06 13:00:00	MSFT	Stock	26.08	26.12	26.07	26.12	1715744.0
2011-04-06 13:30:00	MSFT	Stock	26.12	26.17	26.11	26.115	2285085.0
2011-04-06 14:00:00	MSFT	Stock	26.115	26.18	26.11	26.13	2903208.0
2011-04-06 14:30:00	MSFT	Stock	26.135	26.19	26.13	26.185	3150506.0

> showing 50 of 75,307 rows — these rows as CSV

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