PREVIEW / stock_1hour / 2009-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-05.parquet
  size:    877 KB
  rows:    42,730
  symbols: 3,358

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
2009-05-05 07:00:00	AAPL	Stock	4.69	4.69	4.6786	4.6857	132636.0
2009-05-05 08:00:00	AAPL	Stock	4.7	4.7139	4.6786	4.7068	1180032.0
2009-05-05 09:00:00	AAPL	Stock	4.7018	4.7414	4.6829	4.7161	65396520.0
2009-05-05 10:00:00	AAPL	Stock	4.7164	4.7339	4.6989	4.7004	68196128.0
2009-05-05 11:00:00	AAPL	Stock	4.6989	4.7264	4.6946	4.7164	37499756.0
2009-05-05 12:00:00	AAPL	Stock	4.7164	4.7264	4.7089	4.7129	30074464.0
2009-05-05 13:00:00	AAPL	Stock	4.7129	4.7375	4.7054	4.7332	52361596.0
2009-05-05 14:00:00	AAPL	Stock	4.7321	4.7332	4.6993	4.7068	51210236.0
2009-05-05 15:00:00	AAPL	Stock	4.7061	4.745	4.7021	4.7393	76935124.0
2009-05-05 16:00:00	AAPL	Stock	4.7396	4.7429	4.7054	4.7396	8848700.0
2009-05-05 17:00:00	AAPL	Stock	4.7357	4.7411	4.7357	4.7411	129276.0
2009-05-05 18:00:00	AAPL	Stock	4.7396	4.7439	4.7396	4.7432	249984.0
2009-05-05 19:00:00	AAPL	Stock	4.7439	4.7446	4.7421	4.7446	61152.0
2009-05-05 06:00:00	MSFT	Stock	20.28	20.35	20.28	20.35	2100.0
2009-05-05 07:00:00	MSFT	Stock	20.3	20.38	20.25	20.25	7099.0
2009-05-05 08:00:00	MSFT	Stock	20.2	20.28	20.11	20.14	17141.0
2009-05-05 09:00:00	MSFT	Stock	20.13	20.24	20.05	20.16	6134631.0
2009-05-05 10:00:00	MSFT	Stock	20.16	20.2	19.76	19.82	15069124.0
2009-05-05 11:00:00	MSFT	Stock	19.82	19.85	19.75	19.83	7135408.0
2009-05-05 12:00:00	MSFT	Stock	19.825	19.84	19.73	19.77	4796853.0
2009-05-05 13:00:00	MSFT	Stock	19.76	19.8	19.7	19.77	4454357.0
2009-05-05 14:00:00	MSFT	Stock	19.77	19.84	19.64	19.68	7007159.0
2009-05-05 15:00:00	MSFT	Stock	19.68	19.93	19.65	19.81	14407218.0
2009-05-05 16:00:00	MSFT	Stock	19.79	20.103	19.72	19.78	6406425.0
2009-05-05 17:00:00	MSFT	Stock	19.8	19.86	19.8	19.86	11173.0
2009-05-05 18:00:00	MSFT	Stock	19.85	19.85	19.79	19.81	402030.0
2009-05-05 19:00:00	MSFT	Stock	19.83	19.85	19.81	19.85	6977.0
2009-05-05 08:00:00	NVDA	Stock	0.305	0.305	0.3028	0.3028	24000.0
2009-05-05 09:00:00	NVDA	Stock	0.3008	0.3075	0.2892	0.2945	171485480.0
2009-05-05 10:00:00	NVDA	Stock	0.2945	0.297	0.2895	0.2895	207461520.0
2009-05-05 11:00:00	NVDA	Stock	0.2895	0.296	0.2888	0.294	93638360.0
2009-05-05 12:00:00	NVDA	Stock	0.294	0.2945	0.2912	0.2932	58583200.0
2009-05-05 13:00:00	NVDA	Stock	0.2932	0.2948	0.2902	0.2908	81034120.0
2009-05-05 14:00:00	NVDA	Stock	0.2908	0.292	0.2895	0.2912	83968720.0
2009-05-05 15:00:00	NVDA	Stock	0.291	0.2955	0.291	0.295	126410520.0
2009-05-05 16:00:00	NVDA	Stock	0.295	0.3012	0.2927	0.2958	13588280.0
2009-05-05 17:00:00	NVDA	Stock	0.295	0.295	0.294	0.295	48600.0
2009-05-05 18:00:00	NVDA	Stock	0.2948	0.2948	0.2948	0.2948	40000.0
2009-05-05 19:00:00	NVDA	Stock	0.2948	0.2948	0.2945	0.2945	100000.0
2009-05-05 07:00:00	AMZN	Stock	4.037	4.037	4.037	4.037	2000.0
2009-05-05 08:00:00	AMZN	Stock	4.02	4.025	4.01	4.0125	65840.0
2009-05-05 09:00:00	AMZN	Stock	4.0225	4.09	4.0095	4.072	26066680.0
2009-05-05 10:00:00	AMZN	Stock	4.0719	4.09	4.029	4.0325	19773060.0
2009-05-05 11:00:00	AMZN	Stock	4.032	4.0615	4.0315	4.054	10259520.0
2009-05-05 12:00:00	AMZN	Stock	4.0545	4.0675	4.0425	4.0485	7078960.0
2009-05-05 13:00:00	AMZN	Stock	4.05	4.059	4.0185	4.048	11252100.0
2009-05-05 14:00:00	AMZN	Stock	4.05	4.0745	4.036	4.049	14122740.0
2009-05-05 15:00:00	AMZN	Stock	4.05	4.1	4.0485	4.0965	22897400.0
2009-05-05 16:00:00	AMZN	Stock	4.095	4.1025	4.003	4.0995	5383700.0
2009-05-05 17:00:00	AMZN	Stock	4.101	4.101	4.095	4.101	10000.0

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

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