PREVIEW / stock_30min / 2011-11-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-01.parquet
  size:    1.4 MB
  rows:    76,953
  symbols: 3,497

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-11-01 04:00:00	AAPL	Stock	14.4021	14.4021	14.2529	14.2529	33152.0
2011-11-01 04:30:00	AAPL	Stock	14.2529	14.3214	14.2529	14.3007	11200.0
2011-11-01 05:00:00	AAPL	Stock	14.3204	14.3204	14.3018	14.3018	22400.0
2011-11-01 05:30:00	AAPL	Stock	14.2982	14.2982	14.2982	14.2982	2800.0
2011-11-01 06:00:00	AAPL	Stock	14.2821	14.2821	14.2614	14.2625	46704.0
2011-11-01 06:30:00	AAPL	Stock	14.2625	14.2625	14.2625	14.2625	2800.0
2011-11-01 07:00:00	AAPL	Stock	14.2768	14.3	14.2589	14.2661	337820.0
2011-11-01 07:30:00	AAPL	Stock	14.2611	14.2857	14.1943	14.2457	538552.0
2011-11-01 08:00:00	AAPL	Stock	14.2571	14.2857	14.1968	14.2	2153340.0
2011-11-01 08:30:00	AAPL	Stock	14.2136	14.2346	14.1868	14.2136	2597924.0
2011-11-01 09:00:00	AAPL	Stock	14.2054	14.4564	14.1643	14.18	2790340.0
2011-11-01 09:30:00	AAPL	Stock	14.1914	14.2679	14.1429	14.2296	81432120.0
2011-11-01 10:00:00	AAPL	Stock	14.2325	14.2589	14.1871	14.2011	45595508.0
2011-11-01 10:30:00	AAPL	Stock	14.2011	14.265	14.1893	14.2102	32214924.0
2011-11-01 11:00:00	AAPL	Stock	14.2061	14.2089	14.1518	14.1643	31320744.0
2011-11-01 11:30:00	AAPL	Stock	14.1643	14.1782	14.09	14.0982	42813596.0
2011-11-01 12:00:00	AAPL	Stock	14.0968	14.1507	14.0436	14.1332	39822748.0
2011-11-01 12:30:00	AAPL	Stock	14.1311	14.1589	14.1054	14.1057	19715808.0
2011-11-01 13:00:00	AAPL	Stock	14.1057	14.1496	14.0732	14.1493	25973332.0
2011-11-01 13:30:00	AAPL	Stock	14.1468	14.2321	14.1468	14.185	45242316.0
2011-11-01 14:00:00	AAPL	Stock	14.1846	14.2536	14.1646	14.2407	29910132.0
2011-11-01 14:30:00	AAPL	Stock	14.2389	14.2543	14.1786	14.1964	26262236.0
2011-11-01 15:00:00	AAPL	Stock	14.1946	14.1996	14.1429	14.1696	27805764.0
2011-11-01 15:30:00	AAPL	Stock	14.1689	14.2075	14.1071	14.1657	59909108.0
2011-11-01 16:00:00	AAPL	Stock	14.1611	14.2036	14.1539	14.1982	9068052.0
2011-11-01 16:30:00	AAPL	Stock	14.2036	14.2039	14.1561	14.1964	361536.0
2011-11-01 17:00:00	AAPL	Stock	14.1964	14.2407	14.1611	14.2182	762608.0
2011-11-01 17:30:00	AAPL	Stock	14.225	14.2261	14.2093	14.2093	47600.0
2011-11-01 18:00:00	AAPL	Stock	14.2011	14.2114	14.1611	14.2	203504.0
2011-11-01 18:30:00	AAPL	Stock	14.2014	14.21	14.1857	14.1857	99820.0
2011-11-01 19:00:00	AAPL	Stock	14.1857	14.1857	14.1714	14.1786	259140.0
2011-11-01 19:30:00	AAPL	Stock	14.1786	14.1868	14.1721	14.1721	104160.0
2011-11-01 04:30:00	MSFT	Stock	26.3	26.3	26.26	26.26	200.0
2011-11-01 06:00:00	MSFT	Stock	26.2	26.2	26.2	26.2	500.0
2011-11-01 06:30:00	MSFT	Stock	26.13	26.14	26.13	26.14	2500.0
2011-11-01 07:00:00	MSFT	Stock	26.25	26.35	26.25	26.35	3400.0
2011-11-01 07:30:00	MSFT	Stock	26.25	26.32	26.18	26.22	10387.0
2011-11-01 08:00:00	MSFT	Stock	26.19	26.35	26.14	26.21	38608.0
2011-11-01 08:30:00	MSFT	Stock	26.22	26.63	26.0	26.1	62685.0
2011-11-01 09:00:00	MSFT	Stock	26.07	26.63	26.05	26.16	98220.0
2011-11-01 09:30:00	MSFT	Stock	26.19	26.28	25.97	26.2	6164380.0
2011-11-01 10:00:00	MSFT	Stock	26.2	26.32	26.09	26.26	5874963.0
2011-11-01 10:30:00	MSFT	Stock	26.261	26.28	26.2	26.23	3473988.0
2011-11-01 11:00:00	MSFT	Stock	26.225	26.29	26.16	26.218	2424271.0
2011-11-01 11:30:00	MSFT	Stock	26.22	26.235	26.03	26.08	3675207.0
2011-11-01 12:00:00	MSFT	Stock	26.078	26.1	25.97	26.02	3754278.0
2011-11-01 12:30:00	MSFT	Stock	26.02	26.06	25.87	25.88	3410256.0
2011-11-01 13:00:00	MSFT	Stock	25.87	26.07	25.86	26.04	4237536.0
2011-11-01 13:30:00	MSFT	Stock	26.04	26.21	26.03	26.13	3690477.0
2011-11-01 14:00:00	MSFT	Stock	26.13	26.21	26.1	26.17	2367927.0

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

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