PREVIEW / stock_1hour / 2010-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-24.parquet
  size:    927 KB
  rows:    44,761
  symbols: 3,510

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-24 04:00:00	AAPL	Stock	11.025	11.0357	10.9475	10.9643	56000.0
2010-11-24 05:00:00	AAPL	Stock	10.9643	10.9893	10.9643	10.9893	30800.0
2010-11-24 06:00:00	AAPL	Stock	11.0036	11.0461	11.0036	11.0261	89600.0
2010-11-24 07:00:00	AAPL	Stock	11.025	11.075	11.025	11.0718	556248.0
2010-11-24 08:00:00	AAPL	Stock	11.0746	11.1804	11.0671	11.1504	6912416.0
2010-11-24 09:00:00	AAPL	Stock	11.1521	11.1732	11.1339	11.1568	71619268.0
2010-11-24 10:00:00	AAPL	Stock	11.1564	11.25	11.145	11.2429	110265092.0
2010-11-24 11:00:00	AAPL	Stock	11.2441	11.2464	11.2221	11.2364	41505884.0
2010-11-24 12:00:00	AAPL	Stock	11.2346	11.2446	11.2303	11.2418	27141912.0
2010-11-24 13:00:00	AAPL	Stock	11.2418	11.25	11.2386	11.2479	29725052.0
2010-11-24 14:00:00	AAPL	Stock	11.2475	11.2643	11.2321	11.2507	42302176.0
2010-11-24 15:00:00	AAPL	Stock	11.2504	11.2589	11.2321	11.2421	60687900.0
2010-11-24 16:00:00	AAPL	Stock	11.2421	11.2517	11.1467	11.2386	17889116.0
2010-11-24 17:00:00	AAPL	Stock	11.2414	11.2471	11.2357	11.2429	799904.0
2010-11-24 18:00:00	AAPL	Stock	11.2429	11.2446	11.2379	11.2382	227360.0
2010-11-24 19:00:00	AAPL	Stock	11.2411	11.25	11.2379	11.25	350140.0
2010-11-24 04:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	100.0
2010-11-24 05:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	100.0
2010-11-24 06:00:00	MSFT	Stock	25.05	25.17	25.05	25.11	350.0
2010-11-24 07:00:00	MSFT	Stock	25.11	25.18	25.11	25.18	1450.0
2010-11-24 08:00:00	MSFT	Stock	25.18	25.3	25.18	25.23	63954.0
2010-11-24 09:00:00	MSFT	Stock	25.23	25.35	25.16	25.215	8645011.0
2010-11-24 10:00:00	MSFT	Stock	25.21	25.41	25.175	25.389	9931147.0
2010-11-24 11:00:00	MSFT	Stock	25.385	25.44	25.35	25.41	7981487.0
2010-11-24 12:00:00	MSFT	Stock	25.405	25.45	25.39	25.41	3973420.0
2010-11-24 13:00:00	MSFT	Stock	25.4	25.44	25.35	25.38	5549149.0
2010-11-24 14:00:00	MSFT	Stock	25.385	25.4	25.33	25.36	4051085.0
2010-11-24 15:00:00	MSFT	Stock	25.36	25.4	25.305	25.37	10058970.0
2010-11-24 16:00:00	MSFT	Stock	25.37	25.4	25.11	25.35	2978064.0
2010-11-24 17:00:00	MSFT	Stock	25.35	25.44	25.35	25.39	108898.0
2010-11-24 18:00:00	MSFT	Stock	25.39	25.39	25.36	25.36	16872.0
2010-11-24 19:00:00	MSFT	Stock	25.39	25.39	25.39	25.39	1100.0
2010-11-24 09:00:00	NVDA	Stock	0.342	0.3438	0.3393	0.3433	55625480.0
2010-11-24 10:00:00	NVDA	Stock	0.343	0.3453	0.342	0.3448	70691640.0
2010-11-24 11:00:00	NVDA	Stock	0.345	0.3455	0.342	0.3428	53736680.0
2010-11-24 12:00:00	NVDA	Stock	0.3428	0.3438	0.3422	0.3433	35172960.0
2010-11-24 13:00:00	NVDA	Stock	0.3433	0.344	0.3426	0.3426	20401720.0
2010-11-24 14:00:00	NVDA	Stock	0.3426	0.3435	0.342	0.3423	32739240.0
2010-11-24 15:00:00	NVDA	Stock	0.3425	0.3445	0.3422	0.344	107978640.0
2010-11-24 16:00:00	NVDA	Stock	0.344	0.3475	0.3435	0.3442	6283120.0
2010-11-24 17:00:00	NVDA	Stock	0.3442	0.3442	0.3442	0.3442	342000.0
2010-11-24 18:00:00	NVDA	Stock	0.3462	0.3462	0.3462	0.3462	89240.0
2010-11-24 05:00:00	AMZN	Stock	8.387	8.4175	8.387	8.4175	8000.0
2010-11-24 06:00:00	AMZN	Stock	8.43	8.435	8.4175	8.425	16000.0
2010-11-24 07:00:00	AMZN	Stock	8.534	8.5385	8.494	8.515	60400.0
2010-11-24 08:00:00	AMZN	Stock	8.51	8.595	8.51	8.545	1482140.0
2010-11-24 09:00:00	AMZN	Stock	8.5505	8.7725	8.54	8.7443	47285360.0
2010-11-24 10:00:00	AMZN	Stock	8.7415	8.858	8.719	8.8485	48237840.0
2010-11-24 11:00:00	AMZN	Stock	8.846	8.8695	8.812	8.829	21775080.0
2010-11-24 12:00:00	AMZN	Stock	8.8295	8.855	8.8255	8.8485	12454140.0

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

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