PREVIEW / stock_1hour / 2010-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-05.parquet
  size:    937 KB
  rows:    44,506
  symbols: 3,481

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-05-05 04:00:00	AAPL	Stock	9.1536	9.1679	9.1393	9.1393	22400.0
2010-05-05 05:00:00	AAPL	Stock	9.1679	9.2168	9.1679	9.2057	130872.0
2010-05-05 06:00:00	AAPL	Stock	9.2007	9.2032	9.2007	9.2032	30520.0
2010-05-05 07:00:00	AAPL	Stock	9.1929	9.2089	9.1786	9.1929	361564.0
2010-05-05 08:00:00	AAPL	Stock	9.1911	9.2	9.0593	9.0696	7358204.0
2010-05-05 09:00:00	AAPL	Stock	9.0679	9.07	8.8832	8.9807	211171632.0
2010-05-05 10:00:00	AAPL	Stock	8.9807	9.1314	8.9518	9.1025	201409012.0
2010-05-05 11:00:00	AAPL	Stock	9.1043	9.2079	9.0518	9.2043	95331488.0
2010-05-05 12:00:00	AAPL	Stock	9.2014	9.2193	9.085	9.1246	79592828.0
2010-05-05 13:00:00	AAPL	Stock	9.1229	9.1729	9.1143	9.1471	46524324.0
2010-05-05 14:00:00	AAPL	Stock	9.1454	9.1607	9.0471	9.11	82810308.0
2010-05-05 15:00:00	AAPL	Stock	9.1075	9.1511	9.0546	9.1471	100877980.0
2010-05-05 16:00:00	AAPL	Stock	9.1493	9.1493	8.6643	9.1214	9458764.0
2010-05-05 17:00:00	AAPL	Stock	9.1196	9.1429	9.115	9.1393	380800.0
2010-05-05 18:00:00	AAPL	Stock	9.1379	9.1482	9.1293	9.1475	693476.0
2010-05-05 19:00:00	AAPL	Stock	9.1475	9.1554	9.1429	9.1464	518196.0
2010-05-05 20:00:00	AAPL	Stock	9.1446	9.1446	9.1446	9.1446	210000.0
2010-05-05 07:00:00	MSFT	Stock	29.86	29.96	29.86	29.94	5020.0
2010-05-05 08:00:00	MSFT	Stock	29.96	29.99	29.9	29.93	50872.0
2010-05-05 09:00:00	MSFT	Stock	29.93	30.09	29.69	29.88	8147596.0
2010-05-05 10:00:00	MSFT	Stock	29.87	30.04	29.85	29.985	12576941.0
2010-05-05 11:00:00	MSFT	Stock	29.985	30.0	29.92	29.958	8355284.0
2010-05-05 12:00:00	MSFT	Stock	29.96	29.97	29.86	29.93	7006473.0
2010-05-05 13:00:00	MSFT	Stock	29.93	29.97	29.88	29.92	5684254.0
2010-05-05 14:00:00	MSFT	Stock	29.93	29.93	29.83	29.83	8801973.0
2010-05-05 15:00:00	MSFT	Stock	29.835	29.88	29.76	29.85	13696279.0
2010-05-05 16:00:00	MSFT	Stock	29.86	30.304	29.804	29.85	1292859.0
2010-05-05 17:00:00	MSFT	Stock	29.84	29.84	29.8	29.8	6550.0
2010-05-05 18:00:00	MSFT	Stock	29.83	29.85	29.78	29.82	137603.0
2010-05-05 19:00:00	MSFT	Stock	29.82	29.87	29.81	29.87	4016.0
2010-05-05 20:00:00	MSFT	Stock	29.94	29.94	29.94	29.94	1800.0
2010-05-05 06:00:00	NVDA	Stock	0.3695	0.3695	0.3695	0.3695	14400.0
2010-05-05 07:00:00	NVDA	Stock	0.3708	0.3805	0.3708	0.3765	41600.0
2010-05-05 08:00:00	NVDA	Stock	0.3705	0.375	0.3665	0.368	971480.0
2010-05-05 09:00:00	NVDA	Stock	0.3665	0.3675	0.3588	0.3665	136451280.0
2010-05-05 10:00:00	NVDA	Stock	0.3662	0.37	0.362	0.3698	234760520.0
2010-05-05 11:00:00	NVDA	Stock	0.3698	0.371	0.3668	0.3705	206396880.0
2010-05-05 12:00:00	NVDA	Stock	0.3705	0.3718	0.3638	0.364	183375320.0
2010-05-05 13:00:00	NVDA	Stock	0.364	0.3666	0.363	0.363	111456720.0
2010-05-05 14:00:00	NVDA	Stock	0.3631	0.3665	0.358	0.3604	160284920.0
2010-05-05 15:00:00	NVDA	Stock	0.3602	0.3632	0.36	0.3628	197233360.0
2010-05-05 16:00:00	NVDA	Stock	0.3628	0.3664	0.361	0.3623	71919240.0
2010-05-05 17:00:00	NVDA	Stock	0.3635	0.3638	0.3635	0.3638	204000.0
2010-05-05 18:00:00	NVDA	Stock	0.3648	0.365	0.3648	0.365	204000.0
2010-05-05 19:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	16000.0
2010-05-05 08:00:00	AMZN	Stock	6.48	6.48	6.402	6.409	390840.0
2010-05-05 09:00:00	AMZN	Stock	6.4025	6.502	6.3775	6.4995	29625440.0
2010-05-05 10:00:00	AMZN	Stock	6.498	6.547	6.434	6.5375	35876980.0
2010-05-05 11:00:00	AMZN	Stock	6.5375	6.5805	6.5	6.5675	25136920.0
2010-05-05 12:00:00	AMZN	Stock	6.5675	6.5675	6.46	6.517	20249280.0

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

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