PREVIEW / stock_1hour / 2010-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-23.parquet
  size:    884 KB
  rows:    42,334
  symbols: 3,457

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-07-23 04:00:00	AAPL	Stock	9.2482	9.2921	9.2482	9.2921	26516.0
2010-07-23 05:00:00	AAPL	Stock	9.2957	9.3193	9.2957	9.3175	8400.0
2010-07-23 06:00:00	AAPL	Stock	9.3143	9.3161	9.2964	9.2964	15148.0
2010-07-23 07:00:00	AAPL	Stock	9.2961	9.3179	9.2929	9.3	490476.0
2010-07-23 08:00:00	AAPL	Stock	9.2986	9.2986	9.1582	9.2107	3891608.0
2010-07-23 09:00:00	AAPL	Stock	9.2104	9.2643	9.1607	9.1618	70982016.0
2010-07-23 10:00:00	AAPL	Stock	9.1636	9.2589	9.1529	9.2264	90372604.0
2010-07-23 11:00:00	AAPL	Stock	9.2257	9.2464	9.1939	9.2286	48278384.0
2010-07-23 12:00:00	AAPL	Stock	9.2289	9.2571	9.1807	9.2296	58190160.0
2010-07-23 13:00:00	AAPL	Stock	9.2304	9.2814	9.215	9.2743	61062652.0
2010-07-23 14:00:00	AAPL	Stock	9.2743	9.2993	9.2543	9.2814	76652772.0
2010-07-23 15:00:00	AAPL	Stock	9.2811	9.2961	9.2593	9.2875	102824484.0
2010-07-23 16:00:00	AAPL	Stock	9.2876	9.2891	9.1786	9.2854	15647436.0
2010-07-23 17:00:00	AAPL	Stock	9.285	9.2875	9.2764	9.2818	284340.0
2010-07-23 18:00:00	AAPL	Stock	9.2771	9.2875	9.2771	9.2854	237412.0
2010-07-23 19:00:00	AAPL	Stock	9.2854	9.2893	9.2829	9.2832	89684.0
2010-07-23 04:00:00	MSFT	Stock	25.89	25.94	25.89	25.94	300.0
2010-07-23 06:00:00	MSFT	Stock	25.94	25.94	25.94	25.94	100.0
2010-07-23 07:00:00	MSFT	Stock	25.94	26.16	25.88	26.09	208929.0
2010-07-23 08:00:00	MSFT	Stock	26.08	26.13	25.84	26.08	1892510.0
2010-07-23 09:00:00	MSFT	Stock	26.09	26.09	25.39	25.39	21496181.0
2010-07-23 10:00:00	MSFT	Stock	25.39	25.74	25.37	25.622	14404594.0
2010-07-23 11:00:00	MSFT	Stock	25.621	25.65	25.38	25.5	12992508.0
2010-07-23 12:00:00	MSFT	Stock	25.5	25.58	25.25	25.401	12677293.0
2010-07-23 13:00:00	MSFT	Stock	25.41	25.62	25.36	25.5	9378745.0
2010-07-23 14:00:00	MSFT	Stock	25.505	25.64	25.49	25.57	8597799.0
2010-07-23 15:00:00	MSFT	Stock	25.57	25.8	25.447	25.8	22118869.0
2010-07-23 16:00:00	MSFT	Stock	25.8	25.83	25.488	25.82	3337889.0
2010-07-23 17:00:00	MSFT	Stock	25.82	25.85	25.81	25.85	15335.0
2010-07-23 18:00:00	MSFT	Stock	25.82	25.84	25.81	25.83	11411.0
2010-07-23 19:00:00	MSFT	Stock	25.83	25.83	25.8	25.82	10381.0
2010-07-23 08:00:00	NVDA	Stock	0.2625	0.265	0.2625	0.2628	229680.0
2010-07-23 09:00:00	NVDA	Stock	0.2628	0.2658	0.259	0.259	82545600.0
2010-07-23 10:00:00	NVDA	Stock	0.2591	0.2618	0.2583	0.2608	129225720.0
2010-07-23 11:00:00	NVDA	Stock	0.261	0.2615	0.2594	0.2601	83273520.0
2010-07-23 12:00:00	NVDA	Stock	0.2603	0.261	0.2565	0.2576	115733280.0
2010-07-23 13:00:00	NVDA	Stock	0.2578	0.2612	0.2568	0.2594	123933920.0
2010-07-23 14:00:00	NVDA	Stock	0.2594	0.2604	0.259	0.2596	108666560.0
2010-07-23 15:00:00	NVDA	Stock	0.2598	0.2603	0.2575	0.259	162498800.0
2010-07-23 16:00:00	NVDA	Stock	0.259	0.2598	0.258	0.2595	3025880.0
2010-07-23 17:00:00	NVDA	Stock	0.2598	0.26	0.2585	0.2585	648720.0
2010-07-23 18:00:00	NVDA	Stock	0.259	0.259	0.258	0.259	234000.0
2010-07-23 19:00:00	NVDA	Stock	0.2588	0.2588	0.2563	0.258	1121200.0
2010-07-23 04:00:00	AMZN	Stock	5.4195	5.447	5.415	5.4205	27940.0
2010-07-23 05:00:00	AMZN	Stock	5.4155	5.424	5.4105	5.424	21960.0
2010-07-23 06:00:00	AMZN	Stock	5.424	5.424	5.3255	5.3495	404540.0
2010-07-23 07:00:00	AMZN	Stock	5.3495	5.3495	5.2345	5.241	1141620.0
2010-07-23 08:00:00	AMZN	Stock	5.2425	5.384	5.2425	5.3675	12630160.0
2010-07-23 09:00:00	AMZN	Stock	5.3675	5.5245	5.265	5.472	192874860.0
2010-07-23 10:00:00	AMZN	Stock	5.4725	5.6625	5.4505	5.596	171825680.0

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

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