PREVIEW / stock_1hour / 2010-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-09.parquet
  size:    954 KB
  rows:    45,964
  symbols: 3,519

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-09 05:00:00	AAPL	Stock	11.3321	11.3693	11.3321	11.3686	14000.0
2010-11-09 06:00:00	AAPL	Stock	11.3571	11.375	11.3571	11.375	28000.0
2010-11-09 07:00:00	AAPL	Stock	11.4071	11.4489	11.3968	11.4457	666540.0
2010-11-09 08:00:00	AAPL	Stock	11.4457	11.4946	11.4286	11.4589	7809844.0
2010-11-09 09:00:00	AAPL	Stock	11.4675	11.4886	11.4218	11.4454	61151944.0
2010-11-09 10:00:00	AAPL	Stock	11.4432	11.4639	11.4357	11.4514	49387604.0
2010-11-09 11:00:00	AAPL	Stock	11.4536	11.4582	11.3775	11.3789	41657644.0
2010-11-09 12:00:00	AAPL	Stock	11.3786	11.3954	11.3771	11.3854	25882948.0
2010-11-09 13:00:00	AAPL	Stock	11.3843	11.4107	11.3143	11.3464	51590980.0
2010-11-09 14:00:00	AAPL	Stock	11.3461	11.375	11.3371	11.3532	28173152.0
2010-11-09 15:00:00	AAPL	Stock	11.3536	11.3568	11.2321	11.2886	102487952.0
2010-11-09 16:00:00	AAPL	Stock	11.2886	11.4577	11.2628	11.275	8003044.0
2010-11-09 17:00:00	AAPL	Stock	11.2736	11.275	11.2625	11.2671	877520.0
2010-11-09 18:00:00	AAPL	Stock	11.2661	11.2886	11.2643	11.2789	646464.0
2010-11-09 19:00:00	AAPL	Stock	11.2789	11.2939	11.2789	11.2896	400260.0
2010-11-09 04:00:00	MSFT	Stock	26.89	26.94	26.89	26.94	500.0
2010-11-09 05:00:00	MSFT	Stock	26.94	26.94	26.94	26.94	100.0
2010-11-09 06:00:00	MSFT	Stock	26.97	26.99	26.97	26.99	600.0
2010-11-09 07:00:00	MSFT	Stock	26.97	26.97	26.94	26.94	8670.0
2010-11-09 08:00:00	MSFT	Stock	26.94	26.96	26.9	26.91	32804.0
2010-11-09 09:00:00	MSFT	Stock	26.91	26.93	26.71	26.83	6217966.0
2010-11-09 10:00:00	MSFT	Stock	26.825	27.11	26.8	27.02	11842355.0
2010-11-09 11:00:00	MSFT	Stock	27.03	27.05	26.94	26.94	8037264.0
2010-11-09 12:00:00	MSFT	Stock	26.95	27.04	26.93	27.01	4023832.0
2010-11-09 13:00:00	MSFT	Stock	27.02	27.05	26.92	27.013	4712430.0
2010-11-09 14:00:00	MSFT	Stock	27.01	27.05	26.97	27.003	4250230.0
2010-11-09 15:00:00	MSFT	Stock	27.0	27.01	26.8	26.95	13390594.0
2010-11-09 16:00:00	MSFT	Stock	26.95	27.01	26.814	26.96	2813878.0
2010-11-09 17:00:00	MSFT	Stock	26.96	26.96	26.94	26.94	12955.0
2010-11-09 18:00:00	MSFT	Stock	26.95	26.95	26.93	26.94	12114.0
2010-11-09 19:00:00	MSFT	Stock	26.94	26.96	26.9	26.96	3355.0
2010-11-09 08:00:00	NVDA	Stock	0.3165	0.3185	0.3165	0.3175	677240.0
2010-11-09 09:00:00	NVDA	Stock	0.3173	0.3185	0.3155	0.3164	77578680.0
2010-11-09 10:00:00	NVDA	Stock	0.3165	0.319	0.3163	0.3168	100217600.0
2010-11-09 11:00:00	NVDA	Stock	0.3165	0.3178	0.3155	0.3168	68994360.0
2010-11-09 12:00:00	NVDA	Stock	0.3165	0.3173	0.3153	0.316	55687160.0
2010-11-09 13:00:00	NVDA	Stock	0.3163	0.3173	0.313	0.313	75827160.0
2010-11-09 14:00:00	NVDA	Stock	0.313	0.3163	0.313	0.3163	70817760.0
2010-11-09 15:00:00	NVDA	Stock	0.316	0.3163	0.3138	0.3145	155243520.0
2010-11-09 16:00:00	NVDA	Stock	0.3148	0.3178	0.3138	0.3153	22593360.0
2010-11-09 17:00:00	NVDA	Stock	0.3145	0.3145	0.3145	0.3145	62000.0
2010-11-09 19:00:00	NVDA	Stock	0.3145	0.3145	0.3145	0.3145	4000.0
2010-11-09 04:00:00	AMZN	Stock	8.572	8.572	8.572	8.572	2000.0
2010-11-09 08:00:00	AMZN	Stock	8.628	8.6425	8.615	8.6325	91600.0
2010-11-09 09:00:00	AMZN	Stock	8.629	8.6405	8.5555	8.5855	10071700.0
2010-11-09 10:00:00	AMZN	Stock	8.5815	8.657	8.559	8.592	15264120.0
2010-11-09 11:00:00	AMZN	Stock	8.5903	8.5936	8.525	8.5255	10446860.0
2010-11-09 12:00:00	AMZN	Stock	8.525	8.5515	8.519	8.5355	5377820.0
2010-11-09 13:00:00	AMZN	Stock	8.535	8.5725	8.4835	8.5045	11015760.0
2010-11-09 14:00:00	AMZN	Stock	8.5065	8.5375	8.504	8.5355	5780580.0

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

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