PREVIEW / stock_1hour / 2010-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-22.parquet
  size:    936 KB
  rows:    44,303
  symbols: 3,548

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-22 05:00:00	AAPL	Stock	11.5914	11.5914	11.5843	11.5843	11200.0
2010-12-22 06:00:00	AAPL	Stock	11.5975	11.5975	11.5975	11.5975	2800.0
2010-12-22 07:00:00	AAPL	Stock	11.5929	11.6143	11.5929	11.6014	140532.0
2010-12-22 08:00:00	AAPL	Stock	11.5964	11.6036	11.5714	11.5832	2855440.0
2010-12-22 09:00:00	AAPL	Stock	11.5861	11.6071	11.5739	11.5846	39001844.0
2010-12-22 10:00:00	AAPL	Stock	11.5839	11.5982	11.5554	11.5979	40651184.0
2010-12-22 11:00:00	AAPL	Stock	11.5975	11.6186	11.5932	11.6107	58719724.0
2010-12-22 12:00:00	AAPL	Stock	11.6111	11.6329	11.61	11.6243	36670592.0
2010-12-22 13:00:00	AAPL	Stock	11.6243	11.6282	11.5968	11.604	19912172.0
2010-12-22 14:00:00	AAPL	Stock	11.6029	11.6161	11.6025	11.6146	12939836.0
2010-12-22 15:00:00	AAPL	Stock	11.6125	11.6286	11.6071	11.6161	33375328.0
2010-12-22 16:00:00	AAPL	Stock	11.6129	11.6211	11.5757	11.6068	6362272.0
2010-12-22 17:00:00	AAPL	Stock	11.6129	11.6129	11.6046	11.6089	365372.0
2010-12-22 18:00:00	AAPL	Stock	11.61	11.6129	11.6075	11.6096	153104.0
2010-12-22 19:00:00	AAPL	Stock	11.6075	11.6121	11.6057	11.6118	162512.0
2010-12-22 05:00:00	MSFT	Stock	28.12	28.12	28.07	28.07	1800.0
2010-12-22 07:00:00	MSFT	Stock	28.11	28.15	28.09	28.12	6195.0
2010-12-22 08:00:00	MSFT	Stock	28.14	28.15	28.11	28.14	15600.0
2010-12-22 09:00:00	MSFT	Stock	28.13	28.4	27.98	28.31	6651074.0
2010-12-22 10:00:00	MSFT	Stock	28.31	28.36	28.18	28.24	9279393.0
2010-12-22 11:00:00	MSFT	Stock	28.239	28.34	28.22	28.25	5343708.0
2010-12-22 12:00:00	MSFT	Stock	28.244	28.33	28.23	28.3	3513751.0
2010-12-22 13:00:00	MSFT	Stock	28.3	28.3	28.2	28.225	3628276.0
2010-12-22 14:00:00	MSFT	Stock	28.22	28.26	28.2	28.2	2723109.0
2010-12-22 15:00:00	MSFT	Stock	28.2	28.25	28.15	28.18	6219225.0
2010-12-22 16:00:00	MSFT	Stock	28.18	28.27	28.07	28.2	1210828.0
2010-12-22 17:00:00	MSFT	Stock	28.18	28.27	28.18	28.27	12150.0
2010-12-22 18:00:00	MSFT	Stock	28.19	28.19	28.19	28.19	660.0
2010-12-22 19:00:00	MSFT	Stock	28.18	28.18	28.0	28.1	3500.0
2010-12-22 08:00:00	NVDA	Stock	0.372	0.372	0.3715	0.3715	160000.0
2010-12-22 09:00:00	NVDA	Stock	0.3705	0.3713	0.3675	0.3688	52379080.0
2010-12-22 10:00:00	NVDA	Stock	0.3685	0.3725	0.3678	0.371	110311160.0
2010-12-22 11:00:00	NVDA	Stock	0.371	0.372	0.3708	0.3719	41888960.0
2010-12-22 12:00:00	NVDA	Stock	0.3718	0.3743	0.3718	0.3728	70066800.0
2010-12-22 13:00:00	NVDA	Stock	0.3729	0.3738	0.3723	0.3726	53452880.0
2010-12-22 14:00:00	NVDA	Stock	0.3725	0.3745	0.372	0.3744	47856280.0
2010-12-22 15:00:00	NVDA	Stock	0.3744	0.3763	0.3741	0.3758	92296840.0
2010-12-22 16:00:00	NVDA	Stock	0.376	0.3778	0.3722	0.3748	3352120.0
2010-12-22 17:00:00	NVDA	Stock	0.376	0.376	0.3758	0.376	126000.0
2010-12-22 18:00:00	NVDA	Stock	0.376	0.376	0.3758	0.3758	25600.0
2010-12-22 19:00:00	NVDA	Stock	0.3758	0.376	0.3758	0.376	46400.0
2010-12-22 07:00:00	AMZN	Stock	9.275	9.2825	9.2575	9.275	251800.0
2010-12-22 08:00:00	AMZN	Stock	9.275	9.275	9.255	9.26	114180.0
2010-12-22 09:00:00	AMZN	Stock	9.26	9.2725	9.2415	9.2555	8809240.0
2010-12-22 10:00:00	AMZN	Stock	9.256	9.269	9.2055	9.235	10029980.0
2010-12-22 11:00:00	AMZN	Stock	9.234	9.26	9.2265	9.2478	5800460.0
2010-12-22 12:00:00	AMZN	Stock	9.2485	9.256	9.214	9.2285	5612060.0
2010-12-22 13:00:00	AMZN	Stock	9.2285	9.245	9.207	9.2235	4858440.0
2010-12-22 14:00:00	AMZN	Stock	9.2235	9.2365	9.2125	9.2325	3816480.0
2010-12-22 15:00:00	AMZN	Stock	9.2315	9.2545	9.228	9.238	10186720.0

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

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