PREVIEW / stock_30min / 2013-03-06

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-06.parquet
  size:    1.5 MB
  rows:    76,377
  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
2013-03-06 04:00:00	AAPL	Stock	15.3979	15.3979	15.3929	15.3929	11200.0
2013-03-06 04:30:00	AAPL	Stock	15.4286	15.4286	15.4286	15.4286	11200.0
2013-03-06 05:00:00	AAPL	Stock	15.4214	15.4286	15.4007	15.4286	21560.0
2013-03-06 05:30:00	AAPL	Stock	15.4214	15.4214	15.4146	15.4146	14168.0
2013-03-06 06:00:00	AAPL	Stock	15.4214	15.4232	15.4125	15.4232	30800.0
2013-03-06 07:00:00	AAPL	Stock	15.4196	15.4554	15.4018	15.4554	212128.0
2013-03-06 07:30:00	AAPL	Stock	15.45	15.45	15.32	15.3746	801472.0
2013-03-06 08:00:00	AAPL	Stock	15.3754	15.4568	15.3518	15.4464	1457764.0
2013-03-06 08:30:00	AAPL	Stock	15.4518	15.4821	15.4411	15.4571	1709932.0
2013-03-06 09:00:00	AAPL	Stock	15.4561	15.5357	15.45	15.5243	3930136.0
2013-03-06 09:30:00	AAPL	Stock	15.52	15.5446	15.2268	15.25	97746180.0
2013-03-06 10:00:00	AAPL	Stock	15.25	15.3214	15.2039	15.3082	51003736.0
2013-03-06 10:30:00	AAPL	Stock	15.3036	15.3039	15.2143	15.2779	33528152.0
2013-03-06 11:00:00	AAPL	Stock	15.2789	15.3814	15.2536	15.3425	33835592.0
2013-03-06 11:30:00	AAPL	Stock	15.341	15.3571	15.2757	15.2879	18144364.0
2013-03-06 12:00:00	AAPL	Stock	15.2835	15.3136	15.265	15.2718	13505156.0
2013-03-06 12:30:00	AAPL	Stock	15.2721	15.2832	15.21	15.2193	19178740.0
2013-03-06 13:00:00	AAPL	Stock	15.2196	15.24	15.1904	15.2139	22201536.0
2013-03-06 13:30:00	AAPL	Stock	15.2143	15.2282	15.1825	15.2061	18937604.0
2013-03-06 14:00:00	AAPL	Stock	15.2057	15.2571	15.1964	15.2446	16777264.0
2013-03-06 14:30:00	AAPL	Stock	15.2439	15.2946	15.2339	15.2561	21712236.0
2013-03-06 15:00:00	AAPL	Stock	15.2564	15.2564	15.1875	15.1977	23130632.0
2013-03-06 15:30:00	AAPL	Stock	15.1971	15.2057	15.1582	15.2018	44759624.0
2013-03-06 16:00:00	AAPL	Stock	15.2021	15.2904	15.1843	15.1871	26904360.0
2013-03-06 16:30:00	AAPL	Stock	15.185	15.4384	15.1789	15.1836	464296.0
2013-03-06 17:00:00	AAPL	Stock	15.1854	15.2021	15.1746	15.1786	334208.0
2013-03-06 17:30:00	AAPL	Stock	15.1796	15.1821	15.1786	15.1786	112392.0
2013-03-06 18:00:00	AAPL	Stock	15.1821	15.1821	15.1786	15.1786	163968.0
2013-03-06 18:30:00	AAPL	Stock	15.1818	15.1839	15.175	15.1839	293132.0
2013-03-06 19:00:00	AAPL	Stock	15.1839	15.1839	15.1793	15.1832	98756.0
2013-03-06 19:30:00	AAPL	Stock	15.1814	15.1875	15.1789	15.1829	80500.0
2013-03-06 04:00:00	MSFT	Stock	28.19	28.19	28.19	28.19	100.0
2013-03-06 06:00:00	MSFT	Stock	28.21	28.21	28.15	28.15	2450.0
2013-03-06 06:30:00	MSFT	Stock	28.33	28.33	28.28	28.29	3500.0
2013-03-06 07:00:00	MSFT	Stock	28.24	28.24	28.21	28.21	3200.0
2013-03-06 07:30:00	MSFT	Stock	28.2	28.2	28.08	28.18	13740.0
2013-03-06 08:00:00	MSFT	Stock	28.12	28.3	28.11	28.18	26875.0
2013-03-06 08:30:00	MSFT	Stock	28.18	28.29	28.18	28.29	12225.0
2013-03-06 09:00:00	MSFT	Stock	28.2	28.22	28.17	28.19	33640.0
2013-03-06 09:30:00	MSFT	Stock	28.2	28.23	27.78	27.94	11747428.0
2013-03-06 10:00:00	MSFT	Stock	27.94	27.99	27.9	27.93	4949911.0
2013-03-06 10:30:00	MSFT	Stock	27.93	28.08	27.92	27.934	3591845.0
2013-03-06 11:00:00	MSFT	Stock	27.94	27.995	27.92	27.965	2552343.0
2013-03-06 11:30:00	MSFT	Stock	27.961	28.04	27.954	27.995	2963686.0
2013-03-06 12:00:00	MSFT	Stock	27.996	28.02	27.968	28.0	2751054.0
2013-03-06 12:30:00	MSFT	Stock	28.01	28.045	28.0	28.005	2309175.0
2013-03-06 13:00:00	MSFT	Stock	28.01	28.04	28.0	28.035	1360307.0
2013-03-06 13:30:00	MSFT	Stock	28.032	28.1	28.02	28.085	1860228.0
2013-03-06 14:00:00	MSFT	Stock	28.08	28.11	28.04	28.092	2750575.0
2013-03-06 14:30:00	MSFT	Stock	28.1	28.22	28.09	28.155	3614434.0

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

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