PREVIEW / stock_1hour / 2011-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-19.parquet
  size:    914 KB
  rows:    44,677
  symbols: 3,495

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
2011-10-19 04:00:00	AAPL	Stock	14.1471	14.3232	14.1471	14.3175	270060.0
2011-10-19 05:00:00	AAPL	Stock	14.3196	14.3286	14.2868	14.3071	324968.0
2011-10-19 06:00:00	AAPL	Stock	14.3107	14.3864	14.2857	14.3864	357420.0
2011-10-19 07:00:00	AAPL	Stock	14.3882	14.4561	14.1964	14.2857	6872264.0
2011-10-19 08:00:00	AAPL	Stock	14.2893	14.3879	14.2257	14.3711	17513048.0
2011-10-19 09:00:00	AAPL	Stock	14.3696	14.4464	14.2496	14.2843	246098944.0
2011-10-19 10:00:00	AAPL	Stock	14.2836	14.5536	14.23	14.505	237496812.0
2011-10-19 11:00:00	AAPL	Stock	14.5086	14.5864	14.4468	14.452	151916408.0
2011-10-19 12:00:00	AAPL	Stock	14.4504	14.5179	14.4468	14.458	66638880.0
2011-10-19 13:00:00	AAPL	Stock	14.4579	14.4629	14.3432	14.3897	81611320.0
2011-10-19 14:00:00	AAPL	Stock	14.3902	14.3964	14.2721	14.3161	126957544.0
2011-10-19 15:00:00	AAPL	Stock	14.3125	14.3239	14.2071	14.2432	147214956.0
2011-10-19 16:00:00	AAPL	Stock	14.2436	14.574	14.2096	14.2375	11778816.0
2011-10-19 17:00:00	AAPL	Stock	14.2446	14.3571	14.2364	14.2664	776188.0
2011-10-19 18:00:00	AAPL	Stock	14.2714	14.2814	14.2364	14.2611	547232.0
2011-10-19 19:00:00	AAPL	Stock	14.2661	14.2814	14.2539	14.2814	356244.0
2011-10-19 05:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	4300.0
2011-10-19 06:00:00	MSFT	Stock	27.28	27.49	27.28	27.49	560.0
2011-10-19 07:00:00	MSFT	Stock	27.44	27.5	27.38	27.39	14626.0
2011-10-19 08:00:00	MSFT	Stock	27.38	27.47	27.35	27.4	72567.0
2011-10-19 09:00:00	MSFT	Stock	27.42	27.47	27.26	27.27	4441459.0
2011-10-19 10:00:00	MSFT	Stock	27.28	27.36	27.12	27.32	5195979.0
2011-10-19 11:00:00	MSFT	Stock	27.31	27.39	27.25	27.27	4190735.0
2011-10-19 12:00:00	MSFT	Stock	27.26	27.47	27.25	27.43	3944019.0
2011-10-19 13:00:00	MSFT	Stock	27.43	27.47	27.22	27.24	4753095.0
2011-10-19 14:00:00	MSFT	Stock	27.25	27.26	27.01	27.132	7327981.0
2011-10-19 15:00:00	MSFT	Stock	27.13	27.2	27.05	27.13	10565040.0
2011-10-19 16:00:00	MSFT	Stock	27.1	27.234	27.1	27.13	1944059.0
2011-10-19 17:00:00	MSFT	Stock	27.13	27.226	27.13	27.14	35216.0
2011-10-19 18:00:00	MSFT	Stock	27.15	27.19	27.13	27.16	8400.0
2011-10-19 19:00:00	MSFT	Stock	27.16	27.16	27.13	27.16	1600.0
2011-10-19 06:00:00	NVDA	Stock	0.39	0.39	0.39	0.39	8000.0
2011-10-19 07:00:00	NVDA	Stock	0.3908	0.391	0.3908	0.3908	16000.0
2011-10-19 08:00:00	NVDA	Stock	0.3858	0.39	0.3845	0.3868	626000.0
2011-10-19 09:00:00	NVDA	Stock	0.3888	0.3929	0.3873	0.3887	73023680.0
2011-10-19 10:00:00	NVDA	Stock	0.3885	0.3942	0.3853	0.3935	81398760.0
2011-10-19 11:00:00	NVDA	Stock	0.3935	0.3936	0.3855	0.3858	61873400.0
2011-10-19 12:00:00	NVDA	Stock	0.3858	0.3913	0.3853	0.39	55719880.0
2011-10-19 13:00:00	NVDA	Stock	0.39	0.3908	0.3855	0.3892	37097200.0
2011-10-19 14:00:00	NVDA	Stock	0.3893	0.3898	0.3813	0.3818	91428560.0
2011-10-19 15:00:00	NVDA	Stock	0.3815	0.382	0.3781	0.3795	121709760.0
2011-10-19 16:00:00	NVDA	Stock	0.3793	0.387	0.3682	0.3788	15775640.0
2011-10-19 17:00:00	NVDA	Stock	0.3748	0.3872	0.3725	0.375	592560.0
2011-10-19 18:00:00	NVDA	Stock	0.375	0.3763	0.3738	0.3743	242560.0
2011-10-19 19:00:00	NVDA	Stock	0.375	0.375	0.3748	0.3748	116480.0
2011-10-19 04:00:00	AMZN	Stock	12.0725	12.0725	12.0725	12.0725	2000.0
2011-10-19 05:00:00	AMZN	Stock	12.0855	12.086	12.085	12.086	12000.0
2011-10-19 06:00:00	AMZN	Stock	12.1425	12.143	12.1425	12.143	10000.0
2011-10-19 07:00:00	AMZN	Stock	12.1395	12.1395	12.0925	12.0945	15000.0
2011-10-19 08:00:00	AMZN	Stock	12.0775	12.088	12.036	12.083	94960.0

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

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