PREVIEW / stock_1hour / 2010-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-22.parquet
  size:    937 KB
  rows:    44,255
  symbols: 3,473

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-04-22 04:00:00	AAPL	Stock	9.2689	9.2732	9.2504	9.2575	187600.0
2010-04-22 05:00:00	AAPL	Stock	9.2575	9.2593	9.2146	9.2146	103600.0
2010-04-22 06:00:00	AAPL	Stock	9.2318	9.2318	9.2071	9.2143	82600.0
2010-04-22 07:00:00	AAPL	Stock	9.2211	9.2321	9.2107	9.2214	370580.0
2010-04-22 08:00:00	AAPL	Stock	9.2196	9.2432	9.2129	9.2264	1757308.0
2010-04-22 09:00:00	AAPL	Stock	9.2282	9.2339	9.15	9.2054	99740788.0
2010-04-22 10:00:00	AAPL	Stock	9.2054	9.2529	9.1814	9.2239	102355512.0
2010-04-22 11:00:00	AAPL	Stock	9.2236	9.2298	9.2039	9.2164	44813748.0
2010-04-22 12:00:00	AAPL	Stock	9.2179	9.2493	9.2086	9.2393	40968956.0
2010-04-22 13:00:00	AAPL	Stock	9.2393	9.3871	9.2352	9.385	120825768.0
2010-04-22 14:00:00	AAPL	Stock	9.3864	9.4811	9.3807	9.4704	168486976.0
2010-04-22 15:00:00	AAPL	Stock	9.4707	9.5268	9.4643	9.5118	194707464.0
2010-04-22 16:00:00	AAPL	Stock	9.5118	9.5179	9.2116	9.4825	11116448.0
2010-04-22 17:00:00	AAPL	Stock	9.4846	9.5125	9.2257	9.5082	889532.0
2010-04-22 18:00:00	AAPL	Stock	9.5018	9.5318	9.4989	9.5143	886928.0
2010-04-22 19:00:00	AAPL	Stock	9.5146	9.5179	9.5071	9.5071	435596.0
2010-04-22 07:00:00	MSFT	Stock	31.22	31.23	31.16	31.23	7915.0
2010-04-22 08:00:00	MSFT	Stock	31.2	31.286	31.11	31.14	101201.0
2010-04-22 09:00:00	MSFT	Stock	31.13	31.24	30.9	31.08	6343555.0
2010-04-22 10:00:00	MSFT	Stock	31.08	31.25	31.03	31.2	9691732.0
2010-04-22 11:00:00	MSFT	Stock	31.19	31.23	30.95	30.99	7416733.0
2010-04-22 12:00:00	MSFT	Stock	31.0	31.12	30.95	31.1	5775513.0
2010-04-22 13:00:00	MSFT	Stock	31.09	31.34	31.08	31.331	7295607.0
2010-04-22 14:00:00	MSFT	Stock	31.34	31.408	31.23	31.27	10394493.0
2010-04-22 15:00:00	MSFT	Stock	31.268	31.53	31.23	31.37	21525416.0
2010-04-22 16:00:00	MSFT	Stock	31.39	31.54	29.85	30.08	12180090.0
2010-04-22 17:00:00	MSFT	Stock	30.08	30.55	30.06	30.42	2113146.0
2010-04-22 18:00:00	MSFT	Stock	30.43	30.45	30.28	30.28	288025.0
2010-04-22 19:00:00	MSFT	Stock	30.28	30.36	30.2	30.25	134363.0
2010-04-22 20:00:00	MSFT	Stock	30.98	30.98	30.98	30.98	3081.0
2010-04-22 08:00:00	NVDA	Stock	0.4157	0.4157	0.4108	0.4108	434880.0
2010-04-22 09:00:00	NVDA	Stock	0.4108	0.4112	0.4025	0.4062	112289480.0
2010-04-22 10:00:00	NVDA	Stock	0.4062	0.4125	0.4048	0.41	144172760.0
2010-04-22 11:00:00	NVDA	Stock	0.41	0.411	0.4075	0.4078	58807000.0
2010-04-22 12:00:00	NVDA	Stock	0.4079	0.4118	0.4078	0.4102	55815120.0
2010-04-22 13:00:00	NVDA	Stock	0.4104	0.4148	0.41	0.4145	70843480.0
2010-04-22 14:00:00	NVDA	Stock	0.4144	0.4162	0.4128	0.4133	92528400.0
2010-04-22 15:00:00	NVDA	Stock	0.4135	0.418	0.4134	0.4165	107852960.0
2010-04-22 16:00:00	NVDA	Stock	0.4168	0.4179	0.4107	0.4134	12881600.0
2010-04-22 17:00:00	NVDA	Stock	0.4134	0.4134	0.4134	0.4134	5520.0
2010-04-22 18:00:00	NVDA	Stock	0.4165	0.4165	0.4165	0.4165	8000.0
2010-04-22 19:00:00	NVDA	Stock	0.415	0.415	0.415	0.415	20000.0
2010-04-22 04:00:00	AMZN	Stock	7.265	7.2655	7.265	7.2655	6000.0
2010-04-22 06:00:00	AMZN	Stock	7.3105	7.3105	7.3105	7.3105	6000.0
2010-04-22 07:00:00	AMZN	Stock	7.311	7.311	7.2625	7.2625	90200.0
2010-04-22 08:00:00	AMZN	Stock	7.265	7.335	7.2525	7.3345	252000.0
2010-04-22 09:00:00	AMZN	Stock	7.3325	7.4135	7.294	7.385	33850880.0
2010-04-22 10:00:00	AMZN	Stock	7.3825	7.438	7.3335	7.3775	32874080.0
2010-04-22 11:00:00	AMZN	Stock	7.3785	7.39	7.34	7.3762	17316460.0
2010-04-22 12:00:00	AMZN	Stock	7.3785	7.428	7.369	7.422	13344300.0

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

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