PREVIEW / stock_30min / 2014-08-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-25.parquet
  size:    1.6 MB
  rows:    81,427
  symbols: 3,582

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
2014-08-25 04:30:00	AAPL	Stock	25.3375	25.5325	25.3375	25.49	25340.0
2014-08-25 05:00:00	AAPL	Stock	25.49	25.495	25.4575	25.4575	10744.0
2014-08-25 05:30:00	AAPL	Stock	25.45	25.465	25.4475	25.465	19056.0
2014-08-25 06:00:00	AAPL	Stock	25.4525	25.47	25.45	25.45	45412.0
2014-08-25 06:30:00	AAPL	Stock	25.45	25.4725	25.45	25.4725	59140.0
2014-08-25 07:00:00	AAPL	Stock	25.4725	25.52	25.455	25.505	146728.0
2014-08-25 07:30:00	AAPL	Stock	25.505	25.5125	25.4725	25.475	142104.0
2014-08-25 08:00:00	AAPL	Stock	25.4712	25.5125	25.3275	25.4775	611048.0
2014-08-25 08:30:00	AAPL	Stock	25.475	25.5125	25.4675	25.4875	389320.0
2014-08-25 09:00:00	AAPL	Stock	25.4825	25.5	25.4475	25.4525	525204.0
2014-08-25 09:30:00	AAPL	Stock	25.4525	25.5425	25.4225	25.4525	32836540.0
2014-08-25 10:00:00	AAPL	Stock	25.45	25.4825	25.385	25.436	19460344.0
2014-08-25 10:30:00	AAPL	Stock	25.435	25.505	25.4225	25.49	12349016.0
2014-08-25 11:00:00	AAPL	Stock	25.49	25.5	25.455	25.495	7536936.0
2014-08-25 11:30:00	AAPL	Stock	25.4975	25.515	25.4775	25.485	8930716.0
2014-08-25 12:00:00	AAPL	Stock	25.4825	25.4975	25.425	25.4372	6812980.0
2014-08-25 12:30:00	AAPL	Stock	25.4368	25.4475	25.365	25.3925	9487564.0
2014-08-25 13:00:00	AAPL	Stock	25.39	25.42	25.32	25.42	9376216.0
2014-08-25 13:30:00	AAPL	Stock	25.42	25.4375	25.4038	25.4078	4921456.0
2014-08-25 14:00:00	AAPL	Stock	25.41	25.4125	25.37	25.39	5633356.0
2014-08-25 14:30:00	AAPL	Stock	25.3917	25.405	25.375	25.4025	4288200.0
2014-08-25 15:00:00	AAPL	Stock	25.405	25.42	25.4025	25.42	5497280.0
2014-08-25 15:30:00	AAPL	Stock	25.42	25.4375	25.3825	25.385	13167296.0
2014-08-25 16:00:00	AAPL	Stock	25.3875	25.3992	25.375	25.385	8110908.0
2014-08-25 16:30:00	AAPL	Stock	25.385	25.3875	20.8337	25.3775	161984.0
2014-08-25 17:00:00	AAPL	Stock	25.37	25.37	25.3525	25.3525	90616.0
2014-08-25 17:30:00	AAPL	Stock	25.3625	25.4312	25.3525	25.38	204972.0
2014-08-25 18:00:00	AAPL	Stock	25.3725	25.385	25.3625	25.3725	89500.0
2014-08-25 18:30:00	AAPL	Stock	25.385	25.385	25.3625	25.3675	97012.0
2014-08-25 19:00:00	AAPL	Stock	25.3675	25.3675	25.3625	25.3625	27920.0
2014-08-25 19:30:00	AAPL	Stock	25.36	25.3625	25.305	25.3225	240076.0
2014-08-25 08:00:00	MSFT	Stock	45.28	45.3	45.24	45.25	1371.0
2014-08-25 08:30:00	MSFT	Stock	45.3	45.3	45.3	45.3	200.0
2014-08-25 09:00:00	MSFT	Stock	45.3	45.4	45.3	45.39	15988.0
2014-08-25 09:30:00	MSFT	Stock	45.4	45.44	45.3	45.34	1849545.0
2014-08-25 10:00:00	MSFT	Stock	45.34	45.36	45.23	45.3	1418859.0
2014-08-25 10:30:00	MSFT	Stock	45.299	45.43	45.24	45.4	1133907.0
2014-08-25 11:00:00	MSFT	Stock	45.4	45.43	45.25	45.28	911675.0
2014-08-25 11:30:00	MSFT	Stock	45.27	45.3	45.23	45.235	455059.0
2014-08-25 12:00:00	MSFT	Stock	45.234	45.24	45.05	45.08	947487.0
2014-08-25 12:30:00	MSFT	Stock	45.084	45.16	45.05	45.12	693747.0
2014-08-25 13:00:00	MSFT	Stock	45.11	45.15	45.04	45.13	622416.0
2014-08-25 13:30:00	MSFT	Stock	45.135	45.155	45.1	45.1	484623.0
2014-08-25 14:00:00	MSFT	Stock	45.1	45.14	45.06	45.12	462791.0
2014-08-25 14:30:00	MSFT	Stock	45.115	45.24	45.11	45.23	631945.0
2014-08-25 15:00:00	MSFT	Stock	45.23	45.28	45.2	45.236	1242372.0
2014-08-25 15:30:00	MSFT	Stock	45.24	45.25	45.14	45.18	2639857.0
2014-08-25 16:00:00	MSFT	Stock	45.17	45.231	45.15	45.17	2798302.0
2014-08-25 17:30:00	MSFT	Stock	45.204	45.204	45.17	45.17	82265.0
2014-08-25 19:30:00	MSFT	Stock	45.14	45.14	45.14	45.14	2400.0

> showing 50 of 81,427 rows — these rows as CSV

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