PREVIEW / stock_30min / 2013-12-02

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-02.parquet
  size:    1.6 MB
  rows:    82,320
  symbols: 3,538

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-12-02 04:00:00	AAPL	Stock	19.8854	19.8854	19.865	19.865	11200.0
2013-12-02 04:30:00	AAPL	Stock	19.8643	19.9111	19.8643	19.9111	15400.0
2013-12-02 05:00:00	AAPL	Stock	19.9236	19.9329	19.9196	19.9268	48524.0
2013-12-02 05:30:00	AAPL	Stock	19.9268	19.9407	19.9268	19.9389	30800.0
2013-12-02 06:00:00	AAPL	Stock	19.9446	20.0714	19.9446	20.0607	173096.0
2013-12-02 06:30:00	AAPL	Stock	20.0607	20.0607	20.0179	20.0229	156492.0
2013-12-02 07:00:00	AAPL	Stock	20.0064	20.0275	19.9464	19.9464	724080.0
2013-12-02 07:30:00	AAPL	Stock	19.9507	19.9732	19.9336	19.9529	437360.0
2013-12-02 08:00:00	AAPL	Stock	19.9525	20.0318	19.8393	19.9446	2070740.0
2013-12-02 08:30:00	AAPL	Stock	19.9475	19.9643	19.9286	19.9525	1418844.0
2013-12-02 09:00:00	AAPL	Stock	19.9554	19.9793	19.9207	19.9286	2588124.0
2013-12-02 09:30:00	AAPL	Stock	19.9339	20.1546	19.845	19.8546	126423976.0
2013-12-02 10:00:00	AAPL	Stock	19.8532	20.0068	19.8004	19.9836	74886224.0
2013-12-02 10:30:00	AAPL	Stock	19.9875	20.0211	19.8825	19.9217	33295640.0
2013-12-02 11:00:00	AAPL	Stock	19.9243	19.9357	19.8446	19.8486	27626648.0
2013-12-02 11:30:00	AAPL	Stock	19.8514	19.8768	19.7196	19.7539	33859812.0
2013-12-02 12:00:00	AAPL	Stock	19.7539	19.8657	19.7429	19.8529	23612540.0
2013-12-02 12:30:00	AAPL	Stock	19.8561	19.8661	19.7764	19.8293	13919696.0
2013-12-02 13:00:00	AAPL	Stock	19.8286	19.835	19.7796	19.7957	10505544.0
2013-12-02 13:30:00	AAPL	Stock	19.7957	19.8332	19.75	19.7571	16311148.0
2013-12-02 14:00:00	AAPL	Stock	19.7527	19.7568	19.6721	19.6792	25438168.0
2013-12-02 14:30:00	AAPL	Stock	19.6798	19.7785	19.6755	19.7686	16219448.0
2013-12-02 15:00:00	AAPL	Stock	19.7679	19.7811	19.7189	19.7218	13386688.0
2013-12-02 15:30:00	AAPL	Stock	19.7214	19.7268	19.6786	19.6893	29425032.0
2013-12-02 16:00:00	AAPL	Stock	19.6868	19.8771	19.6843	19.6946	12296676.0
2013-12-02 16:30:00	AAPL	Stock	19.6907	19.6946	19.6868	19.6911	64792.0
2013-12-02 17:00:00	AAPL	Stock	19.6946	19.7014	19.6868	19.6971	264320.0
2013-12-02 17:30:00	AAPL	Stock	19.7011	19.7014	19.6868	19.6964	356132.0
2013-12-02 18:00:00	AAPL	Stock	19.6964	19.6968	19.69	19.6968	199052.0
2013-12-02 18:30:00	AAPL	Stock	19.6993	19.7043	19.6964	19.6964	159068.0
2013-12-02 19:00:00	AAPL	Stock	19.6946	19.6975	19.6904	19.6936	97580.0
2013-12-02 19:30:00	AAPL	Stock	19.7036	19.7043	19.7032	19.7043	38696.0
2013-12-02 07:00:00	MSFT	Stock	38.2	38.2	38.0	38.0	3600.0
2013-12-02 07:30:00	MSFT	Stock	38.05	38.05	38.04	38.04	3400.0
2013-12-02 08:00:00	MSFT	Stock	38.1	38.18	38.1	38.18	3295.0
2013-12-02 08:30:00	MSFT	Stock	38.17	38.17	38.17	38.17	500.0
2013-12-02 09:00:00	MSFT	Stock	38.15	38.18	38.11	38.13	17195.0
2013-12-02 09:30:00	MSFT	Stock	38.09	38.49	38.06	38.37	5387501.0
2013-12-02 10:00:00	MSFT	Stock	38.37	38.49	38.33	38.36	3668545.0
2013-12-02 10:30:00	MSFT	Stock	38.365	38.4	38.15	38.37	4740856.0
2013-12-02 11:00:00	MSFT	Stock	38.37	38.52	38.36	38.44	2384550.0
2013-12-02 11:30:00	MSFT	Stock	38.445	38.54	38.39	38.533	1930988.0
2013-12-02 12:00:00	MSFT	Stock	38.535	38.67	38.53	38.652	1814260.0
2013-12-02 12:30:00	MSFT	Stock	38.65	38.78	38.51	38.515	3461111.0
2013-12-02 13:00:00	MSFT	Stock	38.51	38.556	38.5	38.5	1246404.0
2013-12-02 13:30:00	MSFT	Stock	38.5	38.52	38.44	38.494	1981161.0
2013-12-02 14:00:00	MSFT	Stock	38.495	38.53	38.44	38.505	1775018.0
2013-12-02 14:30:00	MSFT	Stock	38.5	38.52	38.44	38.508	1812273.0
2013-12-02 15:00:00	MSFT	Stock	38.505	38.51	38.38	38.4	1988700.0
2013-12-02 15:30:00	MSFT	Stock	38.39	38.47	38.34	38.455	6163638.0

> showing 50 of 82,320 rows — these rows as CSV

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