PREVIEW / stock_1hour / 2012-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-25.parquet
  size:    926 KB
  rows:    44,956
  symbols: 3,517

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-06-25 04:00:00	AAPL	Stock	20.7893	20.7893	20.6607	20.6964	30380.0
2012-06-25 05:00:00	AAPL	Stock	20.6611	20.6611	20.6611	20.6611	13440.0
2012-06-25 07:00:00	AAPL	Stock	20.6729	20.6786	20.6518	20.6768	93800.0
2012-06-25 08:00:00	AAPL	Stock	20.6764	20.6764	20.6171	20.6589	1070048.0
2012-06-25 09:00:00	AAPL	Stock	20.6557	20.7071	20.5714	20.6114	35463176.0
2012-06-25 10:00:00	AAPL	Stock	20.6087	20.6339	20.4911	20.5401	53784472.0
2012-06-25 11:00:00	AAPL	Stock	20.5414	20.5486	20.3864	20.4293	45674692.0
2012-06-25 12:00:00	AAPL	Stock	20.4293	20.4579	20.4061	20.4486	32529392.0
2012-06-25 13:00:00	AAPL	Stock	20.45	20.5214	20.3982	20.4743	27892816.0
2012-06-25 14:00:00	AAPL	Stock	20.4736	20.5089	20.3718	20.3868	35660576.0
2012-06-25 15:00:00	AAPL	Stock	20.3868	20.4629	20.3704	20.3839	57457484.0
2012-06-25 16:00:00	AAPL	Stock	20.3845	20.5072	20.3821	20.3829	10742676.0
2012-06-25 17:00:00	AAPL	Stock	20.3929	20.4297	20.3845	20.3929	259252.0
2012-06-25 18:00:00	AAPL	Stock	20.3914	20.3929	20.3839	20.3875	116480.0
2012-06-25 19:00:00	AAPL	Stock	20.3871	20.4018	20.3871	20.3929	232932.0
2012-06-25 06:00:00	MSFT	Stock	30.32	30.32	30.32	30.32	400.0
2012-06-25 07:00:00	MSFT	Stock	30.32	30.43	30.31	30.43	1100.0
2012-06-25 08:00:00	MSFT	Stock	30.39	30.46	30.31	30.4	24283.0
2012-06-25 09:00:00	MSFT	Stock	30.4	30.4	30.035	30.12	4551421.0
2012-06-25 10:00:00	MSFT	Stock	30.125	30.18	29.83	29.886	7490471.0
2012-06-25 11:00:00	MSFT	Stock	29.88	29.935	29.7	29.75	4943764.0
2012-06-25 12:00:00	MSFT	Stock	29.75	29.86	29.73	29.821	2206124.0
2012-06-25 13:00:00	MSFT	Stock	29.82	29.88	29.76	29.782	2589651.0
2012-06-25 14:00:00	MSFT	Stock	29.789	29.8	29.62	29.69	4881068.0
2012-06-25 15:00:00	MSFT	Stock	29.692	29.89	29.69	29.84	10248623.0
2012-06-25 16:00:00	MSFT	Stock	29.84	30.06	29.642	29.84	4471125.0
2012-06-25 17:00:00	MSFT	Stock	29.85	29.865	29.83	29.84	44369.0
2012-06-25 18:00:00	MSFT	Stock	29.84	29.85	29.83	29.84	3958.0
2012-06-25 19:00:00	MSFT	Stock	29.86	29.87	29.85	29.85	5510.0
2012-06-25 04:00:00	NVDA	Stock	0.3248	0.3248	0.3248	0.3248	16000.0
2012-06-25 07:00:00	NVDA	Stock	0.3263	0.3263	0.3258	0.326	172000.0
2012-06-25 08:00:00	NVDA	Stock	0.3238	0.327	0.3238	0.3255	257920.0
2012-06-25 09:00:00	NVDA	Stock	0.3255	0.3263	0.32	0.322	63595560.0
2012-06-25 10:00:00	NVDA	Stock	0.3223	0.323	0.3188	0.3204	93114200.0
2012-06-25 11:00:00	NVDA	Stock	0.3205	0.3205	0.315	0.3153	55212640.0
2012-06-25 12:00:00	NVDA	Stock	0.315	0.3178	0.315	0.3153	37854880.0
2012-06-25 13:00:00	NVDA	Stock	0.3153	0.3163	0.3143	0.3158	36517040.0
2012-06-25 14:00:00	NVDA	Stock	0.3156	0.3163	0.3138	0.314	44697200.0
2012-06-25 15:00:00	NVDA	Stock	0.314	0.3173	0.3135	0.315	123936400.0
2012-06-25 16:00:00	NVDA	Stock	0.3148	0.325	0.314	0.3148	7733920.0
2012-06-25 17:00:00	NVDA	Stock	0.3148	0.315	0.3148	0.315	450240.0
2012-06-25 18:00:00	NVDA	Stock	0.315	0.315	0.315	0.315	225680.0
2012-06-25 19:00:00	NVDA	Stock	0.315	0.3165	0.315	0.3165	227200.0
2012-06-25 08:00:00	AMZN	Stock	11.047	11.085	11.0025	11.0025	107000.0
2012-06-25 09:00:00	AMZN	Stock	11.0235	11.0795	10.976	11.0315	6840960.0
2012-06-25 10:00:00	AMZN	Stock	11.0295	11.05	10.9311	10.9475	8465320.0
2012-06-25 11:00:00	AMZN	Stock	10.9483	10.9534	10.9025	10.9025	5614560.0
2012-06-25 12:00:00	AMZN	Stock	10.9025	10.9565	10.9	10.94	5188420.0
2012-06-25 13:00:00	AMZN	Stock	10.936	10.965	10.909	10.9469	3231260.0
2012-06-25 14:00:00	AMZN	Stock	10.9465	10.9779	10.945	10.962	3097140.0

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

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