PREVIEW / stock_1hour / 2010-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-19.parquet
  size:    887 KB
  rows:    42,625
  symbols: 3,443

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
2010-02-19 04:00:00	AAPL	Stock	7.1821	7.1821	7.1821	7.1821	5600.0
2010-02-19 06:00:00	AAPL	Stock	7.1921	7.1964	7.1921	7.1964	15960.0
2010-02-19 07:00:00	AAPL	Stock	7.1946	7.2232	7.1946	7.2232	98672.0
2010-02-19 08:00:00	AAPL	Stock	7.22	7.2411	7.1875	7.2325	3078348.0
2010-02-19 09:00:00	AAPL	Stock	7.2361	7.2364	7.1993	7.1993	52863188.0
2010-02-19 10:00:00	AAPL	Stock	7.1993	7.2239	7.1825	7.2086	69035008.0
2010-02-19 11:00:00	AAPL	Stock	7.2089	7.2518	7.2086	7.2496	58242156.0
2010-02-19 12:00:00	AAPL	Stock	7.2496	7.2571	7.2295	7.2407	39745048.0
2010-02-19 13:00:00	AAPL	Stock	7.2411	7.2464	7.2086	7.2196	34469344.0
2010-02-19 14:00:00	AAPL	Stock	7.22	7.2229	7.2071	7.2082	33605236.0
2010-02-19 15:00:00	AAPL	Stock	7.2082	7.2086	7.1839	7.2014	86858688.0
2010-02-19 16:00:00	AAPL	Stock	7.1986	7.2243	7.1884	7.1964	10382064.0
2010-02-19 17:00:00	AAPL	Stock	7.1936	7.1961	7.1914	7.1946	206640.0
2010-02-19 18:00:00	AAPL	Stock	7.1957	7.1996	7.1946	7.1968	164164.0
2010-02-19 19:00:00	AAPL	Stock	7.1982	7.2	7.1957	7.1964	131152.0
2010-02-19 20:00:00	AAPL	Stock	7.2368	7.2368	7.2368	7.2368	36400.0
2010-02-19 04:00:00	MSFT	Stock	28.94	28.94	28.94	28.94	400.0
2010-02-19 07:00:00	MSFT	Stock	28.7	28.82	28.67	28.82	13929.0
2010-02-19 08:00:00	MSFT	Stock	28.75	28.86	28.71	28.85	39793.0
2010-02-19 09:00:00	MSFT	Stock	28.85	28.969	28.73	28.75	9461935.0
2010-02-19 10:00:00	MSFT	Stock	28.75	28.82	28.69	28.8	6316503.0
2010-02-19 11:00:00	MSFT	Stock	28.791	28.91	28.77	28.87	4130968.0
2010-02-19 12:00:00	MSFT	Stock	28.873	28.91	28.74	28.83	4172476.0
2010-02-19 13:00:00	MSFT	Stock	28.825	28.91	28.79	28.84	4867690.0
2010-02-19 14:00:00	MSFT	Stock	28.841	28.85	28.79	28.8	3465163.0
2010-02-19 15:00:00	MSFT	Stock	28.792	28.81	28.7	28.77	9050885.0
2010-02-19 16:00:00	MSFT	Stock	28.78	28.83	28.69	28.8	2561694.0
2010-02-19 17:00:00	MSFT	Stock	28.78	28.78	28.78	28.78	150.0
2010-02-19 18:00:00	MSFT	Stock	28.77	28.79	28.72	28.79	1235.0
2010-02-19 19:00:00	MSFT	Stock	28.79	28.79	28.79	28.79	1000.0
2010-02-19 20:00:00	MSFT	Stock	28.86	28.86	28.86	28.86	7600.0
2010-02-19 08:00:00	NVDA	Stock	0.414	0.4168	0.413	0.416	588160.0
2010-02-19 09:00:00	NVDA	Stock	0.4158	0.4195	0.4138	0.4162	75878640.0
2010-02-19 10:00:00	NVDA	Stock	0.4162	0.4188	0.4135	0.4158	66234480.0
2010-02-19 11:00:00	NVDA	Stock	0.4158	0.4168	0.4135	0.415	72883680.0
2010-02-19 12:00:00	NVDA	Stock	0.415	0.4175	0.415	0.4175	47570960.0
2010-02-19 13:00:00	NVDA	Stock	0.4175	0.4188	0.417	0.4178	40022880.0
2010-02-19 14:00:00	NVDA	Stock	0.4175	0.4178	0.4138	0.4142	55112280.0
2010-02-19 15:00:00	NVDA	Stock	0.4145	0.4152	0.4125	0.4145	134082680.0
2010-02-19 16:00:00	NVDA	Stock	0.4145	0.4156	0.4135	0.4135	17023640.0
2010-02-19 17:00:00	NVDA	Stock	0.4168	0.4168	0.4168	0.4168	336000.0
2010-02-19 18:00:00	NVDA	Stock	0.417	0.417	0.4148	0.4148	8000.0
2010-02-19 19:00:00	NVDA	Stock	0.4142	0.4145	0.4142	0.4142	68520.0
2010-02-19 07:00:00	AMZN	Stock	5.855	5.855	5.855	5.855	10000.0
2010-02-19 08:00:00	AMZN	Stock	5.859	5.927	5.859	5.9045	699680.0
2010-02-19 09:00:00	AMZN	Stock	5.904	5.9545	5.8675	5.8875	31715540.0
2010-02-19 10:00:00	AMZN	Stock	5.887	5.917	5.8825	5.887	22100520.0
2010-02-19 11:00:00	AMZN	Stock	5.8865	5.924	5.8855	5.92	15231260.0
2010-02-19 12:00:00	AMZN	Stock	5.92	5.93	5.885	5.8995	17528000.0
2010-02-19 13:00:00	AMZN	Stock	5.9	5.91	5.8695	5.8785	10926360.0

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

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