PREVIEW / stock_1hour / 2010-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-15.parquet
  size:    924 KB
  rows:    43,894
  symbols: 3,476

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-06-15 04:00:00	AAPL	Stock	9.0814	9.1	9.0789	9.0961	75600.0
2010-06-15 05:00:00	AAPL	Stock	9.0961	9.1143	9.0961	9.1143	18200.0
2010-06-15 06:00:00	AAPL	Stock	9.1461	9.1461	9.1461	9.1461	2800.0
2010-06-15 07:00:00	AAPL	Stock	9.1429	9.15	9.1346	9.1411	130340.0
2010-06-15 08:00:00	AAPL	Stock	9.1429	9.1429	9.0971	9.1193	2469544.0
2010-06-15 09:00:00	AAPL	Stock	9.1182	9.2321	9.1182	9.2239	78598800.0
2010-06-15 10:00:00	AAPL	Stock	9.2218	9.2282	9.1843	9.2175	81579540.0
2010-06-15 11:00:00	AAPL	Stock	9.2175	9.2218	9.1639	9.2179	58685144.0
2010-06-15 12:00:00	AAPL	Stock	9.2175	9.2311	9.2018	9.2231	46497360.0
2010-06-15 13:00:00	AAPL	Stock	9.2232	9.2475	9.2071	9.2446	55993896.0
2010-06-15 14:00:00	AAPL	Stock	9.2446	9.2661	9.2404	9.2454	62041980.0
2010-06-15 15:00:00	AAPL	Stock	9.2439	9.2804	9.2357	9.2786	102412100.0
2010-06-15 16:00:00	AAPL	Stock	9.275	9.2815	9.1455	9.2714	25385752.0
2010-06-15 17:00:00	AAPL	Stock	9.2707	9.2764	9.2696	9.2764	275212.0
2010-06-15 18:00:00	AAPL	Stock	9.2736	9.2746	9.25	9.2575	550312.0
2010-06-15 19:00:00	AAPL	Stock	9.2571	9.2571	9.2325	9.2496	891688.0
2010-06-15 07:00:00	MSFT	Stock	25.75	25.75	25.63	25.63	2000.0
2010-06-15 08:00:00	MSFT	Stock	25.69	25.74	25.534	25.71	44926.0
2010-06-15 09:00:00	MSFT	Stock	25.7	26.05	25.67	26.01	6944192.0
2010-06-15 10:00:00	MSFT	Stock	26.01	26.13	25.92	26.05	9349808.0
2010-06-15 11:00:00	MSFT	Stock	26.04	26.4	26.02	26.36	13432967.0
2010-06-15 12:00:00	MSFT	Stock	26.36	26.45	26.32	26.38	7852747.0
2010-06-15 13:00:00	MSFT	Stock	26.38	26.45	26.25	26.35	5163403.0
2010-06-15 14:00:00	MSFT	Stock	26.34	26.55	26.34	26.47	8744227.0
2010-06-15 15:00:00	MSFT	Stock	26.475	26.65	26.47	26.58	19354784.0
2010-06-15 16:00:00	MSFT	Stock	26.58	26.66	26.293	26.58	8329516.0
2010-06-15 17:00:00	MSFT	Stock	26.58	26.58	26.48	26.49	16782.0
2010-06-15 18:00:00	MSFT	Stock	26.52	26.58	26.5	26.5	11536.0
2010-06-15 19:00:00	MSFT	Stock	26.51	26.51	26.48	26.48	2604.0
2010-06-15 08:00:00	NVDA	Stock	0.2875	0.29	0.2875	0.2888	421040.0
2010-06-15 09:00:00	NVDA	Stock	0.2885	0.292	0.2868	0.2915	35575760.0
2010-06-15 10:00:00	NVDA	Stock	0.2915	0.2942	0.2902	0.2942	90846120.0
2010-06-15 11:00:00	NVDA	Stock	0.294	0.2945	0.2932	0.2942	53247880.0
2010-06-15 12:00:00	NVDA	Stock	0.2945	0.295	0.2915	0.293	72388160.0
2010-06-15 13:00:00	NVDA	Stock	0.293	0.295	0.2918	0.2949	45431440.0
2010-06-15 14:00:00	NVDA	Stock	0.2949	0.2978	0.2948	0.2965	85902760.0
2010-06-15 15:00:00	NVDA	Stock	0.2965	0.2995	0.296	0.2982	126508520.0
2010-06-15 16:00:00	NVDA	Stock	0.298	0.3	0.295	0.2968	16067440.0
2010-06-15 17:00:00	NVDA	Stock	0.298	0.298	0.2975	0.2975	100000.0
2010-06-15 18:00:00	NVDA	Stock	0.2978	0.2978	0.2975	0.2975	75200.0
2010-06-15 19:00:00	NVDA	Stock	0.2975	0.2975	0.2958	0.2958	28800.0
2010-06-15 05:00:00	AMZN	Stock	6.1995	6.1995	6.1995	6.1995	4000.0
2010-06-15 07:00:00	AMZN	Stock	6.2375	6.252	6.2375	6.252	5600.0
2010-06-15 08:00:00	AMZN	Stock	6.215	6.215	6.14	6.14	501820.0
2010-06-15 09:00:00	AMZN	Stock	6.14	6.2825	6.125	6.2615	15347700.0
2010-06-15 10:00:00	AMZN	Stock	6.259	6.2665	6.201	6.251	14117400.0
2010-06-15 11:00:00	AMZN	Stock	6.254	6.2825	6.2375	6.2805	10293640.0
2010-06-15 12:00:00	AMZN	Stock	6.281	6.3045	6.277	6.2974	7831000.0
2010-06-15 13:00:00	AMZN	Stock	6.2985	6.318	6.273	6.312	9323280.0
2010-06-15 14:00:00	AMZN	Stock	6.3125	6.318	6.2815	6.284	8642720.0

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

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