PREVIEW / stock_1hour / 2010-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-03.parquet
  size:    875 KB
  rows:    42,337
  symbols: 3,423

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-02-03 04:00:00	AAPL	Stock	7.0011	7.0011	7.0011	7.0011	5600.0
2010-02-03 05:00:00	AAPL	Stock	6.9857	6.9857	6.9857	6.9857	2800.0
2010-02-03 06:00:00	AAPL	Stock	6.9946	6.9946	6.9946	6.9946	2800.0
2010-02-03 07:00:00	AAPL	Stock	6.9946	6.9946	6.9789	6.9857	34188.0
2010-02-03 08:00:00	AAPL	Stock	6.9821	6.9821	6.9507	6.9571	1670648.0
2010-02-03 09:00:00	AAPL	Stock	6.9575	7.0829	6.9436	7.0596	99969184.0
2010-02-03 10:00:00	AAPL	Stock	7.0596	7.0893	7.0225	7.0611	114624552.0
2010-02-03 11:00:00	AAPL	Stock	7.063	7.125	7.0571	7.0836	100382352.0
2010-02-03 12:00:00	AAPL	Stock	7.0836	7.1389	7.08	7.1125	64734768.0
2010-02-03 13:00:00	AAPL	Stock	7.1135	7.15	7.1107	7.1354	61701528.0
2010-02-03 14:00:00	AAPL	Stock	7.1339	7.1368	7.1068	7.1318	59847172.0
2010-02-03 15:00:00	AAPL	Stock	7.1299	7.145	7.1107	7.115	94186512.0
2010-02-03 16:00:00	AAPL	Stock	7.1154	7.1304	7.0639	7.1264	8387204.0
2010-02-03 17:00:00	AAPL	Stock	7.1286	7.1411	7.1264	7.1371	761796.0
2010-02-03 18:00:00	AAPL	Stock	7.1404	7.1429	7.115	7.1429	571088.0
2010-02-03 19:00:00	AAPL	Stock	7.1429	7.1464	7.1393	7.1429	374752.0
2010-02-03 06:00:00	MSFT	Stock	28.49	28.49	28.49	28.49	200.0
2010-02-03 07:00:00	MSFT	Stock	28.43	28.45	28.43	28.45	1300.0
2010-02-03 08:00:00	MSFT	Stock	28.48	28.48	28.36	28.4	52319.0
2010-02-03 09:00:00	MSFT	Stock	28.4	28.49	28.2	28.32	5119373.0
2010-02-03 10:00:00	MSFT	Stock	28.31	28.31	28.12	28.2	8368811.0
2010-02-03 11:00:00	MSFT	Stock	28.2	28.4	28.16	28.35	8822244.0
2010-02-03 12:00:00	MSFT	Stock	28.35	28.63	28.34	28.59	8247757.0
2010-02-03 13:00:00	MSFT	Stock	28.59	28.71	28.52	28.69	8364451.0
2010-02-03 14:00:00	MSFT	Stock	28.7	28.73	28.63	28.69	5547568.0
2010-02-03 15:00:00	MSFT	Stock	28.69	28.79	28.6	28.63	14737792.0
2010-02-03 16:00:00	MSFT	Stock	28.63	28.82	28.48	28.82	1301582.0
2010-02-03 17:00:00	MSFT	Stock	28.82	28.83	28.75	28.8	88720.0
2010-02-03 18:00:00	MSFT	Stock	28.8	28.82	28.76	28.82	15500.0
2010-02-03 19:00:00	MSFT	Stock	28.82	28.82	28.76	28.82	8147.0
2010-02-03 08:00:00	NVDA	Stock	0.4175	0.4175	0.4175	0.4175	16800.0
2010-02-03 09:00:00	NVDA	Stock	0.415	0.4228	0.4128	0.4225	57204840.0
2010-02-03 10:00:00	NVDA	Stock	0.4225	0.4238	0.415	0.4205	120912920.0
2010-02-03 11:00:00	NVDA	Stock	0.4205	0.4213	0.4175	0.4188	79952760.0
2010-02-03 12:00:00	NVDA	Stock	0.4188	0.422	0.417	0.4181	56620800.0
2010-02-03 13:00:00	NVDA	Stock	0.418	0.4202	0.4175	0.4182	44438120.0
2010-02-03 14:00:00	NVDA	Stock	0.4182	0.4202	0.4165	0.4188	57568520.0
2010-02-03 15:00:00	NVDA	Stock	0.4188	0.4228	0.4188	0.422	129432560.0
2010-02-03 16:00:00	NVDA	Stock	0.422	0.4235	0.4173	0.4235	9628680.0
2010-02-03 17:00:00	NVDA	Stock	0.4235	0.4238	0.4235	0.4238	50520.0
2010-02-03 18:00:00	NVDA	Stock	0.422	0.422	0.422	0.422	788840.0
2010-02-03 19:00:00	NVDA	Stock	0.424	0.424	0.424	0.424	4000.0
2010-02-03 08:00:00	AMZN	Stock	5.905	5.905	5.84	5.84	394500.0
2010-02-03 09:00:00	AMZN	Stock	5.846	5.925	5.828	5.89	42937960.0
2010-02-03 10:00:00	AMZN	Stock	5.89	5.8965	5.829	5.8912	50803920.0
2010-02-03 11:00:00	AMZN	Stock	5.891	5.972	5.868	5.9185	45885940.0
2010-02-03 12:00:00	AMZN	Stock	5.919	5.9595	5.907	5.9405	19386500.0
2010-02-03 13:00:00	AMZN	Stock	5.9398	5.978	5.918	5.9305	25873020.0
2010-02-03 14:00:00	AMZN	Stock	5.9305	5.968	5.9105	5.96	20633660.0
2010-02-03 15:00:00	AMZN	Stock	5.961	5.9805	5.9345	5.9575	36547480.0

> showing 50 of 42,337 rows — these rows as CSV

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