PREVIEW / stock_1hour / 2013-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-20.parquet
  size:    961 KB
  rows:    44,910
  symbols: 3,458

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-20 04:00:00	AAPL	Stock	16.3036	16.3036	16.3036	16.3036	5600.0
2013-03-20 05:00:00	AAPL	Stock	16.31	16.3107	16.31	16.3107	14840.0
2013-03-20 06:00:00	AAPL	Stock	16.3143	16.3286	16.3018	16.3125	41944.0
2013-03-20 07:00:00	AAPL	Stock	16.3179	16.3179	16.2721	16.2839	430080.0
2013-03-20 08:00:00	AAPL	Stock	16.3118	16.3286	16.2318	16.3043	2360764.0
2013-03-20 09:00:00	AAPL	Stock	16.3036	16.3514	16.084	16.0846	68872272.0
2013-03-20 10:00:00	AAPL	Stock	16.0851	16.1954	16.0849	16.1146	58829960.0
2013-03-20 11:00:00	AAPL	Stock	16.1118	16.1393	16.0568	16.0675	33230820.0
2013-03-20 12:00:00	AAPL	Stock	16.0686	16.1687	16.0657	16.1687	28613536.0
2013-03-20 13:00:00	AAPL	Stock	16.1604	16.1707	16.1147	16.1314	17100328.0
2013-03-20 14:00:00	AAPL	Stock	16.1254	16.1714	16.1157	16.1375	28449680.0
2013-03-20 15:00:00	AAPL	Stock	16.1371	16.1675	16.1036	16.1439	49307552.0
2013-03-20 16:00:00	AAPL	Stock	16.1464	16.15	16.0936	16.1011	9393832.0
2013-03-20 17:00:00	AAPL	Stock	16.0996	16.1457	16.0929	16.1018	689136.0
2013-03-20 18:00:00	AAPL	Stock	16.1	16.1161	16.0964	16.1161	225372.0
2013-03-20 19:00:00	AAPL	Stock	16.11	16.1171	16.0893	16.0946	367864.0
2013-03-20 05:00:00	MSFT	Stock	28.3	28.33	28.3	28.33	309.0
2013-03-20 07:00:00	MSFT	Stock	28.2	28.29	28.2	28.29	600.0
2013-03-20 08:00:00	MSFT	Stock	28.21	28.35	28.21	28.28	76851.0
2013-03-20 09:00:00	MSFT	Stock	28.28	28.49	28.28	28.31	4749846.0
2013-03-20 10:00:00	MSFT	Stock	28.315	28.39	28.19	28.305	5424352.0
2013-03-20 11:00:00	MSFT	Stock	28.315	28.32	28.18	28.19	4143112.0
2013-03-20 12:00:00	MSFT	Stock	28.19	28.26	28.18	28.24	3388135.0
2013-03-20 13:00:00	MSFT	Stock	28.245	28.265	28.22	28.25	2101897.0
2013-03-20 14:00:00	MSFT	Stock	28.245	28.395	28.23	28.33	4251402.0
2013-03-20 15:00:00	MSFT	Stock	28.33	28.345	28.23	28.3	7697289.0
2013-03-20 16:00:00	MSFT	Stock	28.3	28.34	28.06	28.17	3017338.0
2013-03-20 17:00:00	MSFT	Stock	28.16	28.32	28.16	28.17	39682.0
2013-03-20 18:00:00	MSFT	Stock	28.2	28.22	28.18	28.22	6059.0
2013-03-20 19:00:00	MSFT	Stock	28.22	28.22	28.22	28.22	800.0
2013-03-20 09:00:00	NVDA	Stock	0.3118	0.3155	0.3118	0.3129	48907760.0
2013-03-20 10:00:00	NVDA	Stock	0.3128	0.3143	0.3123	0.3131	76665640.0
2013-03-20 11:00:00	NVDA	Stock	0.313	0.315	0.3128	0.315	34997240.0
2013-03-20 12:00:00	NVDA	Stock	0.315	0.3165	0.3144	0.3156	37943440.0
2013-03-20 13:00:00	NVDA	Stock	0.3155	0.3163	0.315	0.3155	27899920.0
2013-03-20 14:00:00	NVDA	Stock	0.3153	0.3161	0.3153	0.3156	35724320.0
2013-03-20 15:00:00	NVDA	Stock	0.3156	0.3158	0.3148	0.3153	66691040.0
2013-03-20 16:00:00	NVDA	Stock	0.3153	0.3155	0.3143	0.315	11442960.0
2013-03-20 17:00:00	NVDA	Stock	0.3148	0.3148	0.314	0.314	88000.0
2013-03-20 04:00:00	AMZN	Stock	12.8405	12.8405	12.8405	12.8405	2000.0
2013-03-20 06:00:00	AMZN	Stock	12.895	12.895	12.895	12.895	2000.0
2013-03-20 07:00:00	AMZN	Stock	12.857	12.857	12.84	12.841	8000.0
2013-03-20 08:00:00	AMZN	Stock	12.8495	12.8655	12.8435	12.8545	230700.0
2013-03-20 09:00:00	AMZN	Stock	12.8505	12.988	12.7275	12.8525	10097360.0
2013-03-20 10:00:00	AMZN	Stock	12.853	12.9315	12.8201	12.877	9290360.0
2013-03-20 11:00:00	AMZN	Stock	12.885	12.8945	12.7865	12.7915	4561260.0
2013-03-20 12:00:00	AMZN	Stock	12.7915	12.8745	12.769	12.863	5008740.0
2013-03-20 13:00:00	AMZN	Stock	12.858	12.8765	12.8245	12.8295	3571160.0
2013-03-20 14:00:00	AMZN	Stock	12.8255	12.873	12.8215	12.8375	4759560.0
2013-03-20 15:00:00	AMZN	Stock	12.841	12.8875	12.815	12.8615	10289680.0

> showing 50 of 44,910 rows — these rows as CSV

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