PREVIEW / stock_1hour / 2009-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-07.parquet
  size:    863 KB
  rows:    41,518
  symbols: 3,374

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-10-07 06:00:00	AAPL	Stock	6.8157	6.8157	6.7964	6.7964	59668.0
2009-10-07 07:00:00	AAPL	Stock	6.7979	6.7982	6.7679	6.7732	211120.0
2009-10-07 08:00:00	AAPL	Stock	6.7732	6.785	6.7614	6.7646	1689800.0
2009-10-07 09:00:00	AAPL	Stock	6.765	6.8054	6.7571	6.7789	90568464.0
2009-10-07 10:00:00	AAPL	Stock	6.78	6.7964	6.7604	6.7804	91295344.0
2009-10-07 11:00:00	AAPL	Stock	6.7804	6.7971	6.7657	6.7675	52634540.0
2009-10-07 12:00:00	AAPL	Stock	6.7664	6.7854	6.7643	6.7825	37175376.0
2009-10-07 13:00:00	AAPL	Stock	6.7821	6.7829	6.7647	6.7757	42306656.0
2009-10-07 14:00:00	AAPL	Stock	6.7739	6.7854	6.7511	6.7814	57817144.0
2009-10-07 15:00:00	AAPL	Stock	6.7807	6.7954	6.7714	6.7943	80135944.0
2009-10-07 16:00:00	AAPL	Stock	6.7946	6.8018	6.7774	6.8018	6535144.0
2009-10-07 17:00:00	AAPL	Stock	6.8032	6.8179	6.8018	6.8143	772464.0
2009-10-07 18:00:00	AAPL	Stock	6.8143	6.8143	6.7929	6.8143	331940.0
2009-10-07 19:00:00	AAPL	Stock	6.8143	6.8304	6.8132	6.8286	437472.0
2009-10-07 06:00:00	MSFT	Stock	25.29	25.29	25.25	25.25	500.0
2009-10-07 07:00:00	MSFT	Stock	25.23	25.23	25.22	25.22	400.0
2009-10-07 08:00:00	MSFT	Stock	25.11	25.15	25.08	25.1	7782.0
2009-10-07 09:00:00	MSFT	Stock	25.07	25.11	24.88	24.99	4808056.0
2009-10-07 10:00:00	MSFT	Stock	25.0	25.18	24.96	25.11	5472142.0
2009-10-07 11:00:00	MSFT	Stock	25.11	25.17	24.89	24.91	4420103.0
2009-10-07 12:00:00	MSFT	Stock	24.89	25.1	24.89	25.09	4057994.0
2009-10-07 13:00:00	MSFT	Stock	25.09	25.1	25.02	25.04	2175684.0
2009-10-07 14:00:00	MSFT	Stock	25.04	25.07	24.94	25.03	5190448.0
2009-10-07 15:00:00	MSFT	Stock	25.03	25.11	24.99	25.1	5946032.0
2009-10-07 16:00:00	MSFT	Stock	25.11	25.14	25.022	25.14	2904726.0
2009-10-07 17:00:00	MSFT	Stock	25.14	25.17	25.11	25.13	10812.0
2009-10-07 18:00:00	MSFT	Stock	25.14	25.14	25.14	25.14	200.0
2009-10-07 19:00:00	MSFT	Stock	25.14	25.14	25.11	25.11	955.0
2009-10-07 08:00:00	NVDA	Stock	0.3488	0.3488	0.3473	0.3475	40000.0
2009-10-07 09:00:00	NVDA	Stock	0.3475	0.3508	0.3438	0.347	91255200.0
2009-10-07 10:00:00	NVDA	Stock	0.347	0.3515	0.3462	0.3482	118679760.0
2009-10-07 11:00:00	NVDA	Stock	0.3482	0.349	0.346	0.3462	44967640.0
2009-10-07 12:00:00	NVDA	Stock	0.3462	0.3475	0.3458	0.3468	36344320.0
2009-10-07 13:00:00	NVDA	Stock	0.3465	0.3468	0.3455	0.346	33180160.0
2009-10-07 14:00:00	NVDA	Stock	0.3459	0.3465	0.3445	0.346	27278880.0
2009-10-07 15:00:00	NVDA	Stock	0.346	0.3478	0.3453	0.3475	92520320.0
2009-10-07 16:00:00	NVDA	Stock	0.347	0.3488	0.3465	0.348	525880.0
2009-10-07 17:00:00	NVDA	Stock	0.3465	0.3465	0.3415	0.3425	1524920.0
2009-10-07 18:00:00	NVDA	Stock	0.3425	0.3448	0.3425	0.3448	307200.0
2009-10-07 19:00:00	NVDA	Stock	0.3462	0.3465	0.3458	0.3465	174000.0
2009-10-07 08:00:00	AMZN	Stock	4.5805	4.5805	4.55	4.55	22020.0
2009-10-07 09:00:00	AMZN	Stock	4.5475	4.6635	4.5475	4.649	28485500.0
2009-10-07 10:00:00	AMZN	Stock	4.65	4.6985	4.625	4.6925	26424500.0
2009-10-07 11:00:00	AMZN	Stock	4.6907	4.724	4.664	4.664	25722940.0
2009-10-07 12:00:00	AMZN	Stock	4.6655	4.694	4.6635	4.6835	11112320.0
2009-10-07 13:00:00	AMZN	Stock	4.685	4.706	4.6805	4.69	9871080.0
2009-10-07 14:00:00	AMZN	Stock	4.69	4.703	4.6625	4.6855	15530840.0
2009-10-07 15:00:00	AMZN	Stock	4.683	4.7085	4.6685	4.6985	27805880.0
2009-10-07 16:00:00	AMZN	Stock	4.6985	4.7025	4.6741	4.7	2852940.0
2009-10-07 17:00:00	AMZN	Stock	4.7025	4.707	4.699	4.707	28000.0

> showing 50 of 41,518 rows — these rows as CSV

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