PREVIEW / stock_1hour / 2008-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-18.parquet
  size:    897 KB
  rows:    43,468
  symbols: 3,359

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
2008-09-18 05:00:00	AAPL	Stock	4.6957	4.7786	4.6071	4.6429	54320.0
2008-09-18 06:00:00	AAPL	Stock	4.6896	4.6904	4.6782	4.6786	140000.0
2008-09-18 07:00:00	AAPL	Stock	4.675	4.6964	4.67	4.675	1062152.0
2008-09-18 08:00:00	AAPL	Stock	4.6707	4.6786	4.5893	4.6382	3664584.0
2008-09-18 09:00:00	AAPL	Stock	4.6386	4.6939	4.5693	4.6782	142444708.0
2008-09-18 10:00:00	AAPL	Stock	4.6775	4.7375	4.42	4.4282	243304068.0
2008-09-18 11:00:00	AAPL	Stock	4.4286	4.5032	4.3893	4.4175	244119064.0
2008-09-18 12:00:00	AAPL	Stock	4.4186	4.4589	4.31	4.3486	209852440.0
2008-09-18 13:00:00	AAPL	Stock	4.3482	4.5364	4.3257	4.4711	238053032.0
2008-09-18 14:00:00	AAPL	Stock	4.4707	4.5029	4.3618	4.4107	157772440.0
2008-09-18 15:00:00	AAPL	Stock	4.4107	4.8368	4.4004	4.7786	381996076.0
2008-09-18 16:00:00	AAPL	Stock	4.7786	4.8151	4.5174	4.8007	29476048.0
2008-09-18 17:00:00	AAPL	Stock	4.7896	4.7982	4.7889	4.7964	876568.0
2008-09-18 18:00:00	AAPL	Stock	4.7964	4.8193	4.7825	4.8171	486220.0
2008-09-18 19:00:00	AAPL	Stock	4.805	4.8893	4.805	4.8821	979384.0
2008-09-18 07:00:00	MSFT	Stock	25.09	25.35	25.09	25.16	4600.0
2008-09-18 08:00:00	MSFT	Stock	24.84	24.99	24.57	24.67	84177.0
2008-09-18 09:00:00	MSFT	Stock	24.67	24.99	24.52	24.8	12783051.0
2008-09-18 10:00:00	MSFT	Stock	24.8	24.92	24.51	24.54	14102761.0
2008-09-18 11:00:00	MSFT	Stock	24.53	24.56	24.19	24.47	15808155.0
2008-09-18 12:00:00	MSFT	Stock	24.46	24.54	24.2	24.22	14470059.0
2008-09-18 13:00:00	MSFT	Stock	24.21	24.75	24.01	24.11	17215164.0
2008-09-18 14:00:00	MSFT	Stock	24.11	24.36	24.01	24.26	16247540.0
2008-09-18 15:00:00	MSFT	Stock	24.262	25.35	24.24	25.08	30471315.0
2008-09-18 16:00:00	MSFT	Stock	25.09	25.35	24.409	25.23	7210272.0
2008-09-18 17:00:00	MSFT	Stock	25.24	25.3	25.23	25.25	216434.0
2008-09-18 18:00:00	MSFT	Stock	25.25	25.35	24.57	25.35	7000.0
2008-09-18 19:00:00	MSFT	Stock	25.32	25.64	25.3	25.55	30808.0
2008-09-18 08:00:00	NVDA	Stock	0.25	0.2563	0.25	0.2563	264000.0
2008-09-18 09:00:00	NVDA	Stock	0.2547	0.274	0.2525	0.27	221069240.0
2008-09-18 10:00:00	NVDA	Stock	0.27	0.2718	0.2605	0.263	262538080.0
2008-09-18 11:00:00	NVDA	Stock	0.263	0.2648	0.2527	0.2558	213706440.0
2008-09-18 12:00:00	NVDA	Stock	0.2558	0.2588	0.2525	0.254	190543880.0
2008-09-18 13:00:00	NVDA	Stock	0.2543	0.2663	0.2538	0.2605	165377680.0
2008-09-18 14:00:00	NVDA	Stock	0.2603	0.2623	0.2563	0.2623	138010360.0
2008-09-18 15:00:00	NVDA	Stock	0.2623	0.2855	0.262	0.2725	365252760.0
2008-09-18 16:00:00	NVDA	Stock	0.2723	0.2754	0.2648	0.2723	26305000.0
2008-09-18 17:00:00	NVDA	Stock	0.2765	0.2798	0.2706	0.2798	636000.0
2008-09-18 18:00:00	NVDA	Stock	0.2763	0.2763	0.25	0.276	16921760.0
2008-09-18 19:00:00	NVDA	Stock	0.275	0.2755	0.2725	0.2755	30160.0
2008-09-18 08:00:00	AMZN	Stock	3.6495	3.6495	3.64	3.64	28000.0
2008-09-18 09:00:00	AMZN	Stock	3.635	3.718	3.604	3.6645	24108320.0
2008-09-18 10:00:00	AMZN	Stock	3.6645	3.7053	3.655	3.657	25970940.0
2008-09-18 11:00:00	AMZN	Stock	3.659	3.667	3.565	3.618	21839860.0
2008-09-18 12:00:00	AMZN	Stock	3.619	3.619	3.538	3.5495	25383580.0
2008-09-18 13:00:00	AMZN	Stock	3.5495	3.6205	3.5365	3.5435	36520520.0
2008-09-18 14:00:00	AMZN	Stock	3.546	3.6415	3.504	3.6235	36234820.0
2008-09-18 15:00:00	AMZN	Stock	3.625	3.875	3.622	3.825	68620080.0
2008-09-18 16:00:00	AMZN	Stock	3.817	3.8458	3.6517	3.825	2161860.0
2008-09-18 17:00:00	AMZN	Stock	3.825	3.825	3.825	3.825	154720.0

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

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