PREVIEW / stock_1hour / 2014-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-25.parquet
  size:    1.0 MB
  rows:    48,371
  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:00: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.4475	25.465	29800.0
2014-08-25 06:00:00	AAPL	Stock	25.4525	25.4725	25.45	25.4725	104552.0
2014-08-25 07:00:00	AAPL	Stock	25.4725	25.52	25.455	25.475	288832.0
2014-08-25 08:00:00	AAPL	Stock	25.4712	25.5125	25.3275	25.4875	1000368.0
2014-08-25 09:00:00	AAPL	Stock	25.4825	25.5425	25.4225	25.4525	33361744.0
2014-08-25 10:00:00	AAPL	Stock	25.45	25.505	25.385	25.49	31809360.0
2014-08-25 11:00:00	AAPL	Stock	25.49	25.515	25.455	25.485	16467652.0
2014-08-25 12:00:00	AAPL	Stock	25.4825	25.4975	25.365	25.3925	16300544.0
2014-08-25 13:00:00	AAPL	Stock	25.39	25.4375	25.32	25.4078	14297672.0
2014-08-25 14:00:00	AAPL	Stock	25.41	25.4125	25.37	25.4025	9921556.0
2014-08-25 15:00:00	AAPL	Stock	25.405	25.4375	25.3825	25.385	18664576.0
2014-08-25 16:00:00	AAPL	Stock	25.3875	25.3992	20.8337	25.3775	8272892.0
2014-08-25 17:00:00	AAPL	Stock	25.37	25.4312	25.3525	25.38	295588.0
2014-08-25 18:00:00	AAPL	Stock	25.3725	25.385	25.3625	25.3675	186512.0
2014-08-25 19:00:00	AAPL	Stock	25.3675	25.3675	25.305	25.3225	267996.0
2014-08-25 08:00:00	MSFT	Stock	45.28	45.3	45.24	45.3	1571.0
2014-08-25 09:00:00	MSFT	Stock	45.3	45.44	45.3	45.34	1865533.0
2014-08-25 10:00:00	MSFT	Stock	45.34	45.43	45.23	45.4	2552766.0
2014-08-25 11:00:00	MSFT	Stock	45.4	45.43	45.23	45.235	1366734.0
2014-08-25 12:00:00	MSFT	Stock	45.234	45.24	45.05	45.12	1641234.0
2014-08-25 13:00:00	MSFT	Stock	45.11	45.155	45.04	45.1	1107039.0
2014-08-25 14:00:00	MSFT	Stock	45.1	45.24	45.06	45.23	1094736.0
2014-08-25 15:00:00	MSFT	Stock	45.23	45.28	45.14	45.18	3882229.0
2014-08-25 16:00:00	MSFT	Stock	45.17	45.231	45.15	45.17	2798302.0
2014-08-25 17:00:00	MSFT	Stock	45.204	45.204	45.17	45.17	82265.0
2014-08-25 19:00:00	MSFT	Stock	45.14	45.14	45.14	45.14	2400.0
2014-08-25 07:00:00	NVDA	Stock	0.48	0.48	0.48	0.48	52000.0
2014-08-25 09:00:00	NVDA	Stock	0.4775	0.48	0.4769	0.4799	15004600.0
2014-08-25 10:00:00	NVDA	Stock	0.48	0.4822	0.479	0.481	26505680.0
2014-08-25 11:00:00	NVDA	Stock	0.481	0.481	0.4793	0.4798	22094120.0
2014-08-25 12:00:00	NVDA	Stock	0.48	0.48	0.477	0.4785	15663000.0
2014-08-25 13:00:00	NVDA	Stock	0.4784	0.479	0.4772	0.479	14021720.0
2014-08-25 14:00:00	NVDA	Stock	0.4788	0.479	0.4768	0.4779	18285920.0
2014-08-25 15:00:00	NVDA	Stock	0.4779	0.4788	0.4772	0.4775	27113200.0
2014-08-25 16:00:00	NVDA	Stock	0.4778	0.4778	0.4774	0.4775	981280.0
2014-08-25 18:00:00	NVDA	Stock	0.4778	0.4778	0.4778	0.4778	20000.0
2014-08-25 07:00:00	AMZN	Stock	16.65	16.65	16.635	16.65	34200.0
2014-08-25 08:00:00	AMZN	Stock	16.65	16.6895	16.5795	16.6845	420920.0
2014-08-25 09:00:00	AMZN	Stock	16.669	16.744	16.6355	16.743	5638200.0
2014-08-25 10:00:00	AMZN	Stock	16.744	16.8385	16.705	16.7575	9349280.0
2014-08-25 11:00:00	AMZN	Stock	16.755	16.773	16.729	16.734	4059640.0
2014-08-25 12:00:00	AMZN	Stock	16.729	16.7425	16.672	16.722	3052000.0
2014-08-25 13:00:00	AMZN	Stock	16.724	16.765	16.678	16.7455	3477340.0
2014-08-25 14:00:00	AMZN	Stock	16.75	16.759	16.686	16.72	2891460.0
2014-08-25 15:00:00	AMZN	Stock	16.711	16.7254	16.6834	16.7055	4538820.0
2014-08-25 16:00:00	AMZN	Stock	16.701	16.7348	16.701	16.7205	689920.0
2014-08-25 17:00:00	AMZN	Stock	16.7315	16.7375	16.723	16.7375	23940.0
2014-08-25 18:00:00	AMZN	Stock	16.7425	16.78	16.701	16.7375	45380.0
2014-08-25 19:00:00	AMZN	Stock	16.75	16.75	16.75	16.75	4980.0

> showing 50 of 48,371 rows — these rows as CSV

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