PREVIEW / stock_1hour / 2010-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-03.parquet
  size:    942 KB
  rows:    45,416
  symbols: 3,514

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-12-03 07:00:00	AAPL	Stock	11.3714	11.3929	11.3711	11.3929	349300.0
2010-12-03 08:00:00	AAPL	Stock	11.3929	11.4018	11.2571	11.2686	11125464.0
2010-12-03 09:00:00	AAPL	Stock	11.2718	11.3564	11.2661	11.3461	71185660.0
2010-12-03 10:00:00	AAPL	Stock	11.3446	11.3804	11.3264	11.3502	69969536.0
2010-12-03 11:00:00	AAPL	Stock	11.3504	11.3536	11.3018	11.3096	37919812.0
2010-12-03 12:00:00	AAPL	Stock	11.3093	11.3236	11.3018	11.3111	22971396.0
2010-12-03 13:00:00	AAPL	Stock	11.3121	11.3286	11.2979	11.325	25271848.0
2010-12-03 14:00:00	AAPL	Stock	11.325	11.3304	11.3036	11.3271	29177932.0
2010-12-03 15:00:00	AAPL	Stock	11.3275	11.3429	11.3079	11.3382	57687980.0
2010-12-03 16:00:00	AAPL	Stock	11.3357	11.3457	11.3257	11.3307	7476868.0
2010-12-03 17:00:00	AAPL	Stock	11.3311	11.3357	11.3307	11.3354	252924.0
2010-12-03 18:00:00	AAPL	Stock	11.3325	11.3371	11.3321	11.3325	160356.0
2010-12-03 19:00:00	AAPL	Stock	11.3339	11.3364	11.3321	11.3343	139216.0
2010-12-03 06:00:00	MSFT	Stock	26.83	26.83	26.8	26.8	500.0
2010-12-03 07:00:00	MSFT	Stock	26.85	26.89	26.83	26.89	1300.0
2010-12-03 08:00:00	MSFT	Stock	26.85	26.95	26.57	26.6	102063.0
2010-12-03 09:00:00	MSFT	Stock	26.6	26.95	26.59	26.94	6791267.0
2010-12-03 10:00:00	MSFT	Stock	26.94	27.0	26.88	26.94	9593423.0
2010-12-03 11:00:00	MSFT	Stock	26.945	26.97	26.87	26.92	6192502.0
2010-12-03 12:00:00	MSFT	Stock	26.93	26.98	26.9	26.96	4963969.0
2010-12-03 13:00:00	MSFT	Stock	26.96	27.0	26.96	26.99	5223244.0
2010-12-03 14:00:00	MSFT	Stock	27.0	27.02	26.98	27.01	5208975.0
2010-12-03 15:00:00	MSFT	Stock	27.01	27.06	26.95	27.02	10671941.0
2010-12-03 16:00:00	MSFT	Stock	27.02	27.07	26.9	27.04	1998964.0
2010-12-03 17:00:00	MSFT	Stock	26.9	27.05	26.9	27.04	25869.0
2010-12-03 18:00:00	MSFT	Stock	27.02	27.02	27.02	27.02	23273.0
2010-12-03 19:00:00	MSFT	Stock	27.02	27.04	27.02	27.02	2100.0
2010-12-03 08:00:00	NVDA	Stock	0.3682	0.3682	0.3562	0.3588	2216800.0
2010-12-03 09:00:00	NVDA	Stock	0.3565	0.3637	0.3565	0.3625	62994400.0
2010-12-03 10:00:00	NVDA	Stock	0.3628	0.3638	0.3605	0.3618	60485600.0
2010-12-03 11:00:00	NVDA	Stock	0.3618	0.362	0.3588	0.3596	51373000.0
2010-12-03 12:00:00	NVDA	Stock	0.3595	0.3608	0.3595	0.3602	26698440.0
2010-12-03 13:00:00	NVDA	Stock	0.3602	0.364	0.3592	0.3635	71776200.0
2010-12-03 14:00:00	NVDA	Stock	0.3638	0.368	0.3628	0.3675	125539880.0
2010-12-03 15:00:00	NVDA	Stock	0.3675	0.3698	0.3665	0.3695	187457040.0
2010-12-03 16:00:00	NVDA	Stock	0.3695	0.37	0.3646	0.37	3934480.0
2010-12-03 17:00:00	NVDA	Stock	0.3688	0.3688	0.3688	0.3688	20000.0
2010-12-03 18:00:00	NVDA	Stock	0.3682	0.3688	0.3682	0.3688	56000.0
2010-12-03 19:00:00	NVDA	Stock	0.371	0.371	0.371	0.371	13200.0
2010-12-03 07:00:00	AMZN	Stock	8.849	8.865	8.849	8.865	12000.0
2010-12-03 08:00:00	AMZN	Stock	8.8645	8.884	8.71	8.715	914860.0
2010-12-03 09:00:00	AMZN	Stock	8.725	8.806	8.7035	8.73	16164300.0
2010-12-03 10:00:00	AMZN	Stock	8.731	8.82	8.7025	8.815	24050520.0
2010-12-03 11:00:00	AMZN	Stock	8.8155	8.816	8.7465	8.7505	9716840.0
2010-12-03 12:00:00	AMZN	Stock	8.752	8.772	8.7415	8.742	6863940.0
2010-12-03 13:00:00	AMZN	Stock	8.742	8.765	8.7175	8.7642	9968460.0
2010-12-03 14:00:00	AMZN	Stock	8.765	8.774	8.7455	8.77	7586720.0
2010-12-03 15:00:00	AMZN	Stock	8.7692	8.8	8.759	8.7805	18878740.0
2010-12-03 16:00:00	AMZN	Stock	8.781	8.7879	8.7604	8.78	470500.0
2010-12-03 17:00:00	AMZN	Stock	8.7745	8.8	8.7745	8.7775	1832000.0

> showing 50 of 45,416 rows — these rows as CSV

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