PREVIEW / stock_1hour / 2010-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-29.parquet
  size:    904 KB
  rows:    42,683
  symbols: 3,477

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-09-29 05:00:00	AAPL	Stock	10.2682	10.2682	10.2607	10.2607	16800.0
2010-09-29 06:00:00	AAPL	Stock	10.2607	10.2643	10.2607	10.2643	22400.0
2010-09-29 07:00:00	AAPL	Stock	10.3	10.3	10.2589	10.2654	64400.0
2010-09-29 08:00:00	AAPL	Stock	10.2607	10.3325	10.2607	10.2811	5660284.0
2010-09-29 09:00:00	AAPL	Stock	10.2804	10.3504	10.2371	10.3029	82971112.0
2010-09-29 10:00:00	AAPL	Stock	10.2975	10.3386	10.2598	10.2956	81271848.0
2010-09-29 11:00:00	AAPL	Stock	10.2946	10.3282	10.28	10.3014	43251684.0
2010-09-29 12:00:00	AAPL	Stock	10.3018	10.3093	10.2646	10.2771	52823708.0
2010-09-29 13:00:00	AAPL	Stock	10.2782	10.2882	10.2236	10.25	59317104.0
2010-09-29 14:00:00	AAPL	Stock	10.2496	10.2857	10.2429	10.2775	41533912.0
2010-09-29 15:00:00	AAPL	Stock	10.2782	10.2804	10.2143	10.2621	91385532.0
2010-09-29 16:00:00	AAPL	Stock	10.2618	10.3094	10.2395	10.2632	9307424.0
2010-09-29 17:00:00	AAPL	Stock	10.2639	10.2819	10.2525	10.2554	339752.0
2010-09-29 18:00:00	AAPL	Stock	10.2589	10.2632	10.25	10.25	187516.0
2010-09-29 19:00:00	AAPL	Stock	10.2529	10.2529	10.2396	10.2407	266000.0
2010-09-29 07:00:00	MSFT	Stock	24.71	24.71	24.71	24.71	100.0
2010-09-29 08:00:00	MSFT	Stock	24.7	24.7	24.65	24.65	19973.0
2010-09-29 09:00:00	MSFT	Stock	24.65	24.68	24.45	24.49	5480827.0
2010-09-29 10:00:00	MSFT	Stock	24.493	24.52	24.4	24.475	6826567.0
2010-09-29 11:00:00	MSFT	Stock	24.475	24.58	24.43	24.565	5286683.0
2010-09-29 12:00:00	MSFT	Stock	24.565	24.59	24.5	24.509	4601282.0
2010-09-29 13:00:00	MSFT	Stock	24.5	24.61	24.49	24.585	4103747.0
2010-09-29 14:00:00	MSFT	Stock	24.59	24.65	24.49	24.605	4559547.0
2010-09-29 15:00:00	MSFT	Stock	24.61	24.61	24.415	24.48	10730864.0
2010-09-29 16:00:00	MSFT	Stock	24.49	24.713	24.447	24.575	2133372.0
2010-09-29 17:00:00	MSFT	Stock	24.52	24.52	24.47	24.47	1483.0
2010-09-29 18:00:00	MSFT	Stock	24.47	24.52	24.47	24.52	40909.0
2010-09-29 19:00:00	MSFT	Stock	24.49	24.49	24.49	24.49	200.0
2010-09-29 08:00:00	NVDA	Stock	0.2988	0.3	0.2945	0.2962	400000.0
2010-09-29 09:00:00	NVDA	Stock	0.2962	0.3058	0.295	0.3032	150598040.0
2010-09-29 10:00:00	NVDA	Stock	0.3032	0.304	0.2975	0.2985	226147080.0
2010-09-29 11:00:00	NVDA	Stock	0.2985	0.2992	0.2958	0.2973	138612800.0
2010-09-29 12:00:00	NVDA	Stock	0.2975	0.2998	0.2968	0.2992	70444760.0
2010-09-29 13:00:00	NVDA	Stock	0.299	0.2995	0.2958	0.2975	120789200.0
2010-09-29 14:00:00	NVDA	Stock	0.2978	0.2982	0.297	0.2982	74193440.0
2010-09-29 15:00:00	NVDA	Stock	0.298	0.2985	0.2938	0.2968	158873120.0
2010-09-29 16:00:00	NVDA	Stock	0.297	0.2989	0.2959	0.2978	21393440.0
2010-09-29 18:00:00	NVDA	Stock	0.2968	0.2968	0.2965	0.2965	60000.0
2010-09-29 08:00:00	AMZN	Stock	7.9805	8.0	7.964	7.964	73680.0
2010-09-29 09:00:00	AMZN	Stock	7.971	8.089	7.9175	8.0614	24876460.0
2010-09-29 10:00:00	AMZN	Stock	8.0595	8.087	7.993	8.012	23541300.0
2010-09-29 11:00:00	AMZN	Stock	8.0125	8.03	7.965	7.983	14649340.0
2010-09-29 12:00:00	AMZN	Stock	7.9845	8.0095	7.9535	7.969	13198800.0
2010-09-29 13:00:00	AMZN	Stock	7.969	7.9705	7.903	7.928	18049820.0
2010-09-29 14:00:00	AMZN	Stock	7.9265	7.97	7.9265	7.958	13432800.0
2010-09-29 15:00:00	AMZN	Stock	7.9565	7.959	7.8875	7.9495	34233560.0
2010-09-29 16:00:00	AMZN	Stock	7.95	8.0533	7.9088	7.9565	1655220.0
2010-09-29 17:00:00	AMZN	Stock	7.95	7.95	7.9445	7.95	14700.0
2010-09-29 18:00:00	AMZN	Stock	7.9495	7.9565	7.9495	7.9565	31960.0
2010-09-29 19:00:00	AMZN	Stock	7.95	7.9565	7.95	7.95	29560.0

> showing 50 of 42,683 rows — these rows as CSV

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