PREVIEW / stock_1hour / 2009-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-09.parquet
  size:    906 KB
  rows:    43,231
  symbols: 3,416

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
2009-11-09 04:00:00	AAPL	Stock	6.9582	6.9675	6.9582	6.9614	11200.0
2009-11-09 05:00:00	AAPL	Stock	7.0139	7.0139	7.0139	7.0139	2800.0
2009-11-09 07:00:00	AAPL	Stock	7.0071	7.0361	6.9989	7.0357	318556.0
2009-11-09 08:00:00	AAPL	Stock	7.0268	7.0479	7.0179	7.0386	2211440.0
2009-11-09 09:00:00	AAPL	Stock	7.0386	7.0893	7.0093	7.0675	79889936.0
2009-11-09 10:00:00	AAPL	Stock	7.0671	7.1304	7.0671	7.1179	91633248.0
2009-11-09 11:00:00	AAPL	Stock	7.1186	7.1411	7.105	7.1364	46495736.0
2009-11-09 12:00:00	AAPL	Stock	7.1364	7.1407	7.1222	7.1407	29442672.0
2009-11-09 13:00:00	AAPL	Stock	7.1407	7.17	7.1321	7.1621	60000668.0
2009-11-09 14:00:00	AAPL	Stock	7.1616	7.1864	7.1457	7.1782	62645212.0
2009-11-09 15:00:00	AAPL	Stock	7.1786	7.2107	7.165	7.1964	82366424.0
2009-11-09 16:00:00	AAPL	Stock	7.1961	7.2143	7.1274	7.1893	10862740.0
2009-11-09 17:00:00	AAPL	Stock	7.1929	7.1964	7.1914	7.1929	196700.0
2009-11-09 18:00:00	AAPL	Stock	7.1929	7.2075	7.1929	7.2057	2058560.0
2009-11-09 19:00:00	AAPL	Stock	7.2057	7.2121	7.1893	7.1964	572292.0
2009-11-09 06:00:00	MSFT	Stock	28.68	28.68	28.68	28.68	100.0
2009-11-09 07:00:00	MSFT	Stock	28.68	28.79	28.68	28.79	2600.0
2009-11-09 08:00:00	MSFT	Stock	28.76	28.84	28.466	28.65	43850.0
2009-11-09 09:00:00	MSFT	Stock	28.63	28.74	28.53	28.6	5853751.0
2009-11-09 10:00:00	MSFT	Stock	28.6	28.73	28.58	28.71	7358071.0
2009-11-09 11:00:00	MSFT	Stock	28.71	28.78	28.64	28.69	6060513.0
2009-11-09 12:00:00	MSFT	Stock	28.698	28.77	28.67	28.77	5706807.0
2009-11-09 13:00:00	MSFT	Stock	28.77	28.89	28.75	28.86	6188091.0
2009-11-09 14:00:00	MSFT	Stock	28.86	29.0	28.85	28.99	6469699.0
2009-11-09 15:00:00	MSFT	Stock	28.992	29.0	28.95	28.99	11490440.0
2009-11-09 16:00:00	MSFT	Stock	29.0	29.0	28.561	29.0	6082916.0
2009-11-09 17:00:00	MSFT	Stock	28.97	28.99	28.97	28.99	99674.0
2009-11-09 18:00:00	MSFT	Stock	29.0	29.0	28.96	28.96	31512.0
2009-11-09 19:00:00	MSFT	Stock	29.0	29.0	28.96	28.97	2517.0
2009-11-09 07:00:00	NVDA	Stock	0.3375	0.3375	0.3375	0.3375	40000.0
2009-11-09 08:00:00	NVDA	Stock	0.334	0.3358	0.3335	0.3342	1113200.0
2009-11-09 09:00:00	NVDA	Stock	0.334	0.3395	0.333	0.3389	108752680.0
2009-11-09 10:00:00	NVDA	Stock	0.3388	0.3395	0.3345	0.3368	141958760.0
2009-11-09 11:00:00	NVDA	Stock	0.3368	0.3385	0.3353	0.3382	65853680.0
2009-11-09 12:00:00	NVDA	Stock	0.3381	0.34	0.3378	0.3382	84366760.0
2009-11-09 13:00:00	NVDA	Stock	0.338	0.3393	0.3362	0.3375	83665840.0
2009-11-09 14:00:00	NVDA	Stock	0.3375	0.3413	0.337	0.3402	87014120.0
2009-11-09 15:00:00	NVDA	Stock	0.3402	0.3405	0.336	0.3368	207783800.0
2009-11-09 16:00:00	NVDA	Stock	0.3368	0.3376	0.3362	0.3362	16810120.0
2009-11-09 17:00:00	NVDA	Stock	0.3353	0.3375	0.335	0.3375	331440.0
2009-11-09 18:00:00	NVDA	Stock	0.3375	0.3375	0.3375	0.3375	40000.0
2009-11-09 19:00:00	NVDA	Stock	0.3375	0.3382	0.3375	0.3375	157800.0
2009-11-09 04:00:00	AMZN	Stock	6.3995	6.3995	6.3995	6.3995	2000.0
2009-11-09 05:00:00	AMZN	Stock	6.4005	6.4005	6.3995	6.3995	8000.0
2009-11-09 07:00:00	AMZN	Stock	6.4	6.4	6.35	6.3725	108080.0
2009-11-09 08:00:00	AMZN	Stock	6.369	6.3863	6.335	6.3685	923980.0
2009-11-09 09:00:00	AMZN	Stock	6.364	6.378	6.2796	6.367	27393880.0
2009-11-09 10:00:00	AMZN	Stock	6.367	6.416	6.365	6.4	34049040.0
2009-11-09 11:00:00	AMZN	Stock	6.4015	6.4125	6.3805	6.384	18410500.0
2009-11-09 12:00:00	AMZN	Stock	6.3845	6.3845	6.3405	6.3495	16550720.0

> showing 50 of 43,231 rows — these rows as CSV

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