PREVIEW / stock_1hour / 2008-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-09.parquet
  size:    834 KB
  rows:    40,472
  symbols: 3,333

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-09 05:00:00	AAPL	Stock	5.66	5.66	5.66	5.66	8400.0
2008-09-09 06:00:00	AAPL	Stock	5.6782	5.6782	5.6782	5.6782	5600.0
2008-09-09 07:00:00	AAPL	Stock	5.6768	5.6768	5.6696	5.6696	64540.0
2008-09-09 08:00:00	AAPL	Stock	5.6786	5.6843	5.5893	5.5893	1712368.0
2008-09-09 09:00:00	AAPL	Stock	5.5875	5.71	5.5536	5.6654	111096048.0
2008-09-09 10:00:00	AAPL	Stock	5.6646	5.6921	5.6182	5.6564	138141220.0
2008-09-09 11:00:00	AAPL	Stock	5.6564	5.6779	5.5964	5.6314	96942580.0
2008-09-09 12:00:00	AAPL	Stock	5.6314	5.6629	5.5689	5.6111	98094612.0
2008-09-09 13:00:00	AAPL	Stock	5.6099	5.7129	5.4214	5.4539	308690928.0
2008-09-09 14:00:00	AAPL	Stock	5.4543	5.5093	5.3929	5.4107	229059180.0
2008-09-09 15:00:00	AAPL	Stock	5.4107	5.445	5.3496	5.4118	226187696.0
2008-09-09 16:00:00	AAPL	Stock	5.4129	5.5364	5.4066	5.4268	28639324.0
2008-09-09 17:00:00	AAPL	Stock	5.425	5.425	5.4071	5.4125	459620.0
2008-09-09 18:00:00	AAPL	Stock	5.4075	5.4286	5.4057	5.4286	334320.0
2008-09-09 19:00:00	AAPL	Stock	5.4286	5.4364	5.4286	5.4357	352352.0
2008-09-09 07:00:00	MSFT	Stock	26.32	26.32	26.29	26.29	200.0
2008-09-09 08:00:00	MSFT	Stock	26.23	26.26	26.15	26.16	9192.0
2008-09-09 09:00:00	MSFT	Stock	26.17	26.6	26.16	26.56	8899613.0
2008-09-09 10:00:00	MSFT	Stock	26.56	26.595	26.33	26.42	18128724.0
2008-09-09 11:00:00	MSFT	Stock	26.42	26.47	26.24	26.24	8214716.0
2008-09-09 12:00:00	MSFT	Stock	26.25	26.49	26.18	26.408	7945589.0
2008-09-09 13:00:00	MSFT	Stock	26.409	26.55	26.29	26.35	8326200.0
2008-09-09 14:00:00	MSFT	Stock	26.35	26.47	26.31	26.392	9958138.0
2008-09-09 15:00:00	MSFT	Stock	26.4	26.43	26.05	26.1	17713483.0
2008-09-09 16:00:00	MSFT	Stock	26.1	26.36	26.015	26.12	4537592.0
2008-09-09 17:00:00	MSFT	Stock	26.12	26.15	26.12	26.15	1050.0
2008-09-09 18:00:00	MSFT	Stock	26.15	26.15	26.1	26.11	27170.0
2008-09-09 19:00:00	MSFT	Stock	26.16	26.25	26.16	26.23	13974.0
2008-09-09 07:00:00	NVDA	Stock	0.28	0.28	0.28	0.28	4000.0
2008-09-09 08:00:00	NVDA	Stock	0.28	0.2805	0.28	0.28	121400.0
2008-09-09 09:00:00	NVDA	Stock	0.28	0.2958	0.2765	0.2905	249911720.0
2008-09-09 10:00:00	NVDA	Stock	0.2902	0.2902	0.28	0.2814	207431000.0
2008-09-09 11:00:00	NVDA	Stock	0.2812	0.282	0.2788	0.2803	68535040.0
2008-09-09 12:00:00	NVDA	Stock	0.2801	0.2811	0.2766	0.2789	103416080.0
2008-09-09 13:00:00	NVDA	Stock	0.2788	0.2803	0.276	0.2763	137237200.0
2008-09-09 14:00:00	NVDA	Stock	0.2763	0.2768	0.2728	0.2732	132380960.0
2008-09-09 15:00:00	NVDA	Stock	0.2732	0.2743	0.2692	0.2708	178420640.0
2008-09-09 16:00:00	NVDA	Stock	0.271	0.2804	0.2688	0.2738	18939120.0
2008-09-09 17:00:00	NVDA	Stock	0.2738	0.2738	0.2725	0.2725	192000.0
2008-09-09 18:00:00	NVDA	Stock	0.273	0.273	0.2718	0.2718	60000.0
2008-09-09 19:00:00	NVDA	Stock	0.2738	0.275	0.2738	0.275	234200.0
2008-09-09 08:00:00	AMZN	Stock	4.035	4.035	4.035	4.035	14000.0
2008-09-09 09:00:00	AMZN	Stock	4.0445	4.098	4.0205	4.0735	11724860.0
2008-09-09 10:00:00	AMZN	Stock	4.071	4.0805	4.0145	4.0213	15304020.0
2008-09-09 11:00:00	AMZN	Stock	4.0215	4.0605	3.9875	4.0465	16205420.0
2008-09-09 12:00:00	AMZN	Stock	4.0455	4.061	4.03	4.0425	12499040.0
2008-09-09 13:00:00	AMZN	Stock	4.0425	4.0785	4.0285	4.035	13781540.0
2008-09-09 14:00:00	AMZN	Stock	4.0345	4.043	3.9755	3.9842	15674040.0
2008-09-09 15:00:00	AMZN	Stock	3.986	4.004	3.95	3.95	25871960.0
2008-09-09 16:00:00	AMZN	Stock	3.95	4.025	3.946	4.01	4643480.0

> showing 50 of 40,472 rows — these rows as CSV

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