PREVIEW / stock_1hour / 2011-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-01.parquet
  size:    961 KB
  rows:    45,282
  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
2011-08-01 04:00:00	AAPL	Stock	14.195	14.2143	14.1639	14.1961	89600.0
2011-08-01 05:00:00	AAPL	Stock	14.1961	14.2232	14.1907	14.1907	184800.0
2011-08-01 06:00:00	AAPL	Stock	14.2	14.2071	14.1821	14.1893	282212.0
2011-08-01 07:00:00	AAPL	Stock	14.2007	14.25	14.1429	14.1439	1452724.0
2011-08-01 08:00:00	AAPL	Stock	14.1596	14.2143	14.1339	14.1607	7423808.0
2011-08-01 09:00:00	AAPL	Stock	14.1632	14.2679	14.1432	14.1496	121225916.0
2011-08-01 10:00:00	AAPL	Stock	14.1489	14.1575	14.0275	14.1136	130904844.0
2011-08-01 11:00:00	AAPL	Stock	14.1132	14.1368	14.0505	14.0618	84433384.0
2011-08-01 12:00:00	AAPL	Stock	14.0618	14.1139	14.0132	14.1024	62610072.0
2011-08-01 13:00:00	AAPL	Stock	14.1012	14.1136	14.0725	14.0991	27343904.0
2011-08-01 14:00:00	AAPL	Stock	14.1004	14.1107	14.0357	14.1046	48846672.0
2011-08-01 15:00:00	AAPL	Stock	14.1043	14.1714	14.0893	14.1693	110962628.0
2011-08-01 16:00:00	AAPL	Stock	14.1586	14.1936	14.0947	14.1893	10579912.0
2011-08-01 17:00:00	AAPL	Stock	14.1896	14.2011	14.1689	14.1857	1170092.0
2011-08-01 18:00:00	AAPL	Stock	14.1886	14.2021	14.1696	14.1964	583240.0
2011-08-01 19:00:00	AAPL	Stock	14.1964	14.2136	14.1886	14.2071	1246056.0
2011-08-01 04:00:00	MSFT	Stock	27.62	27.74	27.62	27.74	300.0
2011-08-01 05:00:00	MSFT	Stock	27.81	27.81	27.81	27.81	100.0
2011-08-01 06:00:00	MSFT	Stock	27.81	27.92	27.81	27.92	4925.0
2011-08-01 07:00:00	MSFT	Stock	27.91	27.92	27.8	27.83	45298.0
2011-08-01 08:00:00	MSFT	Stock	27.85	27.85	27.51	27.55	121617.0
2011-08-01 09:00:00	MSFT	Stock	27.56	27.685	27.41	27.416	7438625.0
2011-08-01 10:00:00	MSFT	Stock	27.41	27.415	26.98	27.07	12723459.0
2011-08-01 11:00:00	MSFT	Stock	27.07	27.14	26.88	26.91	7590519.0
2011-08-01 12:00:00	MSFT	Stock	26.91	26.945	26.75	26.87	7149157.0
2011-08-01 13:00:00	MSFT	Stock	26.861	27.06	26.84	27.05	4374395.0
2011-08-01 14:00:00	MSFT	Stock	27.055	27.18	26.97	27.145	4914131.0
2011-08-01 15:00:00	MSFT	Stock	27.145	27.33	27.09	27.28	12952486.0
2011-08-01 16:00:00	MSFT	Stock	27.27	27.302	26.903	27.19	2842909.0
2011-08-01 17:00:00	MSFT	Stock	27.18	27.19	27.18	27.19	9349.0
2011-08-01 18:00:00	MSFT	Stock	26.79	27.28	26.79	27.26	38697.0
2011-08-01 19:00:00	MSFT	Stock	27.25	27.32	27.25	27.3	7185.0
2011-08-01 07:00:00	NVDA	Stock	0.3572	0.3575	0.3572	0.3575	52000.0
2011-08-01 08:00:00	NVDA	Stock	0.3522	0.3545	0.3522	0.3525	806400.0
2011-08-01 09:00:00	NVDA	Stock	0.3528	0.3618	0.3528	0.3592	122596560.0
2011-08-01 10:00:00	NVDA	Stock	0.359	0.361	0.3508	0.3588	189791840.0
2011-08-01 11:00:00	NVDA	Stock	0.3588	0.3588	0.3542	0.3562	109544960.0
2011-08-01 12:00:00	NVDA	Stock	0.3562	0.3578	0.3525	0.3566	99979600.0
2011-08-01 13:00:00	NVDA	Stock	0.3565	0.3572	0.356	0.3565	47640000.0
2011-08-01 14:00:00	NVDA	Stock	0.3565	0.3579	0.355	0.3575	100595200.0
2011-08-01 15:00:00	NVDA	Stock	0.3575	0.3652	0.3572	0.3642	327806840.0
2011-08-01 16:00:00	NVDA	Stock	0.3642	0.3662	0.3441	0.3662	15014760.0
2011-08-01 17:00:00	NVDA	Stock	0.3652	0.367	0.3638	0.365	168880.0
2011-08-01 18:00:00	NVDA	Stock	0.367	0.3695	0.3658	0.3688	265200.0
2011-08-01 19:00:00	NVDA	Stock	0.3688	0.3698	0.3688	0.3695	170000.0
2011-08-01 04:00:00	AMZN	Stock	11.18	11.25	11.18	11.25	12000.0
2011-08-01 05:00:00	AMZN	Stock	11.274	11.274	11.257	11.2625	6000.0
2011-08-01 06:00:00	AMZN	Stock	11.275	11.287	11.275	11.287	22000.0
2011-08-01 07:00:00	AMZN	Stock	11.325	11.375	11.285	11.306	96540.0
2011-08-01 08:00:00	AMZN	Stock	11.2945	11.333	11.258	11.2585	372460.0

> showing 50 of 45,282 rows — these rows as CSV

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