PREVIEW / stock_1hour / 2009-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-14.parquet
  size:    881 KB
  rows:    42,782
  symbols: 3,356

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-14 07:00:00	AAPL	Stock	6.1036	6.1143	6.0982	6.1054	54880.0
2009-09-14 08:00:00	AAPL	Stock	6.1054	6.1154	6.1007	6.1136	348824.0
2009-09-14 09:00:00	AAPL	Stock	6.1143	6.1307	6.0804	6.1243	48435520.0
2009-09-14 10:00:00	AAPL	Stock	6.1232	6.1768	6.1171	6.1704	56833000.0
2009-09-14 11:00:00	AAPL	Stock	6.1704	6.1786	6.1532	6.1604	30587704.0
2009-09-14 12:00:00	AAPL	Stock	6.1593	6.1786	6.1525	6.1718	30343908.0
2009-09-14 13:00:00	AAPL	Stock	6.1718	6.1839	6.1643	6.1656	32086040.0
2009-09-14 14:00:00	AAPL	Stock	6.1657	6.1925	6.1618	6.1854	41498268.0
2009-09-14 15:00:00	AAPL	Stock	6.1854	6.2107	6.1732	6.2036	58334444.0
2009-09-14 16:00:00	AAPL	Stock	6.2036	6.2089	6.1612	6.2036	16003204.0
2009-09-14 17:00:00	AAPL	Stock	6.2036	6.2089	6.2018	6.2071	270228.0
2009-09-14 18:00:00	AAPL	Stock	6.2043	6.2086	6.2043	6.2064	244328.0
2009-09-14 19:00:00	AAPL	Stock	6.2068	6.2089	6.2004	6.2089	190652.0
2009-09-14 05:00:00	MSFT	Stock	24.62	24.62	24.62	24.62	300.0
2009-09-14 07:00:00	MSFT	Stock	24.67	24.76	24.67	24.75	5230.0
2009-09-14 08:00:00	MSFT	Stock	24.75	24.81	24.7	24.72	17826.0
2009-09-14 09:00:00	MSFT	Stock	24.76	24.98	24.64	24.96	5550877.0
2009-09-14 10:00:00	MSFT	Stock	24.96	25.09	24.9	25.03	6764932.0
2009-09-14 11:00:00	MSFT	Stock	25.04	25.06	24.94	24.97	4051033.0
2009-09-14 12:00:00	MSFT	Stock	24.978	25.0	24.95	24.98	2255948.0
2009-09-14 13:00:00	MSFT	Stock	24.982	25.03	24.95	25.01	2774327.0
2009-09-14 14:00:00	MSFT	Stock	25.01	25.08	24.97	25.05	4101166.0
2009-09-14 15:00:00	MSFT	Stock	25.05	25.06	24.99	24.99	8929367.0
2009-09-14 16:00:00	MSFT	Stock	24.99	25.065	24.95	25.016	5286590.0
2009-09-14 17:00:00	MSFT	Stock	24.96	24.96	24.96	24.96	1900.0
2009-09-14 18:00:00	MSFT	Stock	25.0	25.0	24.96	24.97	18243.0
2009-09-14 19:00:00	MSFT	Stock	24.95	24.98	24.95	24.96	2214.0
2009-09-14 07:00:00	NVDA	Stock	0.4072	0.4072	0.4072	0.4072	24000.0
2009-09-14 08:00:00	NVDA	Stock	0.405	0.405	0.3975	0.3975	344000.0
2009-09-14 09:00:00	NVDA	Stock	0.4008	0.4053	0.3995	0.402	71956840.0
2009-09-14 10:00:00	NVDA	Stock	0.402	0.4025	0.4	0.4006	104551240.0
2009-09-14 11:00:00	NVDA	Stock	0.4005	0.4013	0.3993	0.3995	45673440.0
2009-09-14 12:00:00	NVDA	Stock	0.3998	0.4005	0.3982	0.3988	44450200.0
2009-09-14 13:00:00	NVDA	Stock	0.399	0.4013	0.3978	0.3998	50969600.0
2009-09-14 14:00:00	NVDA	Stock	0.3999	0.4013	0.3988	0.4011	53633840.0
2009-09-14 15:00:00	NVDA	Stock	0.4013	0.4015	0.3995	0.401	98523040.0
2009-09-14 16:00:00	NVDA	Stock	0.4008	0.4018	0.4005	0.4008	10549000.0
2009-09-14 17:00:00	NVDA	Stock	0.401	0.4015	0.401	0.4015	106000.0
2009-09-14 18:00:00	NVDA	Stock	0.4013	0.4013	0.4013	0.4013	32240.0
2009-09-14 05:00:00	AMZN	Stock	4.1435	4.1435	4.1435	4.1435	14000.0
2009-09-14 08:00:00	AMZN	Stock	4.1975	4.1975	4.1875	4.188	10000.0
2009-09-14 09:00:00	AMZN	Stock	4.188	4.2118	4.173	4.194	10141380.0
2009-09-14 10:00:00	AMZN	Stock	4.1955	4.206	4.179	4.1985	12867720.0
2009-09-14 11:00:00	AMZN	Stock	4.1985	4.2055	4.18	4.187	7174300.0
2009-09-14 12:00:00	AMZN	Stock	4.187	4.1995	4.18	4.1905	6472560.0
2009-09-14 13:00:00	AMZN	Stock	4.1905	4.198	4.1805	4.1915	5689360.0
2009-09-14 14:00:00	AMZN	Stock	4.1915	4.2125	4.185	4.1915	9142680.0
2009-09-14 15:00:00	AMZN	Stock	4.191	4.2285	4.1745	4.1925	15427100.0
2009-09-14 16:00:00	AMZN	Stock	4.193	4.2	4.1825	4.2	1320800.0
2009-09-14 17:00:00	AMZN	Stock	4.1995	4.1995	4.1995	4.1995	2000.0

> showing 50 of 42,782 rows — these rows as CSV

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