PREVIEW / stock_1hour / 2010-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-21.parquet
  size:    938 KB
  rows:    44,633
  symbols: 3,546

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-12-21 04:00:00	AAPL	Stock	11.5357	11.5357	11.5357	11.5357	2800.0
2010-12-21 06:00:00	AAPL	Stock	11.5139	11.5139	11.5139	11.5139	2800.0
2010-12-21 07:00:00	AAPL	Stock	11.5243	11.5639	11.5243	11.5632	439264.0
2010-12-21 08:00:00	AAPL	Stock	11.5575	11.5589	11.5261	11.5339	3058384.0
2010-12-21 09:00:00	AAPL	Stock	11.5336	11.5671	11.5018	11.5289	51489816.0
2010-12-21 10:00:00	AAPL	Stock	11.5304	11.5804	11.5286	11.5639	46562012.0
2010-12-21 11:00:00	AAPL	Stock	11.5654	11.5854	11.5504	11.5632	26984356.0
2010-12-21 12:00:00	AAPL	Stock	11.563	11.5828	11.5589	11.5796	19128592.0
2010-12-21 13:00:00	AAPL	Stock	11.5796	11.5796	11.5618	11.575	16039436.0
2010-12-21 14:00:00	AAPL	Stock	11.5736	11.58	11.5625	11.5675	15067444.0
2010-12-21 15:00:00	AAPL	Stock	11.5679	11.5825	11.5536	11.5789	48894748.0
2010-12-21 16:00:00	AAPL	Stock	11.5787	11.5793	11.5469	11.5718	8208676.0
2010-12-21 17:00:00	AAPL	Stock	11.5714	11.575	11.5679	11.575	434700.0
2010-12-21 18:00:00	AAPL	Stock	11.5729	11.5786	11.5714	11.5782	231980.0
2010-12-21 19:00:00	AAPL	Stock	11.5796	11.5804	11.575	11.5771	249480.0
2010-12-21 07:00:00	MSFT	Stock	27.99	27.99	27.9	27.9	4000.0
2010-12-21 08:00:00	MSFT	Stock	27.9	27.98	27.9	27.96	13232.0
2010-12-21 09:00:00	MSFT	Stock	27.96	27.96	27.76	27.92	4297173.0
2010-12-21 10:00:00	MSFT	Stock	27.915	28.06	27.87	28.06	6903015.0
2010-12-21 11:00:00	MSFT	Stock	28.05	28.07	27.95	27.958	3577586.0
2010-12-21 12:00:00	MSFT	Stock	27.95	28.0	27.95	27.975	2090640.0
2010-12-21 13:00:00	MSFT	Stock	27.98	28.08	27.91	28.08	5674592.0
2010-12-21 14:00:00	MSFT	Stock	28.08	28.085	27.97	28.025	3326349.0
2010-12-21 15:00:00	MSFT	Stock	28.02	28.14	28.015	28.07	8977264.0
2010-12-21 16:00:00	MSFT	Stock	28.07	28.15	27.924	28.1	2059937.0
2010-12-21 17:00:00	MSFT	Stock	28.1	28.24	28.1	28.22	49522.0
2010-12-21 18:00:00	MSFT	Stock	28.22	28.26	28.07	28.18	37560.0
2010-12-21 19:00:00	MSFT	Stock	28.2	28.2	28.14	28.17	8930.0
2010-12-21 08:00:00	NVDA	Stock	0.3615	0.3615	0.36	0.3608	646400.0
2010-12-21 09:00:00	NVDA	Stock	0.3615	0.369	0.3608	0.3676	123396560.0
2010-12-21 10:00:00	NVDA	Stock	0.3676	0.3715	0.3675	0.3684	91972760.0
2010-12-21 11:00:00	NVDA	Stock	0.3684	0.3705	0.3678	0.3694	44718400.0
2010-12-21 12:00:00	NVDA	Stock	0.3694	0.37	0.3682	0.3699	32837520.0
2010-12-21 13:00:00	NVDA	Stock	0.3699	0.37	0.368	0.3688	23642840.0
2010-12-21 14:00:00	NVDA	Stock	0.3688	0.3698	0.3685	0.3695	23746200.0
2010-12-21 15:00:00	NVDA	Stock	0.3695	0.3718	0.3695	0.3718	104355000.0
2010-12-21 16:00:00	NVDA	Stock	0.3715	0.3718	0.3686	0.3717	7028400.0
2010-12-21 17:00:00	NVDA	Stock	0.3713	0.3723	0.3713	0.3723	144000.0
2010-12-21 18:00:00	NVDA	Stock	0.372	0.3725	0.3718	0.3725	42040.0
2010-12-21 19:00:00	NVDA	Stock	0.3715	0.3715	0.3715	0.3715	8000.0
2010-12-21 06:00:00	AMZN	Stock	9.317	9.3625	9.317	9.3625	4000.0
2010-12-21 07:00:00	AMZN	Stock	9.21	9.2255	9.1755	9.22	55800.0
2010-12-21 08:00:00	AMZN	Stock	9.2025	9.2175	9.1525	9.1905	492180.0
2010-12-21 09:00:00	AMZN	Stock	9.1875	9.217	9.13	9.168	16896840.0
2010-12-21 10:00:00	AMZN	Stock	9.168	9.1975	9.1325	9.157	15448460.0
2010-12-21 11:00:00	AMZN	Stock	9.157	9.175	9.1475	9.1654	5938040.0
2010-12-21 12:00:00	AMZN	Stock	9.1646	9.167	9.1325	9.15	8652820.0
2010-12-21 13:00:00	AMZN	Stock	9.152	9.193	9.147	9.189	7679120.0
2010-12-21 14:00:00	AMZN	Stock	9.19	9.2825	9.1894	9.2612	28727720.0
2010-12-21 15:00:00	AMZN	Stock	9.261	9.265	9.2285	9.2375	15610220.0

> showing 50 of 44,633 rows — these rows as CSV

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