PREVIEW / stock_1hour / 2009-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-30.parquet
  size:    907 KB
  rows:    43,022
  symbols: 3,400

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
2009-09-30 06:00:00	AAPL	Stock	6.6671	6.6671	6.6429	6.6429	5600.0
2009-09-30 07:00:00	AAPL	Stock	6.6257	6.6564	6.6257	6.6518	99260.0
2009-09-30 08:00:00	AAPL	Stock	6.6554	6.6661	6.6429	6.6486	1302364.0
2009-09-30 09:00:00	AAPL	Stock	6.6489	6.6543	6.5219	6.5485	83216784.0
2009-09-30 10:00:00	AAPL	Stock	6.5475	6.5671	6.5286	6.5454	75626320.0
2009-09-30 11:00:00	AAPL	Stock	6.545	6.6061	6.5436	6.5979	63291144.0
2009-09-30 12:00:00	AAPL	Stock	6.5972	6.65	6.5821	6.6436	64490272.0
2009-09-30 13:00:00	AAPL	Stock	6.6432	6.6589	6.6293	6.6386	57886192.0
2009-09-30 14:00:00	AAPL	Stock	6.6382	6.6429	6.6093	6.6096	45000424.0
2009-09-30 15:00:00	AAPL	Stock	6.6096	6.6439	6.5798	6.6204	104185508.0
2009-09-30 16:00:00	AAPL	Stock	6.6196	6.6371	6.5996	6.6229	39254768.0
2009-09-30 17:00:00	AAPL	Stock	6.6207	6.6286	6.6207	6.6214	149100.0
2009-09-30 18:00:00	AAPL	Stock	6.6196	6.6246	6.6161	6.6214	94556.0
2009-09-30 19:00:00	AAPL	Stock	6.6232	6.6375	6.62	6.6375	222852.0
2009-09-30 06:00:00	MSFT	Stock	25.88	25.88	25.88	25.88	290.0
2009-09-30 07:00:00	MSFT	Stock	25.79	25.79	25.79	25.79	390.0
2009-09-30 08:00:00	MSFT	Stock	25.8	25.88	25.77	25.88	4454.0
2009-09-30 09:00:00	MSFT	Stock	25.87	25.89	25.38	25.46	7441963.0
2009-09-30 10:00:00	MSFT	Stock	25.45	25.57	25.43	25.485	10385832.0
2009-09-30 11:00:00	MSFT	Stock	25.48	25.61	25.47	25.573	4079039.0
2009-09-30 12:00:00	MSFT	Stock	25.57	25.93	25.555	25.88	5594018.0
2009-09-30 13:00:00	MSFT	Stock	25.88	25.99	25.88	25.96	6355090.0
2009-09-30 14:00:00	MSFT	Stock	25.96	25.98	25.86	25.87	4980919.0
2009-09-30 15:00:00	MSFT	Stock	25.87	25.87	25.69	25.81	14432471.0
2009-09-30 16:00:00	MSFT	Stock	25.81	25.95	25.7	25.89	6448389.0
2009-09-30 17:00:00	MSFT	Stock	25.83	25.84	25.8	25.84	2027.0
2009-09-30 18:00:00	MSFT	Stock	25.72	25.84	25.72	25.84	13206.0
2009-09-30 06:00:00	NVDA	Stock	0.3688	0.3688	0.3688	0.3688	200000.0
2009-09-30 08:00:00	NVDA	Stock	0.3688	0.3703	0.3678	0.3703	636000.0
2009-09-30 09:00:00	NVDA	Stock	0.37	0.375	0.3632	0.367	167895920.0
2009-09-30 10:00:00	NVDA	Stock	0.367	0.3718	0.3642	0.371	148168320.0
2009-09-30 11:00:00	NVDA	Stock	0.3713	0.377	0.371	0.3758	108214000.0
2009-09-30 12:00:00	NVDA	Stock	0.3758	0.3795	0.3751	0.379	97123000.0
2009-09-30 13:00:00	NVDA	Stock	0.3788	0.3803	0.3773	0.3778	82941240.0
2009-09-30 14:00:00	NVDA	Stock	0.378	0.38	0.3768	0.377	74188800.0
2009-09-30 15:00:00	NVDA	Stock	0.3769	0.3773	0.3743	0.3758	160485920.0
2009-09-30 16:00:00	NVDA	Stock	0.3755	0.3775	0.3733	0.3768	21932600.0
2009-09-30 17:00:00	NVDA	Stock	0.3768	0.3775	0.3758	0.3775	897200.0
2009-09-30 18:00:00	NVDA	Stock	0.3775	0.386	0.3763	0.3835	9207840.0
2009-09-30 19:00:00	NVDA	Stock	0.3833	0.3838	0.382	0.382	1235400.0
2009-09-30 09:00:00	AMZN	Stock	4.6	4.659	4.5715	4.584	23395000.0
2009-09-30 10:00:00	AMZN	Stock	4.5835	4.615	4.5795	4.6066	18762040.0
2009-09-30 11:00:00	AMZN	Stock	4.607	4.6315	4.597	4.629	11037280.0
2009-09-30 12:00:00	AMZN	Stock	4.6295	4.6895	4.6195	4.675	17833820.0
2009-09-30 13:00:00	AMZN	Stock	4.676	4.7085	4.6705	4.6825	16652240.0
2009-09-30 14:00:00	AMZN	Stock	4.682	4.7075	4.666	4.667	12414320.0
2009-09-30 15:00:00	AMZN	Stock	4.667	4.679	4.634	4.669	34835760.0
2009-09-30 16:00:00	AMZN	Stock	4.6685	4.676	4.6435	4.668	31741800.0
2009-09-30 17:00:00	AMZN	Stock	4.668	4.668	4.668	4.668	12980.0
2009-09-30 18:00:00	AMZN	Stock	4.6625	4.671	4.6625	4.671	12000.0

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

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