PREVIEW / stock_1hour / 2010-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-25.parquet
  size:    910 KB
  rows:    43,584
  symbols: 3,451

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-01-25 04:00:00	AAPL	Stock	7.175	7.225	7.175	7.225	22400.0
2010-01-25 05:00:00	AAPL	Stock	7.2354	7.2568	7.2321	7.2446	141092.0
2010-01-25 06:00:00	AAPL	Stock	7.25	7.25	7.2168	7.2196	198016.0
2010-01-25 07:00:00	AAPL	Stock	7.2164	7.2282	7.1825	7.1946	1432900.0
2010-01-25 08:00:00	AAPL	Stock	7.1904	7.2339	7.1896	7.2214	8323840.0
2010-01-25 09:00:00	AAPL	Stock	7.2196	7.2686	7.2054	7.2646	156647708.0
2010-01-25 10:00:00	AAPL	Stock	7.2671	7.2807	7.2054	7.2707	138782084.0
2010-01-25 11:00:00	AAPL	Stock	7.2711	7.2739	7.1496	7.1761	132580280.0
2010-01-25 12:00:00	AAPL	Stock	7.1764	7.2411	7.1761	7.2357	76145776.0
2010-01-25 13:00:00	AAPL	Stock	7.2361	7.2707	7.2225	7.2611	71478540.0
2010-01-25 14:00:00	AAPL	Stock	7.2621	7.3029	7.2511	7.3025	102761232.0
2010-01-25 15:00:00	AAPL	Stock	7.3025	7.3107	7.2321	7.2321	193526984.0
2010-01-25 16:00:00	AAPL	Stock	7.2529	7.4404	6.9714	7.4	60517772.0
2010-01-25 17:00:00	AAPL	Stock	7.2185	7.4011	7.1064	7.3393	90976396.0
2010-01-25 18:00:00	AAPL	Stock	7.34	7.3529	7.2525	7.3257	9531984.0
2010-01-25 19:00:00	AAPL	Stock	7.3232	7.3246	7.3018	7.3214	3961916.0
2010-01-25 05:00:00	MSFT	Stock	29.06	29.2	29.06	29.2	5200.0
2010-01-25 06:00:00	MSFT	Stock	29.2	29.25	29.2	29.25	1152.0
2010-01-25 07:00:00	MSFT	Stock	29.21	29.25	29.2	29.23	11300.0
2010-01-25 08:00:00	MSFT	Stock	29.22	29.29	28.96	29.27	55390.0
2010-01-25 09:00:00	MSFT	Stock	29.3	29.42	29.1	29.35	8274954.0
2010-01-25 10:00:00	MSFT	Stock	29.35	29.66	29.27	29.51	13217903.0
2010-01-25 11:00:00	MSFT	Stock	29.502	29.51	29.17	29.32	8680133.0
2010-01-25 12:00:00	MSFT	Stock	29.32	29.515	29.31	29.43	4674019.0
2010-01-25 13:00:00	MSFT	Stock	29.43	29.482	29.35	29.39	4487799.0
2010-01-25 14:00:00	MSFT	Stock	29.4	29.52	29.36	29.495	5718257.0
2010-01-25 15:00:00	MSFT	Stock	29.5	29.55	29.263	29.29	11040682.0
2010-01-25 16:00:00	MSFT	Stock	29.29	29.55	28.943	29.36	6280153.0
2010-01-25 17:00:00	MSFT	Stock	29.26	29.43	29.26	29.39	189096.0
2010-01-25 18:00:00	MSFT	Stock	29.42	29.42	29.35	29.4	7066.0
2010-01-25 19:00:00	MSFT	Stock	29.41	29.43	29.37	29.37	1300.0
2010-01-25 06:00:00	NVDA	Stock	0.4182	0.4182	0.4182	0.4182	28000.0
2010-01-25 08:00:00	NVDA	Stock	0.4115	0.4178	0.41	0.4165	1570080.0
2010-01-25 09:00:00	NVDA	Stock	0.4152	0.4253	0.4152	0.4242	121763840.0
2010-01-25 10:00:00	NVDA	Stock	0.4242	0.4265	0.4182	0.4215	125511680.0
2010-01-25 11:00:00	NVDA	Stock	0.4213	0.4215	0.4152	0.4188	99626280.0
2010-01-25 12:00:00	NVDA	Stock	0.4188	0.4213	0.416	0.4205	77783720.0
2010-01-25 13:00:00	NVDA	Stock	0.4205	0.4225	0.4192	0.4202	43975760.0
2010-01-25 14:00:00	NVDA	Stock	0.4205	0.4218	0.42	0.4205	42448080.0
2010-01-25 15:00:00	NVDA	Stock	0.4205	0.4213	0.4178	0.4185	117484960.0
2010-01-25 16:00:00	NVDA	Stock	0.4185	0.4298	0.4115	0.419	5442680.0
2010-01-25 17:00:00	NVDA	Stock	0.4175	0.4175	0.4175	0.4175	40000.0
2010-01-25 06:00:00	AMZN	Stock	6.1195	6.12	6.1195	6.1195	9460.0
2010-01-25 07:00:00	AMZN	Stock	6.1195	6.15	6.1195	6.131	161840.0
2010-01-25 08:00:00	AMZN	Stock	6.112	6.1645	6.0715	6.1215	556900.0
2010-01-25 09:00:00	AMZN	Stock	6.124	6.14	5.9305	5.9495	47963460.0
2010-01-25 10:00:00	AMZN	Stock	5.948	6.02	5.906	5.9945	59801140.0
2010-01-25 11:00:00	AMZN	Stock	5.9945	5.9955	5.914	5.97	27838820.0
2010-01-25 12:00:00	AMZN	Stock	5.9715	5.984	5.9485	5.9605	12824600.0
2010-01-25 13:00:00	AMZN	Stock	5.96	6.029	5.9425	6.013	25975480.0

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

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