PREVIEW / stock_1hour / 2008-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-12.parquet
  size:    837 KB
  rows:    40,389
  symbols: 3,287

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
2008-05-12 06:00:00	AAPL	Stock	6.5611	6.5611	6.5611	6.5611	2800.0
2008-05-12 07:00:00	AAPL	Stock	6.5821	6.595	6.5679	6.5793	270480.0
2008-05-12 08:00:00	AAPL	Stock	6.5782	6.6214	6.565	6.6139	5416852.0
2008-05-12 09:00:00	AAPL	Stock	6.6139	6.6318	6.5679	6.5932	88499824.0
2008-05-12 10:00:00	AAPL	Stock	6.5929	6.6286	6.5304	6.6175	132077932.0
2008-05-12 11:00:00	AAPL	Stock	6.6179	6.6746	6.6018	6.6696	105107156.0
2008-05-12 12:00:00	AAPL	Stock	6.6696	6.7064	6.6639	6.6979	112435120.0
2008-05-12 13:00:00	AAPL	Stock	6.6975	6.7071	6.6679	6.6932	101206616.0
2008-05-12 14:00:00	AAPL	Stock	6.6936	6.7454	6.6929	6.7371	121566536.0
2008-05-12 15:00:00	AAPL	Stock	6.7361	6.7446	6.7014	6.7125	128578352.0
2008-05-12 16:00:00	AAPL	Stock	6.7125	6.7204	6.6636	6.7146	13487124.0
2008-05-12 17:00:00	AAPL	Stock	6.7143	6.7214	6.6429	6.7196	353360.0
2008-05-12 18:00:00	AAPL	Stock	6.7196	6.7246	6.7179	6.7182	404292.0
2008-05-12 19:00:00	AAPL	Stock	6.7196	6.7304	6.7179	6.7304	333396.0
2008-05-12 08:00:00	MSFT	Stock	29.39	29.47	29.3	29.46	9282.0
2008-05-12 09:00:00	MSFT	Stock	29.45	29.57	29.17	29.55	5482880.0
2008-05-12 10:00:00	MSFT	Stock	29.54	29.91	29.52	29.91	11184992.0
2008-05-12 11:00:00	MSFT	Stock	29.91	29.97	29.8	29.915	7318757.0
2008-05-12 12:00:00	MSFT	Stock	29.91	29.95	29.85	29.9	4353397.0
2008-05-12 13:00:00	MSFT	Stock	29.9	29.91	29.75	29.77	4820851.0
2008-05-12 14:00:00	MSFT	Stock	29.78	30.0	29.77	29.93	8451391.0
2008-05-12 15:00:00	MSFT	Stock	29.93	30.06	29.87	29.98	20101221.0
2008-05-12 16:00:00	MSFT	Stock	29.99	30.05	29.852	29.99	2148570.0
2008-05-12 17:00:00	MSFT	Stock	29.96	29.99	29.3	29.94	96851.0
2008-05-12 18:00:00	MSFT	Stock	29.96	29.96	29.94	29.96	1100.0
2008-05-12 19:00:00	MSFT	Stock	29.95	29.98	29.92	29.92	5879.0
2008-05-12 08:00:00	NVDA	Stock	0.5735	0.5748	0.5688	0.5738	253240.0
2008-05-12 09:00:00	NVDA	Stock	0.5718	0.573	0.5562	0.562	88607000.0
2008-05-12 10:00:00	NVDA	Stock	0.562	0.5622	0.5525	0.555	160762840.0
2008-05-12 11:00:00	NVDA	Stock	0.555	0.5558	0.5512	0.555	98053440.0
2008-05-12 12:00:00	NVDA	Stock	0.5548	0.5562	0.55	0.552	116513480.0
2008-05-12 13:00:00	NVDA	Stock	0.552	0.5521	0.5442	0.5452	107025480.0
2008-05-12 14:00:00	NVDA	Stock	0.5452	0.548	0.543	0.5452	119534480.0
2008-05-12 15:00:00	NVDA	Stock	0.5455	0.5472	0.5418	0.5472	232698600.0
2008-05-12 16:00:00	NVDA	Stock	0.5472	0.5508	0.545	0.5468	50359320.0
2008-05-12 17:00:00	NVDA	Stock	0.5465	0.5532	0.5465	0.5468	7224000.0
2008-05-12 18:00:00	NVDA	Stock	0.5468	0.548	0.5465	0.548	251600.0
2008-05-12 19:00:00	NVDA	Stock	0.548	0.548	0.548	0.548	7000.0
2008-05-12 06:00:00	AMZN	Stock	3.625	3.625	3.625	3.625	7000.0
2008-05-12 07:00:00	AMZN	Stock	3.625	3.625	3.625	3.625	2000.0
2008-05-12 08:00:00	AMZN	Stock	3.65	3.6575	3.65	3.65	178300.0
2008-05-12 09:00:00	AMZN	Stock	3.654	3.66	3.589	3.6055	16113700.0
2008-05-12 10:00:00	AMZN	Stock	3.605	3.719	3.6015	3.697	34519140.0
2008-05-12 11:00:00	AMZN	Stock	3.696	3.708	3.6805	3.6975	12350660.0
2008-05-12 12:00:00	AMZN	Stock	3.697	3.725	3.6955	3.7085	12364920.0
2008-05-12 13:00:00	AMZN	Stock	3.7075	3.714	3.685	3.7	11518580.0
2008-05-12 14:00:00	AMZN	Stock	3.7	3.744	3.6985	3.7325	19370760.0
2008-05-12 15:00:00	AMZN	Stock	3.733	3.7465	3.7105	3.7295	34615320.0
2008-05-12 16:00:00	AMZN	Stock	3.727	3.7275	3.6944	3.7265	2880840.0
2008-05-12 19:00:00	AMZN	Stock	3.7275	3.7275	3.7275	3.7275	2000.0

> showing 50 of 40,389 rows — these rows as CSV

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