PREVIEW / stock_1hour / 2009-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-02.parquet
  size:    836 KB
  rows:    41,337
  symbols: 3,354

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-03-02 07:00:00	AAPL	Stock	3.1214	3.1314	3.1214	3.1314	66500.0
2009-03-02 08:00:00	AAPL	Stock	3.1314	3.1489	3.1311	3.1486	840952.0
2009-03-02 09:00:00	AAPL	Stock	3.1489	3.2571	3.1357	3.2321	101370220.0
2009-03-02 10:00:00	AAPL	Stock	3.2311	3.2486	3.195	3.1982	102922820.0
2009-03-02 11:00:00	AAPL	Stock	3.1982	3.2411	3.1429	3.1832	113079176.0
2009-03-02 12:00:00	AAPL	Stock	3.1832	3.2068	3.1536	3.16	83725236.0
2009-03-02 13:00:00	AAPL	Stock	3.1604	3.1896	3.15	3.1893	73765188.0
2009-03-02 14:00:00	AAPL	Stock	3.1889	3.1893	3.1486	3.1579	79798880.0
2009-03-02 15:00:00	AAPL	Stock	3.1586	3.2036	3.1311	3.1468	157802092.0
2009-03-02 16:00:00	AAPL	Stock	3.1425	3.2564	3.1407	3.1479	37952152.0
2009-03-02 17:00:00	AAPL	Stock	3.145	3.2393	3.145	3.1896	270004.0
2009-03-02 18:00:00	AAPL	Stock	3.1407	3.1514	3.1407	3.1514	7345968.0
2009-03-02 19:00:00	AAPL	Stock	3.1518	3.1536	3.1464	3.1468	168616.0
2009-03-02 04:00:00	MSFT	Stock	15.84	16.0	15.84	16.0	700.0
2009-03-02 06:00:00	MSFT	Stock	15.9	15.9	15.87	15.87	900.0
2009-03-02 07:00:00	MSFT	Stock	15.82	15.97	15.82	15.88	2315.0
2009-03-02 08:00:00	MSFT	Stock	15.95	16.06	15.85	15.97	70748.0
2009-03-02 09:00:00	MSFT	Stock	15.98	16.25	15.9	16.14	9697659.0
2009-03-02 10:00:00	MSFT	Stock	16.14	16.16	15.96	16.009	11313321.0
2009-03-02 11:00:00	MSFT	Stock	16.002	16.05	15.9	15.92	10020378.0
2009-03-02 12:00:00	MSFT	Stock	15.93	16.025	15.85	15.851	9029563.0
2009-03-02 13:00:00	MSFT	Stock	15.85	16.0	15.82	16.0	7032668.0
2009-03-02 14:00:00	MSFT	Stock	15.992	16.0	15.84	15.89	6682523.0
2009-03-02 15:00:00	MSFT	Stock	15.89	15.979	15.72	15.8	20103802.0
2009-03-02 16:00:00	MSFT	Stock	15.8	15.95	15.77	15.81	5345582.0
2009-03-02 17:00:00	MSFT	Stock	15.83	16.15	15.82	15.84	15939.0
2009-03-02 18:00:00	MSFT	Stock	15.82	15.85	15.82	15.83	10620.0
2009-03-02 19:00:00	MSFT	Stock	15.82	15.85	15.82	15.82	10675.0
2009-03-02 08:00:00	NVDA	Stock	0.2025	0.2025	0.1978	0.2025	84000.0
2009-03-02 09:00:00	NVDA	Stock	0.1992	0.2062	0.1988	0.2045	73665520.0
2009-03-02 10:00:00	NVDA	Stock	0.2045	0.2061	0.1958	0.1965	131234960.0
2009-03-02 11:00:00	NVDA	Stock	0.1966	0.1975	0.191	0.1928	122226360.0
2009-03-02 12:00:00	NVDA	Stock	0.1928	0.1958	0.1908	0.191	79388560.0
2009-03-02 13:00:00	NVDA	Stock	0.1913	0.1933	0.19	0.1925	49207560.0
2009-03-02 14:00:00	NVDA	Stock	0.1925	0.1945	0.1918	0.1918	79717760.0
2009-03-02 15:00:00	NVDA	Stock	0.1918	0.192	0.1888	0.19	146507720.0
2009-03-02 16:00:00	NVDA	Stock	0.1905	0.1953	0.1895	0.19	5746440.0
2009-03-02 17:00:00	NVDA	Stock	0.1898	0.19	0.1898	0.19	25760.0
2009-03-02 05:00:00	AMZN	Stock	3.17	3.17	3.17	3.17	2000.0
2009-03-02 06:00:00	AMZN	Stock	3.165	3.165	3.165	3.165	2000.0
2009-03-02 07:00:00	AMZN	Stock	3.106	3.1645	3.106	3.1645	24000.0
2009-03-02 08:00:00	AMZN	Stock	3.1645	3.2395	3.156	3.1825	200000.0
2009-03-02 09:00:00	AMZN	Stock	3.1825	3.276	3.1645	3.235	28255680.0
2009-03-02 10:00:00	AMZN	Stock	3.236	3.254	3.143	3.1555	38154320.0
2009-03-02 11:00:00	AMZN	Stock	3.159	3.175	3.1135	3.127	25472040.0
2009-03-02 12:00:00	AMZN	Stock	3.126	3.154	3.1125	3.1145	26093220.0
2009-03-02 13:00:00	AMZN	Stock	3.1155	3.127	3.078	3.12	23316760.0
2009-03-02 14:00:00	AMZN	Stock	3.1205	3.15	3.0995	3.117	20805840.0
2009-03-02 15:00:00	AMZN	Stock	3.1165	3.1205	3.0755	3.1	41346040.0
2009-03-02 16:00:00	AMZN	Stock	3.1	3.1474	3.0995	3.0995	5922280.0

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

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