PREVIEW / stock_1hour / 2010-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-17.parquet
  size:    921 KB
  rows:    44,816
  symbols: 3,504

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-11-17 05:00:00	AAPL	Stock	10.8036	10.8036	10.7946	10.7946	16660.0
2010-11-17 06:00:00	AAPL	Stock	10.7871	10.7871	10.7843	10.7864	16800.0
2010-11-17 07:00:00	AAPL	Stock	10.8029	10.8029	10.7461	10.7682	257740.0
2010-11-17 08:00:00	AAPL	Stock	10.7746	10.8007	10.7618	10.7714	3067876.0
2010-11-17 09:00:00	AAPL	Stock	10.775	10.8136	10.7232	10.7543	70663992.0
2010-11-17 10:00:00	AAPL	Stock	10.7532	10.8568	10.7532	10.8279	87377864.0
2010-11-17 11:00:00	AAPL	Stock	10.8286	10.8371	10.79	10.8179	45089492.0
2010-11-17 12:00:00	AAPL	Stock	10.8192	10.8304	10.7929	10.8018	23814140.0
2010-11-17 13:00:00	AAPL	Stock	10.8011	10.8125	10.7725	10.7865	31871784.0
2010-11-17 14:00:00	AAPL	Stock	10.7875	10.8104	10.7579	10.7711	34429472.0
2010-11-17 15:00:00	AAPL	Stock	10.7693	10.7718	10.6343	10.7268	166342960.0
2010-11-17 16:00:00	AAPL	Stock	10.7314	10.7621	10.6544	10.7325	9315432.0
2010-11-17 17:00:00	AAPL	Stock	10.7268	10.7321	10.7214	10.7321	198996.0
2010-11-17 18:00:00	AAPL	Stock	10.7339	10.7479	10.7271	10.7479	396900.0
2010-11-17 19:00:00	AAPL	Stock	10.7418	10.7679	10.7418	10.7679	373240.0
2010-11-17 07:00:00	MSFT	Stock	25.81	25.82	25.81	25.82	1200.0
2010-11-17 08:00:00	MSFT	Stock	25.85	25.91	25.85	25.86	20879.0
2010-11-17 09:00:00	MSFT	Stock	25.88	25.91	25.783	25.815	6891161.0
2010-11-17 10:00:00	MSFT	Stock	25.816	25.84	25.76	25.77	7920440.0
2010-11-17 11:00:00	MSFT	Stock	25.778	25.8	25.7	25.78	5586342.0
2010-11-17 12:00:00	MSFT	Stock	25.785	25.79	25.73	25.77	5473550.0
2010-11-17 13:00:00	MSFT	Stock	25.76	25.78	25.7	25.71	4418630.0
2010-11-17 14:00:00	MSFT	Stock	25.715	25.78	25.71	25.75	8436796.0
2010-11-17 15:00:00	MSFT	Stock	25.75	25.77	25.55	25.59	13816156.0
2010-11-17 16:00:00	MSFT	Stock	25.58	25.739	25.51	25.57	2946728.0
2010-11-17 17:00:00	MSFT	Stock	25.79	25.79	25.59	25.6	1903.0
2010-11-17 18:00:00	MSFT	Stock	25.61	25.61	25.57	25.61	12127.0
2010-11-17 19:00:00	MSFT	Stock	25.62	25.63	25.61	25.63	25580.0
2010-11-17 08:00:00	NVDA	Stock	0.3208	0.3208	0.3205	0.3205	56000.0
2010-11-17 09:00:00	NVDA	Stock	0.3203	0.3223	0.3145	0.32	105787400.0
2010-11-17 10:00:00	NVDA	Stock	0.3201	0.3268	0.32	0.3221	128044960.0
2010-11-17 11:00:00	NVDA	Stock	0.3223	0.323	0.3198	0.3203	69666120.0
2010-11-17 12:00:00	NVDA	Stock	0.3203	0.3213	0.32	0.3213	31352960.0
2010-11-17 13:00:00	NVDA	Stock	0.3211	0.3238	0.321	0.3233	32769920.0
2010-11-17 14:00:00	NVDA	Stock	0.3234	0.3245	0.3226	0.3228	31963880.0
2010-11-17 15:00:00	NVDA	Stock	0.3228	0.3238	0.3198	0.3228	128104920.0
2010-11-17 16:00:00	NVDA	Stock	0.323	0.3231	0.321	0.323	3879080.0
2010-11-17 17:00:00	NVDA	Stock	0.323	0.3238	0.323	0.3238	76880.0
2010-11-17 19:00:00	NVDA	Stock	0.3245	0.3245	0.3245	0.3245	17680.0
2010-11-17 07:00:00	AMZN	Stock	7.9425	7.9425	7.9425	7.9425	2000.0
2010-11-17 08:00:00	AMZN	Stock	7.901	7.94	7.901	7.925	124460.0
2010-11-17 09:00:00	AMZN	Stock	7.923	7.9835	7.889	7.952	12936980.0
2010-11-17 10:00:00	AMZN	Stock	7.947	8.0425	7.947	8.0045	19948200.0
2010-11-17 11:00:00	AMZN	Stock	8.0045	8.02	7.9615	8.009	10821280.0
2010-11-17 12:00:00	AMZN	Stock	8.0062	8.0115	7.951	7.956	6541200.0
2010-11-17 13:00:00	AMZN	Stock	7.9545	7.9865	7.9375	7.9565	8833320.0
2010-11-17 14:00:00	AMZN	Stock	7.9585	7.9855	7.943	7.954	7335920.0
2010-11-17 15:00:00	AMZN	Stock	7.955	7.96	7.8775	7.918	20911200.0
2010-11-17 16:00:00	AMZN	Stock	7.9185	7.9614	7.8832	7.8832	304600.0
2010-11-17 17:00:00	AMZN	Stock	7.889	7.9295	7.889	7.9295	23500.0

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

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