PREVIEW / stock_30min / 2012-02-03

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-03.parquet
  size:    1.5 MB
  rows:    79,458
  symbols: 3,543

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
2012-02-03 04:30:00	AAPL	Stock	16.2661	16.2661	16.2661	16.2661	2800.0
2012-02-03 06:00:00	AAPL	Stock	16.2714	16.2714	16.2714	16.2714	7140.0
2012-02-03 06:30:00	AAPL	Stock	16.2714	16.2714	16.2714	16.2714	14000.0
2012-02-03 07:00:00	AAPL	Stock	16.275	16.275	16.2714	16.2714	46760.0
2012-02-03 07:30:00	AAPL	Stock	16.2607	16.2696	16.2589	16.2589	77896.0
2012-02-03 08:00:00	AAPL	Stock	16.2639	16.2639	16.2136	16.2489	497728.0
2012-02-03 08:30:00	AAPL	Stock	16.25	16.3571	16.2364	16.3311	4604796.0
2012-02-03 09:00:00	AAPL	Stock	16.3375	16.3393	16.3196	16.3321	1077468.0
2012-02-03 09:30:00	AAPL	Stock	16.3289	16.3375	16.27	16.3179	37846956.0
2012-02-03 10:00:00	AAPL	Stock	16.3143	16.3893	16.3107	16.3589	37911440.0
2012-02-03 10:30:00	AAPL	Stock	16.3593	16.3796	16.3482	16.3789	22947932.0
2012-02-03 11:00:00	AAPL	Stock	16.3779	16.3875	16.3579	16.385	15638056.0
2012-02-03 11:30:00	AAPL	Stock	16.3836	16.4179	16.3793	16.4068	23810248.0
2012-02-03 12:00:00	AAPL	Stock	16.405	16.4179	16.3943	16.4109	15629824.0
2012-02-03 12:30:00	AAPL	Stock	16.41	16.4214	16.4029	16.4179	10241896.0
2012-02-03 13:00:00	AAPL	Stock	16.4175	16.4243	16.4125	16.4193	7883848.0
2012-02-03 13:30:00	AAPL	Stock	16.4186	16.42	16.4036	16.4143	8817704.0
2012-02-03 14:00:00	AAPL	Stock	16.4136	16.4286	16.4096	16.4264	15839908.0
2012-02-03 14:30:00	AAPL	Stock	16.4261	16.4286	16.4193	16.4243	14937468.0
2012-02-03 15:00:00	AAPL	Stock	16.4239	16.4257	16.3939	16.4068	15662304.0
2012-02-03 15:30:00	AAPL	Stock	16.4057	16.4214	16.3892	16.4129	31903900.0
2012-02-03 16:00:00	AAPL	Stock	16.4161	16.4221	16.2543	16.4171	19552540.0
2012-02-03 16:30:00	AAPL	Stock	16.4011	16.4204	16.3964	16.3964	377524.0
2012-02-03 17:00:00	AAPL	Stock	16.3975	16.4171	16.395	16.3971	141820.0
2012-02-03 17:30:00	AAPL	Stock	16.3982	16.3982	16.3929	16.3954	70336.0
2012-02-03 18:00:00	AAPL	Stock	16.3961	16.4171	16.395	16.395	47068.0
2012-02-03 18:30:00	AAPL	Stock	16.3964	16.3989	16.3946	16.3989	91840.0
2012-02-03 19:00:00	AAPL	Stock	16.3968	16.4	16.3946	16.3968	72744.0
2012-02-03 19:30:00	AAPL	Stock	16.3993	16.3993	16.3932	16.3932	97552.0
2012-02-03 06:30:00	MSFT	Stock	30.06	30.06	30.06	30.06	500.0
2012-02-03 07:00:00	MSFT	Stock	30.01	30.01	30.01	30.01	400.0
2012-02-03 07:30:00	MSFT	Stock	30.06	30.08	30.06	30.08	1200.0
2012-02-03 08:00:00	MSFT	Stock	30.01	30.06	29.96	30.05	5477.0
2012-02-03 08:30:00	MSFT	Stock	30.06	30.2	29.95	30.16	191783.0
2012-02-03 09:00:00	MSFT	Stock	30.16	30.19	30.1	30.13	95439.0
2012-02-03 09:30:00	MSFT	Stock	30.15	30.3	30.09	30.298	5299117.0
2012-02-03 10:00:00	MSFT	Stock	30.29	30.35	30.24	30.275	3928392.0
2012-02-03 10:30:00	MSFT	Stock	30.28	30.345	30.25	30.33	3118847.0
2012-02-03 11:00:00	MSFT	Stock	30.32	30.38	30.3	30.355	4295972.0
2012-02-03 11:30:00	MSFT	Stock	30.353	30.37	30.27	30.315	2704061.0
2012-02-03 12:00:00	MSFT	Stock	30.31	30.38	30.3	30.37	1953809.0
2012-02-03 12:30:00	MSFT	Stock	30.375	30.4	30.32	30.355	2786885.0
2012-02-03 13:00:00	MSFT	Stock	30.36	30.37	30.32	30.345	1779019.0
2012-02-03 13:30:00	MSFT	Stock	30.345	30.35	30.28	30.3	1711422.0
2012-02-03 14:00:00	MSFT	Stock	30.3	30.31	30.25	30.31	2127164.0
2012-02-03 14:30:00	MSFT	Stock	30.301	30.31	30.24	30.28	1518182.0
2012-02-03 15:00:00	MSFT	Stock	30.28	30.28	30.18	30.26	2191038.0
2012-02-03 15:30:00	MSFT	Stock	30.26	30.28	30.17	30.22	5210182.0
2012-02-03 16:00:00	MSFT	Stock	30.22	30.288	29.95	30.24	2553992.0
2012-02-03 16:30:00	MSFT	Stock	30.19	30.246	30.16	30.16	41321.0

> showing 50 of 79,458 rows — these rows as CSV

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