PREVIEW / stock_1hour / 2013-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-27.parquet
  size:    1022 KB
  rows:    47,323
  symbols: 3,531

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-27 04:00:00	AAPL	Stock	20.1643	20.1643	20.1571	20.1571	14000.0
2013-12-27 05:00:00	AAPL	Stock	20.15	20.15	20.1179	20.1179	36400.0
2013-12-27 06:00:00	AAPL	Stock	20.1279	20.1661	20.1279	20.1621	26600.0
2013-12-27 07:00:00	AAPL	Stock	20.1786	20.1961	20.16	20.1821	109816.0
2013-12-27 08:00:00	AAPL	Stock	20.14	20.2143	20.1286	20.1446	561568.0
2013-12-27 09:00:00	AAPL	Stock	20.1447	20.1671	20.0375	20.0432	38335248.0
2013-12-27 10:00:00	AAPL	Stock	20.0389	20.1032	19.9854	19.9876	46235336.0
2013-12-27 11:00:00	AAPL	Stock	19.9861	20.0186	19.9821	19.9976	30603272.0
2013-12-27 12:00:00	AAPL	Stock	19.9998	20.0396	19.9932	20.0264	15863568.0
2013-12-27 13:00:00	AAPL	Stock	20.0307	20.0371	20.0036	20.0132	9165380.0
2013-12-27 14:00:00	AAPL	Stock	20.015	20.0221	19.9929	19.9933	11179140.0
2013-12-27 15:00:00	AAPL	Stock	19.9957	20.0054	19.9854	20.0032	33231744.0
2013-12-27 16:00:00	AAPL	Stock	20.0032	20.0311	19.9975	20.0	5636624.0
2013-12-27 17:00:00	AAPL	Stock	20.0	20.0032	19.9971	20.0	293104.0
2013-12-27 18:00:00	AAPL	Stock	20.0018	20.0018	19.9982	19.9982	17024.0
2013-12-27 19:00:00	AAPL	Stock	19.9879	19.9982	19.9839	19.9982	174524.0
2013-12-27 07:00:00	MSFT	Stock	37.55	37.55	37.5	37.5	2650.0
2013-12-27 08:00:00	MSFT	Stock	37.47	37.5	37.47	37.5	7999.0
2013-12-27 09:00:00	MSFT	Stock	37.5	37.64	37.41	37.43	2188370.0
2013-12-27 10:00:00	MSFT	Stock	37.42	37.62	37.28	37.305	2768827.0
2013-12-27 11:00:00	MSFT	Stock	37.31	37.37	37.25	37.32	2352266.0
2013-12-27 12:00:00	MSFT	Stock	37.32	37.33	37.17	37.205	1206601.0
2013-12-27 13:00:00	MSFT	Stock	37.2	37.26	37.2	37.223	806560.0
2013-12-27 14:00:00	MSFT	Stock	37.225	37.31	37.22	37.255	1271086.0
2013-12-27 15:00:00	MSFT	Stock	37.255	37.29	37.25	37.29	2151524.0
2013-12-27 16:00:00	MSFT	Stock	37.29	37.392	37.24	37.24	948682.0
2013-12-27 18:00:00	MSFT	Stock	37.26	37.27	37.26	37.27	300.0
2013-12-27 08:00:00	NVDA	Stock	0.39	0.39	0.39	0.39	8000.0
2013-12-27 09:00:00	NVDA	Stock	0.3935	0.3948	0.392	0.3921	21118200.0
2013-12-27 10:00:00	NVDA	Stock	0.392	0.3935	0.3915	0.3922	28187160.0
2013-12-27 11:00:00	NVDA	Stock	0.392	0.3928	0.392	0.3921	18226360.0
2013-12-27 12:00:00	NVDA	Stock	0.3922	0.3922	0.392	0.3921	13139120.0
2013-12-27 13:00:00	NVDA	Stock	0.3921	0.3935	0.392	0.3928	23776040.0
2013-12-27 14:00:00	NVDA	Stock	0.3928	0.3933	0.3928	0.393	24005520.0
2013-12-27 15:00:00	NVDA	Stock	0.3929	0.394	0.3929	0.394	47347320.0
2013-12-27 16:00:00	NVDA	Stock	0.394	0.3945	0.3939	0.3939	30281880.0
2013-12-27 05:00:00	AMZN	Stock	20.24	20.24	20.24	20.24	3920.0
2013-12-27 07:00:00	AMZN	Stock	20.3	20.3	20.3	20.3	2000.0
2013-12-27 08:00:00	AMZN	Stock	20.256	20.266	20.23	20.25	29100.0
2013-12-27 09:00:00	AMZN	Stock	20.24	20.2815	20.027	20.112	6824060.0
2013-12-27 10:00:00	AMZN	Stock	20.0965	20.156	20.015	20.0355	4682900.0
2013-12-27 11:00:00	AMZN	Stock	20.03	20.0683	19.9875	20.013	4475760.0
2013-12-27 12:00:00	AMZN	Stock	20.009	20.016	19.9405	19.9405	3580540.0
2013-12-27 13:00:00	AMZN	Stock	19.9435	19.9545	19.91	19.9455	2860760.0
2013-12-27 14:00:00	AMZN	Stock	19.9455	19.978	19.9385	19.9571	2306560.0
2013-12-27 15:00:00	AMZN	Stock	19.9635	19.9645	19.8125	19.904	10195680.0
2013-12-27 16:00:00	AMZN	Stock	19.904	19.9964	19.8925	19.93	1318560.0
2013-12-27 17:00:00	AMZN	Stock	19.9285	19.9285	19.9285	19.9285	2000.0
2013-12-27 18:00:00	AMZN	Stock	19.9425	19.9425	19.9425	19.9425	3000.0
2013-12-27 04:00:00	META	Stock	57.74	57.96	57.74	57.96	1494.0

> showing 50 of 47,323 rows — these rows as CSV

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