PREVIEW / stock_1hour / 2010-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-01.parquet
  size:    928 KB
  rows:    44,886
  symbols: 3,516

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-11-01 05:00:00	AAPL	Stock	10.8471	10.8571	10.8425	10.8425	25480.0
2010-11-01 06:00:00	AAPL	Stock	10.8207	10.8304	10.8207	10.8304	5600.0
2010-11-01 07:00:00	AAPL	Stock	10.8179	10.8304	10.8029	10.8029	369292.0
2010-11-01 08:00:00	AAPL	Stock	10.8039	10.8179	10.7454	10.785	2015384.0
2010-11-01 09:00:00	AAPL	Stock	10.7846	10.9107	10.7493	10.8886	92370796.0
2010-11-01 10:00:00	AAPL	Stock	10.8892	10.9143	10.8607	10.87	78810620.0
2010-11-01 11:00:00	AAPL	Stock	10.8679	10.875	10.7975	10.8546	83019692.0
2010-11-01 12:00:00	AAPL	Stock	10.855	10.8704	10.8393	10.85	32963140.0
2010-11-01 13:00:00	AAPL	Stock	10.8502	10.8661	10.8393	10.8536	26959128.0
2010-11-01 14:00:00	AAPL	Stock	10.8531	10.8668	10.8286	10.8491	33603556.0
2010-11-01 15:00:00	AAPL	Stock	10.8486	10.8643	10.8036	10.8636	63008960.0
2010-11-01 16:00:00	AAPL	Stock	10.8639	10.8704	10.7454	10.8621	7575288.0
2010-11-01 17:00:00	AAPL	Stock	10.8621	10.8636	10.8486	10.8546	674716.0
2010-11-01 18:00:00	AAPL	Stock	10.8536	10.8636	10.8375	10.8375	693224.0
2010-11-01 19:00:00	AAPL	Stock	10.8357	10.8511	10.8329	10.8464	945504.0
2010-11-01 07:00:00	MSFT	Stock	26.85	26.92	26.85	26.88	7200.0
2010-11-01 08:00:00	MSFT	Stock	26.85	26.88	26.65	26.76	114603.0
2010-11-01 09:00:00	MSFT	Stock	26.77	27.1	26.64	27.05	8168897.0
2010-11-01 10:00:00	MSFT	Stock	27.06	27.22	27.05	27.102	11970543.0
2010-11-01 11:00:00	MSFT	Stock	27.105	27.11	26.94	27.018	7303936.0
2010-11-01 12:00:00	MSFT	Stock	27.015	27.09	26.99	27.021	5433387.0
2010-11-01 13:00:00	MSFT	Stock	27.02	27.06	26.95	26.99	4746141.0
2010-11-01 14:00:00	MSFT	Stock	26.99	27.03	26.89	26.92	6354697.0
2010-11-01 15:00:00	MSFT	Stock	26.92	26.96	26.7	26.96	12826511.0
2010-11-01 16:00:00	MSFT	Stock	26.95	27.19	26.64	26.92	3156990.0
2010-11-01 17:00:00	MSFT	Stock	26.94	26.98	26.94	26.95	7750.0
2010-11-01 18:00:00	MSFT	Stock	26.95	26.95	26.94	26.95	835.0
2010-11-01 19:00:00	MSFT	Stock	26.92	26.97	26.92	26.97	3335.0
2010-11-01 08:00:00	NVDA	Stock	0.3012	0.3012	0.298	0.3008	48000.0
2010-11-01 09:00:00	NVDA	Stock	0.3005	0.305	0.3	0.3042	54153160.0
2010-11-01 10:00:00	NVDA	Stock	0.3045	0.3073	0.3028	0.3033	81416400.0
2010-11-01 11:00:00	NVDA	Stock	0.3032	0.3034	0.2985	0.3018	79168400.0
2010-11-01 12:00:00	NVDA	Stock	0.3018	0.302	0.3002	0.3005	30574840.0
2010-11-01 13:00:00	NVDA	Stock	0.3005	0.3025	0.299	0.3018	65190960.0
2010-11-01 14:00:00	NVDA	Stock	0.3018	0.3022	0.3005	0.3015	69109400.0
2010-11-01 15:00:00	NVDA	Stock	0.3012	0.3015	0.2995	0.3008	81836480.0
2010-11-01 16:00:00	NVDA	Stock	0.3008	0.3032	0.3008	0.3008	8644840.0
2010-11-01 17:00:00	NVDA	Stock	0.301	0.301	0.3005	0.3005	52800.0
2010-11-01 19:00:00	NVDA	Stock	0.3005	0.3005	0.3005	0.3005	11200.0
2010-11-01 04:00:00	AMZN	Stock	8.262	8.31	8.262	8.31	4000.0
2010-11-01 05:00:00	AMZN	Stock	8.265	8.265	8.265	8.265	22000.0
2010-11-01 06:00:00	AMZN	Stock	8.275	8.275	8.275	8.275	2000.0
2010-11-01 07:00:00	AMZN	Stock	8.2495	8.265	8.24	8.245	100500.0
2010-11-01 08:00:00	AMZN	Stock	8.2455	8.2455	8.186	8.2	338800.0
2010-11-01 09:00:00	AMZN	Stock	8.2	8.2375	8.158	8.1735	12764500.0
2010-11-01 10:00:00	AMZN	Stock	8.1745	8.2125	8.1295	8.14	24222980.0
2010-11-01 11:00:00	AMZN	Stock	8.139	8.146	8.076	8.1445	15322320.0
2010-11-01 12:00:00	AMZN	Stock	8.144	8.1575	8.11	8.1235	8676580.0
2010-11-01 13:00:00	AMZN	Stock	8.125	8.1675	8.108	8.1435	7807400.0
2010-11-01 14:00:00	AMZN	Stock	8.1465	8.1565	8.11	8.141	9060520.0

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

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