PREVIEW / stock_1hour / 2012-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-18.parquet
  size:    934 KB
  rows:    44,087
  symbols: 3,521

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
2012-01-18 04:00:00	AAPL	Stock	15.1921	15.2218	15.1921	15.2218	25200.0
2012-01-18 05:00:00	AAPL	Stock	15.2321	15.25	15.2321	15.25	42000.0
2012-01-18 06:00:00	AAPL	Stock	15.2321	15.2321	15.2036	15.2036	25200.0
2012-01-18 07:00:00	AAPL	Stock	15.2143	15.2321	15.1964	15.2143	153132.0
2012-01-18 08:00:00	AAPL	Stock	15.2093	15.2464	15.1289	15.2193	2263436.0
2012-01-18 09:00:00	AAPL	Stock	15.2182	15.2886	15.2146	15.2471	63976584.0
2012-01-18 10:00:00	AAPL	Stock	15.2474	15.2821	15.2411	15.2557	45840732.0
2012-01-18 11:00:00	AAPL	Stock	15.2554	15.2675	15.2414	15.2557	24509660.0
2012-01-18 12:00:00	AAPL	Stock	15.2554	15.3007	15.2464	15.2957	32488624.0
2012-01-18 13:00:00	AAPL	Stock	15.2943	15.3021	15.2804	15.2879	19054224.0
2012-01-18 14:00:00	AAPL	Stock	15.2871	15.3057	15.2843	15.3029	18695292.0
2012-01-18 15:00:00	AAPL	Stock	15.3032	15.3382	15.3032	15.3246	51633876.0
2012-01-18 16:00:00	AAPL	Stock	15.3254	15.3375	15.1679	15.3364	14493528.0
2012-01-18 17:00:00	AAPL	Stock	15.3368	15.3632	15.3321	15.3539	1023652.0
2012-01-18 18:00:00	AAPL	Stock	15.3536	15.3661	15.3254	15.3525	208264.0
2012-01-18 19:00:00	AAPL	Stock	15.3489	15.3607	15.3311	15.3607	288596.0
2012-01-18 07:00:00	MSFT	Stock	28.38	28.38	28.3	28.35	1100.0
2012-01-18 08:00:00	MSFT	Stock	28.36	28.42	28.32	28.32	23720.0
2012-01-18 09:00:00	MSFT	Stock	28.3	28.4	28.11	28.18	10808284.0
2012-01-18 10:00:00	MSFT	Stock	28.18	28.25	28.08	28.172	9796670.0
2012-01-18 11:00:00	MSFT	Stock	28.17	28.19	27.97	28.05	10470146.0
2012-01-18 12:00:00	MSFT	Stock	28.04	28.23	28.02	28.2	7451378.0
2012-01-18 13:00:00	MSFT	Stock	28.2	28.22	28.07	28.07	4779339.0
2012-01-18 14:00:00	MSFT	Stock	28.08	28.189	28.07	28.145	5791589.0
2012-01-18 15:00:00	MSFT	Stock	28.145	28.23	28.1	28.23	11159636.0
2012-01-18 16:00:00	MSFT	Stock	28.22	28.26	28.0	28.25	3118435.0
2012-01-18 17:00:00	MSFT	Stock	28.25	28.32	28.25	28.3	4065.0
2012-01-18 18:00:00	MSFT	Stock	28.25	28.25	28.23	28.25	9855.0
2012-01-18 19:00:00	MSFT	Stock	28.25	28.32	28.25	28.32	16876.0
2012-01-18 08:00:00	NVDA	Stock	0.34	0.3438	0.34	0.3438	639600.0
2012-01-18 09:00:00	NVDA	Stock	0.344	0.3478	0.3425	0.3475	78562000.0
2012-01-18 10:00:00	NVDA	Stock	0.3478	0.3488	0.3465	0.3485	89446480.0
2012-01-18 11:00:00	NVDA	Stock	0.3485	0.3522	0.3482	0.3502	135814960.0
2012-01-18 12:00:00	NVDA	Stock	0.3502	0.3508	0.3493	0.3506	62586280.0
2012-01-18 13:00:00	NVDA	Stock	0.3508	0.3508	0.349	0.3495	50686960.0
2012-01-18 14:00:00	NVDA	Stock	0.3495	0.3498	0.3482	0.3494	52708280.0
2012-01-18 15:00:00	NVDA	Stock	0.3495	0.35	0.3488	0.3495	124542080.0
2012-01-18 16:00:00	NVDA	Stock	0.3493	0.3505	0.338	0.3505	4012400.0
2012-01-18 17:00:00	NVDA	Stock	0.351	0.351	0.3502	0.351	108000.0
2012-01-18 18:00:00	NVDA	Stock	0.351	0.3518	0.3502	0.3502	84400.0
2012-01-18 19:00:00	NVDA	Stock	0.3515	0.352	0.3513	0.3513	219400.0
2012-01-18 07:00:00	AMZN	Stock	9.1	9.122	9.0875	9.122	16000.0
2012-01-18 08:00:00	AMZN	Stock	9.12	9.12	9.0945	9.114	82220.0
2012-01-18 09:00:00	AMZN	Stock	9.111	9.195	9.0195	9.195	15577480.0
2012-01-18 10:00:00	AMZN	Stock	9.1935	9.3175	9.181	9.2885	25578560.0
2012-01-18 11:00:00	AMZN	Stock	9.286	9.3595	9.269	9.315	16074880.0
2012-01-18 12:00:00	AMZN	Stock	9.3145	9.4425	9.3105	9.4165	17511760.0
2012-01-18 13:00:00	AMZN	Stock	9.4165	9.473	9.3875	9.463	15954440.0
2012-01-18 14:00:00	AMZN	Stock	9.4605	9.5125	9.449	9.5	21409000.0
2012-01-18 15:00:00	AMZN	Stock	9.5	9.502	9.43	9.469	30625760.0

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

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