PREVIEW / stock_1hour / 2010-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-16.parquet
  size:    899 KB
  rows:    42,916
  symbols: 3,469

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-16 04:00:00	AAPL	Stock	7.2107	7.2143	7.2107	7.2107	31332.0
2010-02-16 06:00:00	AAPL	Stock	7.1946	7.1946	7.1929	7.1929	5600.0
2010-02-16 07:00:00	AAPL	Stock	7.1757	7.2054	7.1757	7.1893	36344.0
2010-02-16 08:00:00	AAPL	Stock	7.1854	7.2064	7.1846	7.2064	1578220.0
2010-02-16 09:00:00	AAPL	Stock	7.2064	7.2407	7.1971	7.2279	79400664.0
2010-02-16 10:00:00	AAPL	Stock	7.2279	7.2668	7.2143	7.2436	91894544.0
2010-02-16 11:00:00	AAPL	Stock	7.2443	7.27	7.2379	7.2604	50748040.0
2010-02-16 12:00:00	AAPL	Stock	7.2607	7.2746	7.2514	7.2536	90031648.0
2010-02-16 13:00:00	AAPL	Stock	7.2539	7.2643	7.2396	7.2539	57559852.0
2010-02-16 14:00:00	AAPL	Stock	7.2529	7.2621	7.2439	7.2596	37176692.0
2010-02-16 15:00:00	AAPL	Stock	7.2593	7.2743	7.2571	7.265	72217068.0
2010-02-16 16:00:00	AAPL	Stock	7.265	7.2665	7.2443	7.2618	24881612.0
2010-02-16 17:00:00	AAPL	Stock	7.2629	7.2671	7.2607	7.2643	325276.0
2010-02-16 18:00:00	AAPL	Stock	7.2643	7.2654	7.2611	7.2618	1192408.0
2010-02-16 19:00:00	AAPL	Stock	7.2625	7.2679	7.2625	7.2679	118972.0
2010-02-16 04:00:00	MSFT	Stock	28.17	28.17	28.06	28.06	300.0
2010-02-16 05:00:00	MSFT	Stock	28.06	28.06	28.06	28.06	500.0
2010-02-16 07:00:00	MSFT	Stock	28.06	28.06	28.0	28.0	1500.0
2010-02-16 08:00:00	MSFT	Stock	28.04	28.1	28.02	28.09	23619.0
2010-02-16 09:00:00	MSFT	Stock	28.1	28.22	28.02	28.08	5001333.0
2010-02-16 10:00:00	MSFT	Stock	28.085	28.35	28.08	28.2	7052792.0
2010-02-16 11:00:00	MSFT	Stock	28.21	28.33	28.12	28.3	5471759.0
2010-02-16 12:00:00	MSFT	Stock	28.3	28.34	28.2	28.219	4168402.0
2010-02-16 13:00:00	MSFT	Stock	28.22	28.3	28.19	28.27	4294034.0
2010-02-16 14:00:00	MSFT	Stock	28.265	28.3	28.17	28.255	6390056.0
2010-02-16 15:00:00	MSFT	Stock	28.25	28.37	28.22	28.34	14207809.0
2010-02-16 16:00:00	MSFT	Stock	28.34	28.41	28.223	28.39	3952481.0
2010-02-16 17:00:00	MSFT	Stock	28.31	28.41	28.308	28.37	239252.0
2010-02-16 18:00:00	MSFT	Stock	28.37	28.37	28.37	28.37	1725.0
2010-02-16 19:00:00	MSFT	Stock	28.39	28.39	28.39	28.39	800.0
2010-02-16 08:00:00	NVDA	Stock	0.4412	0.4412	0.438	0.438	120000.0
2010-02-16 09:00:00	NVDA	Stock	0.4388	0.4408	0.4342	0.4385	62550120.0
2010-02-16 10:00:00	NVDA	Stock	0.4385	0.4432	0.4368	0.4418	98448160.0
2010-02-16 11:00:00	NVDA	Stock	0.442	0.443	0.438	0.4392	56423440.0
2010-02-16 12:00:00	NVDA	Stock	0.4392	0.4425	0.4382	0.4405	41775440.0
2010-02-16 13:00:00	NVDA	Stock	0.4405	0.4408	0.438	0.4395	36716000.0
2010-02-16 14:00:00	NVDA	Stock	0.4392	0.4418	0.4388	0.4405	46214880.0
2010-02-16 15:00:00	NVDA	Stock	0.4405	0.4435	0.4395	0.4418	101137120.0
2010-02-16 16:00:00	NVDA	Stock	0.4418	0.4421	0.4402	0.4415	8805520.0
2010-02-16 17:00:00	NVDA	Stock	0.4415	0.4438	0.4415	0.4438	176400.0
2010-02-16 18:00:00	NVDA	Stock	0.4418	0.4462	0.4418	0.445	2097480.0
2010-02-16 19:00:00	NVDA	Stock	0.445	0.445	0.4438	0.4448	24440.0
2010-02-16 07:00:00	AMZN	Stock	6.03	6.031	6.03	6.031	4000.0
2010-02-16 08:00:00	AMZN	Stock	6.025	6.05	6.025	6.0425	158480.0
2010-02-16 09:00:00	AMZN	Stock	6.0305	6.05	5.9155	5.9215	28575780.0
2010-02-16 10:00:00	AMZN	Stock	5.9235	5.976	5.9	5.9265	26846880.0
2010-02-16 11:00:00	AMZN	Stock	5.9265	5.938	5.8955	5.9135	26637960.0
2010-02-16 12:00:00	AMZN	Stock	5.9154	5.9255	5.8875	5.8975	14787080.0
2010-02-16 13:00:00	AMZN	Stock	5.897	5.9064	5.8785	5.8833	16705980.0
2010-02-16 14:00:00	AMZN	Stock	5.883	5.8975	5.868	5.885	21710140.0

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

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