PREVIEW / stock_1hour / 2010-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-08.parquet
  size:    930 KB
  rows:    44,233
  symbols: 3,530

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-08 05:00:00	AAPL	Stock	11.3857	11.3857	11.3725	11.3725	8400.0
2010-12-08 06:00:00	AAPL	Stock	11.4079	11.4079	11.4079	11.4079	2800.0
2010-12-08 07:00:00	AAPL	Stock	11.3843	11.3914	11.3786	11.3786	86800.0
2010-12-08 08:00:00	AAPL	Stock	11.3882	11.4393	11.3839	11.4179	2526412.0
2010-12-08 09:00:00	AAPL	Stock	11.4182	11.4418	11.3857	11.4186	48124496.0
2010-12-08 10:00:00	AAPL	Stock	11.4211	11.4211	11.3254	11.3571	71102304.0
2010-12-08 11:00:00	AAPL	Stock	11.3568	11.3818	11.3496	11.3721	32427052.0
2010-12-08 12:00:00	AAPL	Stock	11.3714	11.3768	11.345	11.3554	22155700.0
2010-12-08 13:00:00	AAPL	Stock	11.3571	11.3911	11.3546	11.3864	23571940.0
2010-12-08 14:00:00	AAPL	Stock	11.3864	11.4418	11.3793	11.4271	43483888.0
2010-12-08 15:00:00	AAPL	Stock	11.4257	11.465	11.4107	11.4646	61642728.0
2010-12-08 16:00:00	AAPL	Stock	11.4646	11.4711	11.3981	11.4625	11922260.0
2010-12-08 17:00:00	AAPL	Stock	11.465	11.4714	11.4554	11.4629	514556.0
2010-12-08 18:00:00	AAPL	Stock	11.4646	11.4821	11.4564	11.4779	499828.0
2010-12-08 19:00:00	AAPL	Stock	11.4736	11.4975	11.4736	11.4957	706860.0
2010-12-08 05:00:00	MSFT	Stock	26.59	26.59	26.59	26.59	100.0
2010-12-08 07:00:00	MSFT	Stock	26.72	26.8	26.7	26.8	9600.0
2010-12-08 08:00:00	MSFT	Stock	26.8	26.88	26.78	26.88	20585.0
2010-12-08 09:00:00	MSFT	Stock	26.87	27.09	26.8	27.04	4725816.0
2010-12-08 10:00:00	MSFT	Stock	27.045	27.08	26.97	27.01	7775382.0
2010-12-08 11:00:00	MSFT	Stock	27.015	27.17	27.01	27.135	5452041.0
2010-12-08 12:00:00	MSFT	Stock	27.139	27.18	27.05	27.161	4574880.0
2010-12-08 13:00:00	MSFT	Stock	27.16	27.23	27.13	27.19	5018527.0
2010-12-08 14:00:00	MSFT	Stock	27.19	27.21	27.15	27.185	3596772.0
2010-12-08 15:00:00	MSFT	Stock	27.18	27.24	27.15	27.23	7154576.0
2010-12-08 16:00:00	MSFT	Stock	27.21	27.24	27.101	27.23	1925507.0
2010-12-08 17:00:00	MSFT	Stock	27.23	27.27	27.22	27.23	19355.0
2010-12-08 18:00:00	MSFT	Stock	27.23	27.26	27.23	27.25	58421.0
2010-12-08 19:00:00	MSFT	Stock	27.26	27.29	27.22	27.29	8300.0
2010-12-08 08:00:00	NVDA	Stock	0.37	0.3728	0.369	0.3728	189000.0
2010-12-08 09:00:00	NVDA	Stock	0.372	0.3818	0.3713	0.3788	89666080.0
2010-12-08 10:00:00	NVDA	Stock	0.3788	0.3791	0.3713	0.3718	153136520.0
2010-12-08 11:00:00	NVDA	Stock	0.3715	0.377	0.3715	0.3768	70802720.0
2010-12-08 12:00:00	NVDA	Stock	0.377	0.3773	0.3748	0.3753	51965360.0
2010-12-08 13:00:00	NVDA	Stock	0.3753	0.378	0.375	0.3778	45476160.0
2010-12-08 14:00:00	NVDA	Stock	0.378	0.3785	0.3773	0.3773	30753840.0
2010-12-08 15:00:00	NVDA	Stock	0.3773	0.378	0.3753	0.3778	80055960.0
2010-12-08 16:00:00	NVDA	Stock	0.3775	0.3783	0.3761	0.3761	80960160.0
2010-12-08 17:00:00	NVDA	Stock	0.3745	0.3785	0.3745	0.3778	92000.0
2010-12-08 18:00:00	NVDA	Stock	0.3778	0.3778	0.3778	0.3778	196000.0
2010-12-08 08:00:00	AMZN	Stock	8.86	8.869	8.842	8.863	52220.0
2010-12-08 09:00:00	AMZN	Stock	8.8635	8.908	8.7975	8.8	11536640.0
2010-12-08 10:00:00	AMZN	Stock	8.8	8.838	8.76	8.816	14997800.0
2010-12-08 11:00:00	AMZN	Stock	8.816	8.857	8.8005	8.8305	6729520.0
2010-12-08 12:00:00	AMZN	Stock	8.8305	8.84	8.78	8.795	6148480.0
2010-12-08 13:00:00	AMZN	Stock	8.7925	8.81	8.776	8.801	5470600.0
2010-12-08 14:00:00	AMZN	Stock	8.801	8.826	8.785	8.7985	6534620.0
2010-12-08 15:00:00	AMZN	Stock	8.7975	8.823	8.763	8.8145	14348060.0
2010-12-08 16:00:00	AMZN	Stock	8.81	8.825	8.7835	8.8145	2636820.0
2010-12-08 17:00:00	AMZN	Stock	8.8145	8.8175	8.8145	8.815	22500.0

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

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