PREVIEW / stock_1hour / 2010-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-23.parquet
  size:    917 KB
  rows:    43,467
  symbols: 3,526

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-23 04:00:00	AAPL	Stock	11.6054	11.6054	11.6054	11.6054	2800.0
2010-12-23 06:00:00	AAPL	Stock	11.6411	11.6411	11.6411	11.6411	2800.0
2010-12-23 07:00:00	AAPL	Stock	11.625	11.625	11.6018	11.6111	145684.0
2010-12-23 08:00:00	AAPL	Stock	11.6071	11.6129	11.6007	11.6114	797916.0
2010-12-23 09:00:00	AAPL	Stock	11.6104	11.6125	11.5893	11.5907	27694408.0
2010-12-23 10:00:00	AAPL	Stock	11.5907	11.6004	11.5529	11.56	43627752.0
2010-12-23 11:00:00	AAPL	Stock	11.5618	11.5875	11.5607	11.5677	29992396.0
2010-12-23 12:00:00	AAPL	Stock	11.5661	11.57	11.5482	11.5582	16801288.0
2010-12-23 13:00:00	AAPL	Stock	11.5584	11.5668	11.5564	11.56	11662504.0
2010-12-23 14:00:00	AAPL	Stock	11.5609	11.5614	11.5418	11.5532	24301704.0
2010-12-23 15:00:00	AAPL	Stock	11.5539	11.5668	11.5505	11.5571	28221984.0
2010-12-23 16:00:00	AAPL	Stock	11.5561	11.5964	11.5482	11.5571	35974176.0
2010-12-23 17:00:00	AAPL	Stock	11.5543	11.5575	11.5529	11.5536	290332.0
2010-12-23 18:00:00	AAPL	Stock	11.5536	11.5589	11.5518	11.5571	130676.0
2010-12-23 19:00:00	AAPL	Stock	11.5589	11.5593	11.5486	11.5504	215516.0
2010-12-23 04:00:00	MSFT	Stock	28.12	28.12	28.1	28.1	1000.0
2010-12-23 06:00:00	MSFT	Stock	28.09	28.09	28.09	28.09	900.0
2010-12-23 07:00:00	MSFT	Stock	28.08	28.08	28.08	28.08	1100.0
2010-12-23 08:00:00	MSFT	Stock	28.1	28.16	28.1	28.11	6200.0
2010-12-23 09:00:00	MSFT	Stock	28.11	28.29	27.96	28.212	2983739.0
2010-12-23 10:00:00	MSFT	Stock	28.22	28.28	28.17	28.23	3710283.0
2010-12-23 11:00:00	MSFT	Stock	28.23	28.245	28.15	28.16	3374905.0
2010-12-23 12:00:00	MSFT	Stock	28.17	28.21	28.14	28.2	1951413.0
2010-12-23 13:00:00	MSFT	Stock	28.2	28.27	28.2	28.21	2170211.0
2010-12-23 14:00:00	MSFT	Stock	28.211	28.29	28.17	28.29	3557236.0
2010-12-23 15:00:00	MSFT	Stock	28.29	28.32	28.25	28.31	5321084.0
2010-12-23 16:00:00	MSFT	Stock	28.3	28.312	28.143	28.288	1222391.0
2010-12-23 17:00:00	MSFT	Stock	28.31	28.31	28.31	28.31	400.0
2010-12-23 18:00:00	MSFT	Stock	28.3	28.3	28.3	28.3	11300.0
2010-12-23 08:00:00	NVDA	Stock	0.376	0.376	0.376	0.376	152000.0
2010-12-23 09:00:00	NVDA	Stock	0.3758	0.3758	0.3715	0.3725	44893000.0
2010-12-23 10:00:00	NVDA	Stock	0.3725	0.373	0.3715	0.3728	55318680.0
2010-12-23 11:00:00	NVDA	Stock	0.3728	0.374	0.3725	0.3728	39163600.0
2010-12-23 12:00:00	NVDA	Stock	0.3728	0.3736	0.3723	0.3723	33914960.0
2010-12-23 13:00:00	NVDA	Stock	0.3723	0.373	0.3723	0.3727	19349520.0
2010-12-23 14:00:00	NVDA	Stock	0.3728	0.3738	0.3725	0.3735	22126880.0
2010-12-23 15:00:00	NVDA	Stock	0.3735	0.3738	0.3725	0.3728	49974040.0
2010-12-23 16:00:00	NVDA	Stock	0.373	0.3738	0.3725	0.3738	8691440.0
2010-12-23 17:00:00	NVDA	Stock	0.3738	0.3763	0.3738	0.3753	63320.0
2010-12-23 08:00:00	AMZN	Stock	9.25	9.25	9.221	9.221	87500.0
2010-12-23 09:00:00	AMZN	Stock	9.2165	9.249	9.18	9.1925	8185480.0
2010-12-23 10:00:00	AMZN	Stock	9.195	9.1985	9.0945	9.1213	16034660.0
2010-12-23 11:00:00	AMZN	Stock	9.1205	9.162	9.117	9.1435	6071840.0
2010-12-23 12:00:00	AMZN	Stock	9.144	9.147	9.1165	9.138	6201500.0
2010-12-23 13:00:00	AMZN	Stock	9.139	9.15	9.13	9.1305	3807300.0
2010-12-23 14:00:00	AMZN	Stock	9.13	9.1395	9.1015	9.1145	8452740.0
2010-12-23 15:00:00	AMZN	Stock	9.1145	9.1405	9.1135	9.1305	13050760.0
2010-12-23 16:00:00	AMZN	Stock	9.1295	9.1385	9.1205	9.1385	3482100.0
2010-12-23 17:00:00	AMZN	Stock	9.1385	9.139	9.1335	9.1375	36800.0
2010-12-23 18:00:00	AMZN	Stock	9.135	9.1375	9.1295	9.135	26280.0

> showing 50 of 43,467 rows — these rows as CSV

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