PREVIEW / stock_1hour / 2010-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-15.parquet
  size:    890 KB
  rows:    42,809
  symbols: 3,455

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-15 07:00:00	AAPL	Stock	9.5893	9.6014	9.5743	9.6	65800.0
2010-09-15 08:00:00	AAPL	Stock	9.6004	9.6107	9.5582	9.5779	1940680.0
2010-09-15 09:00:00	AAPL	Stock	9.5775	9.6304	9.5632	9.6175	70977648.0
2010-09-15 10:00:00	AAPL	Stock	9.6175	9.6368	9.6007	9.6336	77375564.0
2010-09-15 11:00:00	AAPL	Stock	9.6339	9.635	9.6068	9.6246	41364904.0
2010-09-15 12:00:00	AAPL	Stock	9.6248	9.6411	9.6232	9.64	35831740.0
2010-09-15 13:00:00	AAPL	Stock	9.64	9.6425	9.6343	9.6417	31006976.0
2010-09-15 14:00:00	AAPL	Stock	9.6417	9.6429	9.625	9.6404	47236504.0
2010-09-15 15:00:00	AAPL	Stock	9.64	9.6564	9.6329	9.6511	92814260.0
2010-09-15 16:00:00	AAPL	Stock	9.6536	9.6546	9.5732	9.6536	14893900.0
2010-09-15 17:00:00	AAPL	Stock	9.6227	9.6654	9.6227	9.665	574560.0
2010-09-15 18:00:00	AAPL	Stock	9.6661	9.6679	9.6507	9.6643	535976.0
2010-09-15 19:00:00	AAPL	Stock	9.6679	9.6871	9.6632	9.6864	1396724.0
2010-09-15 07:00:00	MSFT	Stock	24.97	24.97	24.97	24.97	500.0
2010-09-15 08:00:00	MSFT	Stock	25.0	25.02	24.95	25.0	26057.0
2010-09-15 09:00:00	MSFT	Stock	25.01	25.21	24.92	25.012	4639331.0
2010-09-15 10:00:00	MSFT	Stock	25.015	25.08	24.96	25.03	7077262.0
2010-09-15 11:00:00	MSFT	Stock	25.04	25.06	24.97	25.04	5505866.0
2010-09-15 12:00:00	MSFT	Stock	25.045	25.2	25.04	25.17	3910349.0
2010-09-15 13:00:00	MSFT	Stock	25.17	25.22	25.13	25.15	5645824.0
2010-09-15 14:00:00	MSFT	Stock	25.15	25.16	25.01	25.09	8364670.0
2010-09-15 15:00:00	MSFT	Stock	25.08	25.17	25.06	25.11	13478219.0
2010-09-15 16:00:00	MSFT	Stock	25.1	25.17	25.028	25.16	6132366.0
2010-09-15 17:00:00	MSFT	Stock	25.021	25.17	25.021	25.12	48246.0
2010-09-15 18:00:00	MSFT	Stock	25.13	25.16	25.11	25.12	131076.0
2010-09-15 19:00:00	MSFT	Stock	25.14	25.17	25.12	25.12	2000.0
2010-09-15 08:00:00	NVDA	Stock	0.2625	0.2625	0.2612	0.2625	84800.0
2010-09-15 09:00:00	NVDA	Stock	0.2643	0.2643	0.2575	0.2612	87112760.0
2010-09-15 10:00:00	NVDA	Stock	0.261	0.2615	0.2583	0.2595	114230280.0
2010-09-15 11:00:00	NVDA	Stock	0.2595	0.2615	0.2575	0.2612	80636440.0
2010-09-15 12:00:00	NVDA	Stock	0.2612	0.263	0.2612	0.263	42246920.0
2010-09-15 13:00:00	NVDA	Stock	0.2628	0.2635	0.2612	0.263	38578520.0
2010-09-15 14:00:00	NVDA	Stock	0.2629	0.263	0.2608	0.2625	39281840.0
2010-09-15 15:00:00	NVDA	Stock	0.2625	0.2643	0.2623	0.264	140122360.0
2010-09-15 16:00:00	NVDA	Stock	0.264	0.2647	0.2613	0.264	4874120.0
2010-09-15 17:00:00	NVDA	Stock	0.2619	0.2638	0.2619	0.2638	134920.0
2010-09-15 18:00:00	NVDA	Stock	0.2643	0.2643	0.264	0.264	134000.0
2010-09-15 08:00:00	AMZN	Stock	7.255	7.255	7.248	7.25	77600.0
2010-09-15 09:00:00	AMZN	Stock	7.248	7.267	7.2065	7.2315	12996480.0
2010-09-15 10:00:00	AMZN	Stock	7.231	7.2535	7.2055	7.2265	19315320.0
2010-09-15 11:00:00	AMZN	Stock	7.2275	7.2275	7.178	7.196	16954620.0
2010-09-15 12:00:00	AMZN	Stock	7.196	7.2375	7.196	7.219	9012460.0
2010-09-15 13:00:00	AMZN	Stock	7.219	7.2395	7.2095	7.235	7329200.0
2010-09-15 14:00:00	AMZN	Stock	7.2345	7.244	7.21	7.237	9286240.0
2010-09-15 15:00:00	AMZN	Stock	7.2365	7.281	7.2285	7.273	17809240.0
2010-09-15 16:00:00	AMZN	Stock	7.277	7.28	7.1896	7.2695	632020.0
2010-09-15 17:00:00	AMZN	Stock	7.2725	7.275	7.27	7.275	38040.0
2010-09-15 18:00:00	AMZN	Stock	7.2725	7.298	7.2655	7.27	52820.0
2010-09-15 19:00:00	AMZN	Stock	7.274	7.274	7.274	7.274	10000.0
2010-09-15 09:00:00	TSLA	Stock	1.3987	1.406	1.386	1.3993	803085.0

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

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