PREVIEW / stock_1hour / 2010-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-18.parquet
  size:    936 KB
  rows:    44,753
  symbols: 3,478

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-18 04:00:00	AAPL	Stock	9.1293	9.1357	9.0982	9.1061	33600.0
2010-05-18 05:00:00	AAPL	Stock	9.1075	9.1161	9.1071	9.1071	47684.0
2010-05-18 07:00:00	AAPL	Stock	9.1375	9.1482	9.125	9.1389	599004.0
2010-05-18 08:00:00	AAPL	Stock	9.1429	9.1607	9.1082	9.1571	5070212.0
2010-05-18 09:00:00	AAPL	Stock	9.1557	9.2339	9.1536	9.1868	97686456.0
2010-05-18 10:00:00	AAPL	Stock	9.1868	9.2032	8.9996	9.0571	162496236.0
2010-05-18 11:00:00	AAPL	Stock	9.0575	9.1032	9.0107	9.0357	87896648.0
2010-05-18 12:00:00	AAPL	Stock	9.0357	9.1132	9.0039	9.0746	75649952.0
2010-05-18 13:00:00	AAPL	Stock	9.0736	9.0741	8.9804	8.9843	93947812.0
2010-05-18 14:00:00	AAPL	Stock	8.9821	9.0389	8.9379	8.9657	104583752.0
2010-05-18 15:00:00	AAPL	Stock	8.9666	9.0386	8.9425	9.0118	129986808.0
2010-05-18 16:00:00	AAPL	Stock	9.0075	9.1871	8.9546	9.0064	15586172.0
2010-05-18 17:00:00	AAPL	Stock	9.0064	9.0732	8.9732	8.975	1013348.0
2010-05-18 18:00:00	AAPL	Stock	8.9743	9.0129	8.9429	8.9429	698600.0
2010-05-18 19:00:00	AAPL	Stock	8.9429	8.9536	8.9179	8.9286	1101324.0
2010-05-18 08:00:00	MSFT	Stock	29.0	29.09	28.86	29.09	8868.0
2010-05-18 09:00:00	MSFT	Stock	29.03	29.05	28.76	28.89	3424838.0
2010-05-18 10:00:00	MSFT	Stock	28.88	28.93	28.47	28.51	7766328.0
2010-05-18 11:00:00	MSFT	Stock	28.51	28.77	28.48	28.61	7510365.0
2010-05-18 12:00:00	MSFT	Stock	28.61	28.72	28.53	28.64	5818630.0
2010-05-18 13:00:00	MSFT	Stock	28.63	28.67	28.45	28.49	7173334.0
2010-05-18 14:00:00	MSFT	Stock	28.49	28.65	28.4	28.492	5964465.0
2010-05-18 15:00:00	MSFT	Stock	28.49	28.66	28.4	28.62	11390057.0
2010-05-18 16:00:00	MSFT	Stock	28.62	28.797	28.467	28.62	2644342.0
2010-05-18 17:00:00	MSFT	Stock	28.62	28.62	28.47	28.47	16481.0
2010-05-18 18:00:00	MSFT	Stock	28.46	28.6	28.45	28.5	17450.0
2010-05-18 19:00:00	MSFT	Stock	28.45	28.5	28.4	28.46	4902.0
2010-05-18 07:00:00	NVDA	Stock	0.325	0.325	0.325	0.325	40000.0
2010-05-18 08:00:00	NVDA	Stock	0.326	0.3288	0.3253	0.3275	464320.0
2010-05-18 09:00:00	NVDA	Stock	0.3275	0.3295	0.3243	0.3245	61475200.0
2010-05-18 10:00:00	NVDA	Stock	0.3245	0.3245	0.3155	0.3175	148194400.0
2010-05-18 11:00:00	NVDA	Stock	0.3175	0.3213	0.3168	0.318	66925880.0
2010-05-18 12:00:00	NVDA	Stock	0.318	0.321	0.3163	0.319	43677040.0
2010-05-18 13:00:00	NVDA	Stock	0.3188	0.3198	0.315	0.3153	83009800.0
2010-05-18 14:00:00	NVDA	Stock	0.3153	0.3168	0.3125	0.3131	105323000.0
2010-05-18 15:00:00	NVDA	Stock	0.3131	0.316	0.3123	0.3143	142571200.0
2010-05-18 16:00:00	NVDA	Stock	0.314	0.3251	0.313	0.3145	3445760.0
2010-05-18 17:00:00	NVDA	Stock	0.3145	0.3205	0.3125	0.3128	4575160.0
2010-05-18 18:00:00	NVDA	Stock	0.3128	0.3128	0.3125	0.3125	98000.0
2010-05-18 19:00:00	NVDA	Stock	0.313	0.313	0.3125	0.3125	62000.0
2010-05-18 07:00:00	AMZN	Stock	6.5375	6.5375	6.5375	6.5375	2000.0
2010-05-18 08:00:00	AMZN	Stock	6.534	6.5345	6.504	6.5095	107100.0
2010-05-18 09:00:00	AMZN	Stock	6.5125	6.5625	6.4785	6.5075	9958340.0
2010-05-18 10:00:00	AMZN	Stock	6.5075	6.526	6.39	6.4295	17422420.0
2010-05-18 11:00:00	AMZN	Stock	6.4275	6.4715	6.3785	6.3935	12430020.0
2010-05-18 12:00:00	AMZN	Stock	6.391	6.4375	6.3775	6.4048	11129340.0
2010-05-18 13:00:00	AMZN	Stock	6.4035	6.405	6.3235	6.3325	13688260.0
2010-05-18 14:00:00	AMZN	Stock	6.334	6.369	6.2775	6.302	14016480.0
2010-05-18 15:00:00	AMZN	Stock	6.305	6.3435	6.2755	6.314	23756300.0
2010-05-18 16:00:00	AMZN	Stock	6.314	6.4448	6.302	6.32	2046280.0

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

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