PREVIEW / stock_1hour / 2009-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-28.parquet
  size:    859 KB
  rows:    41,079
  symbols: 3,392

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-08-28 04:00:00	AAPL	Stock	6.1014	6.1014	6.1014	6.1014	14000.0
2009-08-28 05:00:00	AAPL	Stock	6.1018	6.1143	6.1018	6.1143	30800.0
2009-08-28 06:00:00	AAPL	Stock	6.1075	6.1111	6.1071	6.1071	16800.0
2009-08-28 07:00:00	AAPL	Stock	6.1246	6.1246	6.1107	6.1207	558180.0
2009-08-28 08:00:00	AAPL	Stock	6.1179	6.1393	6.1179	6.1329	5190108.0
2009-08-28 09:00:00	AAPL	Stock	6.1325	6.1696	6.0629	6.0782	124413212.0
2009-08-28 10:00:00	AAPL	Stock	6.0786	6.0993	6.0539	6.0846	71217748.0
2009-08-28 11:00:00	AAPL	Stock	6.0846	6.0975	6.0621	6.0695	36770076.0
2009-08-28 12:00:00	AAPL	Stock	6.0686	6.0832	6.0196	6.0207	48689984.0
2009-08-28 13:00:00	AAPL	Stock	6.0207	6.0607	6.0189	6.0564	34228348.0
2009-08-28 14:00:00	AAPL	Stock	6.0568	6.0768	6.0457	6.0754	35218008.0
2009-08-28 15:00:00	AAPL	Stock	6.0746	6.1054	6.0471	6.075	80624068.0
2009-08-28 16:00:00	AAPL	Stock	6.0693	6.0797	6.06	6.0607	14120372.0
2009-08-28 17:00:00	AAPL	Stock	6.06	6.0664	6.0536	6.0625	424228.0
2009-08-28 18:00:00	AAPL	Stock	6.0643	6.0732	6.0643	6.0711	214480.0
2009-08-28 19:00:00	AAPL	Stock	6.0707	6.0782	6.0707	6.0782	128268.0
2009-08-28 06:00:00	MSFT	Stock	24.79	24.79	24.79	24.79	1000.0
2009-08-28 07:00:00	MSFT	Stock	24.82	24.82	24.82	24.82	200.0
2009-08-28 08:00:00	MSFT	Stock	24.8	24.84	24.78	24.8	40165.0
2009-08-28 09:00:00	MSFT	Stock	24.8	25.49	24.8	25.3	12432486.0
2009-08-28 10:00:00	MSFT	Stock	25.3	25.31	24.89	25.06	11666511.0
2009-08-28 11:00:00	MSFT	Stock	25.06	25.08	24.93	24.94	4690934.0
2009-08-28 12:00:00	MSFT	Stock	24.938	24.96	24.65	24.65	6593226.0
2009-08-28 13:00:00	MSFT	Stock	24.641	24.83	24.64	24.79	3886740.0
2009-08-28 14:00:00	MSFT	Stock	24.794	24.86	24.74	24.817	3778258.0
2009-08-28 15:00:00	MSFT	Stock	24.82	24.85	24.61	24.68	9504181.0
2009-08-28 16:00:00	MSFT	Stock	24.69	24.968	24.67	24.67	2607382.0
2009-08-28 17:00:00	MSFT	Stock	24.68	24.68	24.61	24.64	21734.0
2009-08-28 18:00:00	MSFT	Stock	24.63	24.67	24.61	24.66	6030.0
2009-08-28 19:00:00	MSFT	Stock	24.65	24.65	24.61	24.65	9335.0
2009-08-28 20:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	800.0
2009-08-28 07:00:00	NVDA	Stock	0.3502	0.3502	0.3502	0.3502	6000.0
2009-08-28 08:00:00	NVDA	Stock	0.3562	0.3562	0.3515	0.3538	269680.0
2009-08-28 09:00:00	NVDA	Stock	0.356	0.3758	0.356	0.3645	228164320.0
2009-08-28 10:00:00	NVDA	Stock	0.3648	0.37	0.3642	0.3688	157362560.0
2009-08-28 11:00:00	NVDA	Stock	0.3685	0.3692	0.3658	0.3665	97763480.0
2009-08-28 12:00:00	NVDA	Stock	0.3662	0.3671	0.3625	0.3625	86399520.0
2009-08-28 13:00:00	NVDA	Stock	0.3625	0.3662	0.3625	0.364	96092600.0
2009-08-28 14:00:00	NVDA	Stock	0.364	0.3685	0.3635	0.3682	64081760.0
2009-08-28 15:00:00	NVDA	Stock	0.3682	0.3708	0.3665	0.3685	118513240.0
2009-08-28 16:00:00	NVDA	Stock	0.3682	0.3695	0.3674	0.3682	10135600.0
2009-08-28 17:00:00	NVDA	Stock	0.367	0.367	0.367	0.367	40000.0
2009-08-28 08:00:00	AMZN	Stock	4.2125	4.2245	4.21	4.214	63360.0
2009-08-28 09:00:00	AMZN	Stock	4.218	4.253	4.1855	4.1905	14954380.0
2009-08-28 10:00:00	AMZN	Stock	4.192	4.2125	4.185	4.1965	14166980.0
2009-08-28 11:00:00	AMZN	Stock	4.195	4.211	4.1835	4.191	8800400.0
2009-08-28 12:00:00	AMZN	Stock	4.19	4.192	4.155	4.158	9072400.0
2009-08-28 13:00:00	AMZN	Stock	4.1585	4.175	4.15	4.1535	8858360.0
2009-08-28 14:00:00	AMZN	Stock	4.154	4.158	4.1435	4.1505	8465160.0
2009-08-28 15:00:00	AMZN	Stock	4.1505	4.1575	4.1285	4.1375	24308260.0

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

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