PREVIEW / stock_1hour / 2010-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-30.parquet
  size:    927 KB
  rows:    44,764
  symbols: 3,495

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
2010-09-30 04:00:00	AAPL	Stock	10.2607	10.2607	10.2607	10.2607	2800.0
2010-09-30 07:00:00	AAPL	Stock	10.2611	10.2611	10.2589	10.2589	9856.0
2010-09-30 08:00:00	AAPL	Stock	10.2586	10.3282	10.2475	10.3071	3527048.0
2010-09-30 09:00:00	AAPL	Stock	10.3125	10.3571	10.2786	10.3146	90926248.0
2010-09-30 10:00:00	AAPL	Stock	10.3136	10.3196	10.2246	10.225	96985224.0
2010-09-30 11:00:00	AAPL	Stock	10.2243	10.2245	10.0446	10.1514	182510972.0
2010-09-30 12:00:00	AAPL	Stock	10.1518	10.1857	10.1	10.1661	60742024.0
2010-09-30 13:00:00	AAPL	Stock	10.1667	10.1804	10.1396	10.1579	42231616.0
2010-09-30 14:00:00	AAPL	Stock	10.157	10.2304	10.1164	10.2025	61838196.0
2010-09-30 15:00:00	AAPL	Stock	10.2025	10.2175	10.1339	10.1339	102405604.0
2010-09-30 16:00:00	AAPL	Stock	10.1339	10.3132	10.1329	10.145	24522820.0
2010-09-30 17:00:00	AAPL	Stock	10.1468	10.1568	10.1334	10.1421	318080.0
2010-09-30 18:00:00	AAPL	Stock	10.1429	10.1482	10.1339	10.1386	183456.0
2010-09-30 19:00:00	AAPL	Stock	10.1386	10.1593	10.1379	10.1536	351876.0
2010-09-30 07:00:00	MSFT	Stock	24.52	24.52	24.5	24.5	2490.0
2010-09-30 08:00:00	MSFT	Stock	24.54	24.62	24.5	24.62	39458.0
2010-09-30 09:00:00	MSFT	Stock	24.61	24.83	24.57	24.825	8151214.0
2010-09-30 10:00:00	MSFT	Stock	24.83	24.83	24.63	24.63	11393664.0
2010-09-30 11:00:00	MSFT	Stock	24.63	24.66	24.4	24.432	8681211.0
2010-09-30 12:00:00	MSFT	Stock	24.435	24.55	24.36	24.53	5212733.0
2010-09-30 13:00:00	MSFT	Stock	24.53	24.62	24.49	24.6	4310350.0
2010-09-30 14:00:00	MSFT	Stock	24.6	24.695	24.52	24.63	5993654.0
2010-09-30 15:00:00	MSFT	Stock	24.63	24.69	24.47	24.48	9319708.0
2010-09-30 16:00:00	MSFT	Stock	24.48	24.608	24.46	24.47	6760890.0
2010-09-30 17:00:00	MSFT	Stock	24.46	24.48	24.46	24.48	2453.0
2010-09-30 18:00:00	MSFT	Stock	24.49	24.49	24.45	24.45	45595.0
2010-09-30 19:00:00	MSFT	Stock	24.45	24.5	24.45	24.5	4708.0
2010-09-30 08:00:00	NVDA	Stock	0.2925	0.2995	0.2925	0.2995	339880.0
2010-09-30 09:00:00	NVDA	Stock	0.2995	0.3042	0.2978	0.3018	91841400.0
2010-09-30 10:00:00	NVDA	Stock	0.3018	0.302	0.2978	0.2978	125524840.0
2010-09-30 11:00:00	NVDA	Stock	0.2978	0.298	0.2918	0.2929	154243160.0
2010-09-30 12:00:00	NVDA	Stock	0.2928	0.2938	0.2895	0.293	115820520.0
2010-09-30 13:00:00	NVDA	Stock	0.2928	0.2942	0.2915	0.294	53268280.0
2010-09-30 14:00:00	NVDA	Stock	0.294	0.2948	0.2915	0.294	75526920.0
2010-09-30 15:00:00	NVDA	Stock	0.294	0.2945	0.2918	0.2922	129477440.0
2010-09-30 16:00:00	NVDA	Stock	0.2922	0.297	0.2916	0.297	33464680.0
2010-09-30 17:00:00	NVDA	Stock	0.2925	0.2925	0.2912	0.2912	92000.0
2010-09-30 18:00:00	NVDA	Stock	0.2918	0.2918	0.2918	0.2918	4000.0
2010-09-30 19:00:00	NVDA	Stock	0.2912	0.2918	0.2912	0.2912	60000.0
2010-09-30 07:00:00	AMZN	Stock	7.95	7.95	7.95	7.95	2000.0
2010-09-30 08:00:00	AMZN	Stock	7.9365	8.035	7.9095	7.963	254500.0
2010-09-30 09:00:00	AMZN	Stock	7.9785	8.0465	7.927	7.9745	22044240.0
2010-09-30 10:00:00	AMZN	Stock	7.9715	7.9805	7.8801	7.8825	26528840.0
2010-09-30 11:00:00	AMZN	Stock	7.88	7.896	7.78	7.8488	29404920.0
2010-09-30 12:00:00	AMZN	Stock	7.8475	7.8775	7.8125	7.866	11352080.0
2010-09-30 13:00:00	AMZN	Stock	7.8665	7.9125	7.8525	7.8735	11338140.0
2010-09-30 14:00:00	AMZN	Stock	7.874	7.9325	7.844	7.9092	14425780.0
2010-09-30 15:00:00	AMZN	Stock	7.9085	7.914	7.8455	7.8525	26678580.0
2010-09-30 16:00:00	AMZN	Stock	7.8485	7.9816	7.8415	7.8876	2079560.0
2010-09-30 17:00:00	AMZN	Stock	7.845	7.85	7.8375	7.8375	20260.0

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

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