PREVIEW / stock_1hour / 2012-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-04.parquet
  size:    927 KB
  rows:    44,334
  symbols: 3,520

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-01-04 04:00:00	AAPL	Stock	14.6436	14.6436	14.6436	14.6436	2800.0
2012-01-04 05:00:00	AAPL	Stock	14.6511	14.6511	14.6429	14.6429	16800.0
2012-01-04 06:00:00	AAPL	Stock	14.6429	14.6429	14.6179	14.6214	53200.0
2012-01-04 07:00:00	AAPL	Stock	14.6254	14.6696	14.625	14.6536	256620.0
2012-01-04 08:00:00	AAPL	Stock	14.6696	14.6768	14.5911	14.6429	2015412.0
2012-01-04 09:00:00	AAPL	Stock	14.6429	14.6964	14.6171	14.6732	36088416.0
2012-01-04 10:00:00	AAPL	Stock	14.6689	14.6786	14.6214	14.6736	37445632.0
2012-01-04 11:00:00	AAPL	Stock	14.6737	14.7679	14.6689	14.7536	42106316.0
2012-01-04 12:00:00	AAPL	Stock	14.7529	14.81	14.7489	14.8018	29016708.0
2012-01-04 13:00:00	AAPL	Stock	14.8032	14.8039	14.7518	14.7907	24323908.0
2012-01-04 14:00:00	AAPL	Stock	14.7907	14.7943	14.75	14.7777	20764520.0
2012-01-04 15:00:00	AAPL	Stock	14.7768	14.7975	14.7375	14.7657	55291544.0
2012-01-04 16:00:00	AAPL	Stock	14.7674	14.7911	14.7238	14.77	7958384.0
2012-01-04 17:00:00	AAPL	Stock	14.7746	14.7864	14.7657	14.7864	1114848.0
2012-01-04 18:00:00	AAPL	Stock	14.7857	14.7893	14.7657	14.7861	162624.0
2012-01-04 19:00:00	AAPL	Stock	14.7914	14.8036	14.7914	14.8036	186200.0
2012-01-04 05:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	1000.0
2012-01-04 06:00:00	MSFT	Stock	26.73	26.73	26.73	26.73	200.0
2012-01-04 07:00:00	MSFT	Stock	26.75	26.75	26.75	26.75	200.0
2012-01-04 08:00:00	MSFT	Stock	26.8	26.82	26.75	26.82	12155.0
2012-01-04 09:00:00	MSFT	Stock	26.78	27.1	26.78	27.06	11148785.0
2012-01-04 10:00:00	MSFT	Stock	27.069	27.14	26.94	27.07	11885084.0
2012-01-04 11:00:00	MSFT	Stock	27.071	27.25	27.06	27.21	9393505.0
2012-01-04 12:00:00	MSFT	Stock	27.202	27.25	27.15	27.25	5305813.0
2012-01-04 13:00:00	MSFT	Stock	27.245	27.38	27.24	27.37	10160555.0
2012-01-04 14:00:00	MSFT	Stock	27.36	27.47	27.3	27.425	12647289.0
2012-01-04 15:00:00	MSFT	Stock	27.425	27.44	27.34	27.39	13586529.0
2012-01-04 16:00:00	MSFT	Stock	27.39	27.43	26.83	27.4	3305483.0
2012-01-04 17:00:00	MSFT	Stock	27.4	27.4	27.39	27.39	227599.0
2012-01-04 18:00:00	MSFT	Stock	27.36	27.4	27.36	27.39	68281.0
2012-01-04 19:00:00	MSFT	Stock	27.39	27.4	27.39	27.4	1922.0
2012-01-04 08:00:00	NVDA	Stock	0.352	0.352	0.352	0.352	80000.0
2012-01-04 09:00:00	NVDA	Stock	0.3502	0.3531	0.348	0.3528	38122440.0
2012-01-04 10:00:00	NVDA	Stock	0.353	0.3542	0.3493	0.3502	70846400.0
2012-01-04 11:00:00	NVDA	Stock	0.3503	0.3509	0.3488	0.349	33613800.0
2012-01-04 12:00:00	NVDA	Stock	0.3493	0.3515	0.3491	0.3515	24525720.0
2012-01-04 13:00:00	NVDA	Stock	0.3515	0.3522	0.3503	0.3518	24239240.0
2012-01-04 14:00:00	NVDA	Stock	0.3518	0.3548	0.3518	0.3542	55549080.0
2012-01-04 15:00:00	NVDA	Stock	0.3542	0.3565	0.3538	0.3548	91110960.0
2012-01-04 16:00:00	NVDA	Stock	0.355	0.3553	0.3525	0.355	8134720.0
2012-01-04 17:00:00	NVDA	Stock	0.3558	0.3562	0.355	0.3562	924200.0
2012-01-04 07:00:00	AMZN	Stock	8.943	8.943	8.897	8.8995	22000.0
2012-01-04 08:00:00	AMZN	Stock	8.9275	8.946	8.91	8.9375	290760.0
2012-01-04 09:00:00	AMZN	Stock	8.9205	9.025	8.9205	8.94	14147780.0
2012-01-04 10:00:00	AMZN	Stock	8.937	8.942	8.8032	8.8425	15179040.0
2012-01-04 11:00:00	AMZN	Stock	8.842	8.922	8.8405	8.918	10924540.0
2012-01-04 12:00:00	AMZN	Stock	8.9204	8.9805	8.8935	8.9695	10744840.0
2012-01-04 13:00:00	AMZN	Stock	8.971	8.972	8.8725	8.9036	8365660.0
2012-01-04 14:00:00	AMZN	Stock	8.904	8.907	8.8185	8.888	10946380.0
2012-01-04 15:00:00	AMZN	Stock	8.89	8.8905	8.8566	8.875	10242120.0

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

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