PREVIEW / stock_1hour / 2010-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-26.parquet
  size:    907 KB
  rows:    43,179
  symbols: 3,476

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-07-26 06:00:00	AAPL	Stock	9.2871	9.2957	9.2786	9.2786	43120.0
2010-07-26 07:00:00	AAPL	Stock	9.2857	9.2864	9.2386	9.275	155456.0
2010-07-26 08:00:00	AAPL	Stock	9.27	9.2764	9.2507	9.2764	1160572.0
2010-07-26 09:00:00	AAPL	Stock	9.275	9.3129	9.2154	9.2254	67700864.0
2010-07-26 10:00:00	AAPL	Stock	9.2254	9.2768	9.2039	9.2521	81959108.0
2010-07-26 11:00:00	AAPL	Stock	9.2529	9.2732	9.2432	9.25	47300988.0
2010-07-26 12:00:00	AAPL	Stock	9.2496	9.2557	9.215	9.2307	39568956.0
2010-07-26 13:00:00	AAPL	Stock	9.2307	9.2457	9.2075	9.2397	41924848.0
2010-07-26 14:00:00	AAPL	Stock	9.2404	9.2407	9.2082	9.22	33247340.0
2010-07-26 15:00:00	AAPL	Stock	9.22	9.2596	9.2179	9.2596	64444744.0
2010-07-26 16:00:00	AAPL	Stock	9.26	9.2864	9.2383	9.2521	36636740.0
2010-07-26 17:00:00	AAPL	Stock	9.2571	9.2571	9.2518	9.2571	218960.0
2010-07-26 18:00:00	AAPL	Stock	9.2543	9.26	9.2511	9.2514	3416028.0
2010-07-26 19:00:00	AAPL	Stock	9.2514	9.2536	9.2321	9.25	283500.0
2010-07-26 06:00:00	MSFT	Stock	25.82	25.82	25.82	25.82	500.0
2010-07-26 07:00:00	MSFT	Stock	25.79	25.79	25.77	25.78	3466.0
2010-07-26 08:00:00	MSFT	Stock	25.73	25.82	25.73	25.8	46436.0
2010-07-26 09:00:00	MSFT	Stock	25.79	25.98	25.79	25.91	7145962.0
2010-07-26 10:00:00	MSFT	Stock	25.92	26.06	25.89	26.035	11149386.0
2010-07-26 11:00:00	MSFT	Stock	26.05	26.19	26.04	26.125	8469431.0
2010-07-26 12:00:00	MSFT	Stock	26.13	26.17	25.96	26.02	8306591.0
2010-07-26 13:00:00	MSFT	Stock	26.021	26.2	25.96	26.15	5605398.0
2010-07-26 14:00:00	MSFT	Stock	26.15	26.18	25.975	26.01	5224442.0
2010-07-26 15:00:00	MSFT	Stock	26.01	26.13	26.0	26.11	11404008.0
2010-07-26 16:00:00	MSFT	Stock	26.11	26.12	25.818	26.03	9464016.0
2010-07-26 17:00:00	MSFT	Stock	25.81	26.06	25.81	26.04	10185.0
2010-07-26 18:00:00	MSFT	Stock	26.01	26.1	26.0	26.0	25382.0
2010-07-26 19:00:00	MSFT	Stock	26.03	26.05	26.0	26.0	2140.0
2010-07-26 08:00:00	NVDA	Stock	0.26	0.26	0.2563	0.2572	869600.0
2010-07-26 09:00:00	NVDA	Stock	0.2575	0.2588	0.2543	0.2563	85909680.0
2010-07-26 10:00:00	NVDA	Stock	0.2565	0.2583	0.255	0.2583	147464280.0
2010-07-26 11:00:00	NVDA	Stock	0.2582	0.263	0.258	0.2625	121793520.0
2010-07-26 12:00:00	NVDA	Stock	0.2626	0.2635	0.2618	0.2635	55921200.0
2010-07-26 13:00:00	NVDA	Stock	0.2635	0.2643	0.2625	0.2638	42939120.0
2010-07-26 14:00:00	NVDA	Stock	0.2639	0.2643	0.2628	0.2635	54531800.0
2010-07-26 15:00:00	NVDA	Stock	0.2638	0.2648	0.2632	0.264	148138640.0
2010-07-26 16:00:00	NVDA	Stock	0.2632	0.267	0.2589	0.2638	4975080.0
2010-07-26 17:00:00	NVDA	Stock	0.263	0.2638	0.2588	0.2595	9209200.0
2010-07-26 18:00:00	NVDA	Stock	0.2595	0.2615	0.2588	0.259	998600.0
2010-07-26 19:00:00	NVDA	Stock	0.2598	0.262	0.2595	0.262	597880.0
2010-07-26 04:00:00	AMZN	Stock	5.9055	5.9055	5.9055	5.9055	2000.0
2010-07-26 06:00:00	AMZN	Stock	5.9035	5.9035	5.9035	5.9035	2000.0
2010-07-26 07:00:00	AMZN	Stock	5.915	5.9155	5.9055	5.9065	63420.0
2010-07-26 08:00:00	AMZN	Stock	5.9125	5.934	5.905	5.9285	463780.0
2010-07-26 09:00:00	AMZN	Stock	5.933	5.955	5.788	5.816	44980320.0
2010-07-26 10:00:00	AMZN	Stock	5.8185	5.865	5.744	5.7945	52565820.0
2010-07-26 11:00:00	AMZN	Stock	5.793	5.8735	5.785	5.8675	27177200.0
2010-07-26 12:00:00	AMZN	Stock	5.867	5.8845	5.8295	5.8455	20328260.0
2010-07-26 13:00:00	AMZN	Stock	5.8465	5.862	5.8185	5.8575	12090940.0
2010-07-26 14:00:00	AMZN	Stock	5.8573	5.904	5.855	5.876	21795900.0

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

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