PREVIEW / stock_1hour / 2010-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-03.parquet
  size:    907 KB
  rows:    44,461
  symbols: 3,473

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-03 05:00:00	AAPL	Stock	9.0079	9.0079	9.0079	9.0079	2800.0
2010-09-03 07:00:00	AAPL	Stock	8.9754	9.0	8.9554	8.995	191380.0
2010-09-03 08:00:00	AAPL	Stock	8.9929	9.1304	8.9829	9.125	10442124.0
2010-09-03 09:00:00	AAPL	Stock	9.125	9.1929	9.0893	9.1811	107988468.0
2010-09-03 10:00:00	AAPL	Stock	9.1777	9.1857	9.0954	9.1138	95611432.0
2010-09-03 11:00:00	AAPL	Stock	9.1129	9.1757	9.1004	9.1711	49373940.0
2010-09-03 12:00:00	AAPL	Stock	9.1704	9.1946	9.1611	9.19	43898792.0
2010-09-03 13:00:00	AAPL	Stock	9.1893	9.2279	9.1893	9.2225	51802716.0
2010-09-03 14:00:00	AAPL	Stock	9.2221	9.2354	9.1996	9.2031	47706764.0
2010-09-03 15:00:00	AAPL	Stock	9.2036	9.2421	9.1968	9.2418	71809416.0
2010-09-03 16:00:00	AAPL	Stock	9.2414	9.2489	9.0187	9.2393	39266920.0
2010-09-03 17:00:00	AAPL	Stock	9.2375	9.2418	9.2321	9.2339	819644.0
2010-09-03 18:00:00	AAPL	Stock	9.2354	9.2418	9.225	9.2286	458024.0
2010-09-03 19:00:00	AAPL	Stock	9.2268	9.2321	9.2264	9.23	108752.0
2010-09-03 20:00:00	AAPL	Stock	9.1421	9.1421	9.1421	9.1421	16800.0
2010-09-03 06:00:00	MSFT	Stock	23.97	24.04	23.97	24.04	5000.0
2010-09-03 07:00:00	MSFT	Stock	24.06	24.06	23.91	23.91	8100.0
2010-09-03 08:00:00	MSFT	Stock	23.97	24.38	23.9	24.23	148992.0
2010-09-03 09:00:00	MSFT	Stock	24.23	24.45	24.15	24.41	8211621.0
2010-09-03 10:00:00	MSFT	Stock	24.4	24.4	24.24	24.325	11407948.0
2010-09-03 11:00:00	MSFT	Stock	24.325	24.35	24.26	24.285	7967085.0
2010-09-03 12:00:00	MSFT	Stock	24.285	24.3	24.24	24.3	6398423.0
2010-09-03 13:00:00	MSFT	Stock	24.3	24.31	24.28	24.299	5058370.0
2010-09-03 14:00:00	MSFT	Stock	24.295	24.34	24.25	24.27	6685932.0
2010-09-03 15:00:00	MSFT	Stock	24.27	24.31	24.24	24.305	12587903.0
2010-09-03 16:00:00	MSFT	Stock	24.305	24.33	24.259	24.33	5227563.0
2010-09-03 17:00:00	MSFT	Stock	24.32	24.32	24.29	24.29	61029.0
2010-09-03 18:00:00	MSFT	Stock	24.31	24.33	24.28	24.33	57646.0
2010-09-03 19:00:00	MSFT	Stock	24.3	24.34	24.3	24.34	3385.0
2010-09-03 07:00:00	NVDA	Stock	0.2315	0.2315	0.2312	0.2312	280000.0
2010-09-03 08:00:00	NVDA	Stock	0.2378	0.2448	0.2378	0.2438	233600.0
2010-09-03 09:00:00	NVDA	Stock	0.2445	0.247	0.242	0.247	90687440.0
2010-09-03 10:00:00	NVDA	Stock	0.2468	0.2469	0.2428	0.2453	139399680.0
2010-09-03 11:00:00	NVDA	Stock	0.2453	0.2462	0.2438	0.2455	35575240.0
2010-09-03 12:00:00	NVDA	Stock	0.2455	0.2475	0.2453	0.247	48291520.0
2010-09-03 13:00:00	NVDA	Stock	0.2471	0.2482	0.2468	0.2478	50347080.0
2010-09-03 14:00:00	NVDA	Stock	0.248	0.2482	0.246	0.2461	49614680.0
2010-09-03 15:00:00	NVDA	Stock	0.2462	0.2482	0.2455	0.2475	132496080.0
2010-09-03 16:00:00	NVDA	Stock	0.2474	0.2478	0.2438	0.2478	19163800.0
2010-09-03 17:00:00	NVDA	Stock	0.2475	0.2475	0.2475	0.2475	326800.0
2010-09-03 18:00:00	NVDA	Stock	0.2478	0.2478	0.2475	0.2475	24000.0
2010-09-03 19:00:00	NVDA	Stock	0.2475	0.2475	0.2465	0.2465	110240.0
2010-09-03 07:00:00	AMZN	Stock	6.713	6.713	6.7125	6.7125	7000.0
2010-09-03 08:00:00	AMZN	Stock	6.75	6.875	6.7345	6.844	524960.0
2010-09-03 09:00:00	AMZN	Stock	6.841	6.975	6.816	6.9625	35339880.0
2010-09-03 10:00:00	AMZN	Stock	6.9595	6.9605	6.8805	6.9	31780740.0
2010-09-03 11:00:00	AMZN	Stock	6.8985	6.925	6.8835	6.9038	11069840.0
2010-09-03 12:00:00	AMZN	Stock	6.904	6.954	6.9035	6.9496	11744500.0
2010-09-03 13:00:00	AMZN	Stock	6.95	6.9635	6.9275	6.949	10212160.0
2010-09-03 14:00:00	AMZN	Stock	6.9495	6.95	6.91	6.9135	9952880.0

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

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