PREVIEW / stock_1hour / 2010-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-09.parquet
  size:    895 KB
  rows:    42,804
  symbols: 3,434

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-09 04:00:00	AAPL	Stock	6.9361	6.9961	6.9361	6.9961	11900.0
2010-02-09 05:00:00	AAPL	Stock	6.9657	6.9657	6.9657	6.9657	14000.0
2010-02-09 06:00:00	AAPL	Stock	6.9793	6.9793	6.9793	6.9793	3640.0
2010-02-09 07:00:00	AAPL	Stock	6.9611	6.9925	6.9607	6.9861	714616.0
2010-02-09 08:00:00	AAPL	Stock	6.9821	7.0321	6.9764	7.0286	4748044.0
2010-02-09 09:00:00	AAPL	Stock	7.0293	7.035	6.9875	7.0096	72690968.0
2010-02-09 10:00:00	AAPL	Stock	7.0096	7.0443	6.9932	7.0011	88010496.0
2010-02-09 11:00:00	AAPL	Stock	7.0011	7.0321	6.9554	7.02	110902400.0
2010-02-09 12:00:00	AAPL	Stock	7.0196	7.0536	6.9925	7.0239	91268436.0
2010-02-09 13:00:00	AAPL	Stock	7.0239	7.0382	7.0071	7.0279	35092792.0
2010-02-09 14:00:00	AAPL	Stock	7.0282	7.0357	7.0	7.0039	43354108.0
2010-02-09 15:00:00	AAPL	Stock	7.0043	7.0307	7.0018	7.0068	81420052.0
2010-02-09 16:00:00	AAPL	Stock	7.0068	7.0256	6.9886	7.0036	9494380.0
2010-02-09 17:00:00	AAPL	Stock	7.0036	7.0089	7.0036	7.0054	223048.0
2010-02-09 18:00:00	AAPL	Stock	7.0071	7.0082	7.0054	7.0082	212380.0
2010-02-09 19:00:00	AAPL	Stock	7.0096	7.0121	7.0096	7.0111	126476.0
2010-02-09 07:00:00	MSFT	Stock	27.89	27.93	27.85	27.92	3800.0
2010-02-09 08:00:00	MSFT	Stock	27.9	27.96	27.82	27.89	28123.0
2010-02-09 09:00:00	MSFT	Stock	27.92	28.075	27.86	28.02	4142237.0
2010-02-09 10:00:00	MSFT	Stock	28.005	28.14	27.96	28.03	8056238.0
2010-02-09 11:00:00	MSFT	Stock	28.025	28.1	27.75	28.04	11568642.0
2010-02-09 12:00:00	MSFT	Stock	28.04	28.34	28.02	28.191	9967639.0
2010-02-09 13:00:00	MSFT	Stock	28.19	28.25	28.1	28.13	3811014.0
2010-02-09 14:00:00	MSFT	Stock	28.14	28.2	28.02	28.095	5110131.0
2010-02-09 15:00:00	MSFT	Stock	28.09	28.16	27.95	28.01	11190742.0
2010-02-09 16:00:00	MSFT	Stock	28.01	28.125	27.93	28.02	3417937.0
2010-02-09 17:00:00	MSFT	Stock	28.02	28.02	28.02	28.02	2000.0
2010-02-09 19:00:00	MSFT	Stock	28.02	28.06	28.01	28.05	3100.0
2010-02-09 20:00:00	MSFT	Stock	27.72	27.72	27.72	27.72	74500.0
2010-02-09 08:00:00	NVDA	Stock	0.41	0.41	0.41	0.41	80000.0
2010-02-09 09:00:00	NVDA	Stock	0.4098	0.4133	0.404	0.407	82826360.0
2010-02-09 10:00:00	NVDA	Stock	0.4068	0.4095	0.4025	0.4029	175974640.0
2010-02-09 11:00:00	NVDA	Stock	0.403	0.4058	0.3975	0.4038	189030920.0
2010-02-09 12:00:00	NVDA	Stock	0.404	0.4093	0.4025	0.4064	117500560.0
2010-02-09 13:00:00	NVDA	Stock	0.4064	0.408	0.404	0.4055	78478360.0
2010-02-09 14:00:00	NVDA	Stock	0.4058	0.4058	0.403	0.4036	81701480.0
2010-02-09 15:00:00	NVDA	Stock	0.4034	0.4043	0.4003	0.4018	186344120.0
2010-02-09 16:00:00	NVDA	Stock	0.4	0.4044	0.4	0.4018	3542160.0
2010-02-09 19:00:00	NVDA	Stock	0.4025	0.405	0.4025	0.405	18400.0
2010-02-09 06:00:00	AMZN	Stock	5.8415	5.8415	5.8415	5.8415	2000.0
2010-02-09 07:00:00	AMZN	Stock	5.8725	5.89	5.87	5.89	85180.0
2010-02-09 08:00:00	AMZN	Stock	5.8945	5.948	5.88	5.925	733600.0
2010-02-09 09:00:00	AMZN	Stock	5.9255	5.948	5.85	5.903	27519800.0
2010-02-09 10:00:00	AMZN	Stock	5.9035	5.944	5.8835	5.9215	33336060.0
2010-02-09 11:00:00	AMZN	Stock	5.9215	5.944	5.8595	5.925	31380180.0
2010-02-09 12:00:00	AMZN	Stock	5.925	5.9545	5.9065	5.9295	21373760.0
2010-02-09 13:00:00	AMZN	Stock	5.9295	5.9465	5.918	5.9295	12120840.0
2010-02-09 14:00:00	AMZN	Stock	5.9295	5.942	5.9005	5.913	21106000.0
2010-02-09 15:00:00	AMZN	Stock	5.9145	5.928	5.8945	5.902	33331040.0
2010-02-09 16:00:00	AMZN	Stock	5.9015	5.9124	5.895	5.9015	2670540.0

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

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