PREVIEW / stock_1hour / 2010-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-14.parquet
  size:    905 KB
  rows:    43,190
  symbols: 3,479

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-10-14 04:00:00	AAPL	Stock	10.7582	10.7582	10.7582	10.7582	14000.0
2010-10-14 05:00:00	AAPL	Stock	10.75	10.75	10.7425	10.7425	8400.0
2010-10-14 06:00:00	AAPL	Stock	10.7286	10.7386	10.7286	10.7386	8400.0
2010-10-14 07:00:00	AAPL	Stock	10.75	10.7632	10.7421	10.7586	282436.0
2010-10-14 08:00:00	AAPL	Stock	10.7536	10.8261	10.735	10.7968	11392444.0
2010-10-14 09:00:00	AAPL	Stock	10.7954	10.7968	10.7286	10.74	88828012.0
2010-10-14 10:00:00	AAPL	Stock	10.74	10.8025	10.7357	10.7914	71580852.0
2010-10-14 11:00:00	AAPL	Stock	10.7918	10.7964	10.7625	10.775	52737832.0
2010-10-14 12:00:00	AAPL	Stock	10.7743	10.7857	10.7457	10.7629	39053896.0
2010-10-14 13:00:00	AAPL	Stock	10.7639	10.7743	10.7329	10.7707	46599896.0
2010-10-14 14:00:00	AAPL	Stock	10.7693	10.7707	10.7429	10.7479	32090464.0
2010-10-14 15:00:00	AAPL	Stock	10.7482	10.7964	10.7375	10.7954	64754088.0
2010-10-14 16:00:00	AAPL	Stock	10.7946	10.9071	10.7193	10.9014	20192620.0
2010-10-14 17:00:00	AAPL	Stock	10.7844	10.905	10.7653	10.8868	1753304.0
2010-10-14 18:00:00	AAPL	Stock	10.885	10.885	10.7968	10.8732	1144276.0
2010-10-14 19:00:00	AAPL	Stock	10.8736	10.8821	10.8707	10.8807	475020.0
2010-10-14 04:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	500.0
2010-10-14 05:00:00	MSFT	Stock	25.4	25.4	25.37	25.37	1000.0
2010-10-14 06:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	500.0
2010-10-14 07:00:00	MSFT	Stock	25.4	25.4	25.35	25.35	8200.0
2010-10-14 08:00:00	MSFT	Stock	25.34	25.38	25.13	25.14	78899.0
2010-10-14 09:00:00	MSFT	Stock	25.14	25.34	25.08	25.086	7335077.0
2010-10-14 10:00:00	MSFT	Stock	25.09	25.23	25.05	25.21	6279466.0
2010-10-14 11:00:00	MSFT	Stock	25.21	25.22	25.13	25.141	4837271.0
2010-10-14 12:00:00	MSFT	Stock	25.142	25.18	25.06	25.123	4234996.0
2010-10-14 13:00:00	MSFT	Stock	25.125	25.23	25.0	25.215	6749634.0
2010-10-14 14:00:00	MSFT	Stock	25.22	25.22	25.03	25.05	7051678.0
2010-10-14 15:00:00	MSFT	Stock	25.04	25.23	25.02	25.23	8890142.0
2010-10-14 16:00:00	MSFT	Stock	25.205	25.38	25.158	25.3	3264469.0
2010-10-14 17:00:00	MSFT	Stock	25.31	25.31	25.25	25.31	188023.0
2010-10-14 18:00:00	MSFT	Stock	25.31	25.31	25.23	25.3	31367.0
2010-10-14 19:00:00	MSFT	Stock	25.3	25.3	25.29	25.3	6500.0
2010-10-14 08:00:00	NVDA	Stock	0.2838	0.2838	0.2838	0.2838	20000.0
2010-10-14 09:00:00	NVDA	Stock	0.2838	0.2842	0.279	0.2792	93887800.0
2010-10-14 10:00:00	NVDA	Stock	0.279	0.284	0.279	0.2823	98619560.0
2010-10-14 11:00:00	NVDA	Stock	0.2822	0.2829	0.2795	0.2813	69686320.0
2010-10-14 12:00:00	NVDA	Stock	0.2815	0.2822	0.2798	0.2814	99098040.0
2010-10-14 13:00:00	NVDA	Stock	0.2812	0.2825	0.2778	0.2818	73959440.0
2010-10-14 14:00:00	NVDA	Stock	0.2818	0.2819	0.2784	0.2786	47510040.0
2010-10-14 15:00:00	NVDA	Stock	0.2785	0.2798	0.278	0.2792	97494920.0
2010-10-14 16:00:00	NVDA	Stock	0.2792	0.2835	0.2785	0.2815	3427280.0
2010-10-14 17:00:00	NVDA	Stock	0.2825	0.2872	0.2822	0.2848	2051680.0
2010-10-14 18:00:00	NVDA	Stock	0.2825	0.2825	0.28	0.2822	857760.0
2010-10-14 19:00:00	NVDA	Stock	0.2822	0.2822	0.2803	0.2805	327040.0
2010-10-14 08:00:00	AMZN	Stock	7.75	7.788	7.725	7.74	43660.0
2010-10-14 09:00:00	AMZN	Stock	7.74	7.8	7.7115	7.7395	10972600.0
2010-10-14 10:00:00	AMZN	Stock	7.738	7.8475	7.733	7.8215	17193780.0
2010-10-14 11:00:00	AMZN	Stock	7.8225	7.834	7.7605	7.77	8805140.0
2010-10-14 12:00:00	AMZN	Stock	7.77	7.795	7.7525	7.79	5995140.0
2010-10-14 13:00:00	AMZN	Stock	7.79	7.8185	7.762	7.797	10466420.0

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

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