PREVIEW / stock_1hour / 2010-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-14.parquet
  size:    904 KB
  rows:    43,436
  symbols: 3,467

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-06-14 04:00:00	AAPL	Stock	9.0943	9.1039	9.0921	9.1039	14000.0
2010-06-14 05:00:00	AAPL	Stock	9.1204	9.1729	9.1204	9.1521	40656.0
2010-06-14 06:00:00	AAPL	Stock	9.1643	9.1643	9.1429	9.1429	31528.0
2010-06-14 07:00:00	AAPL	Stock	9.1293	9.1429	9.1129	9.1375	405776.0
2010-06-14 08:00:00	AAPL	Stock	9.1361	9.1504	9.0686	9.1471	2602068.0
2010-06-14 09:00:00	AAPL	Stock	9.1457	9.1889	9.1161	9.175	89004804.0
2010-06-14 10:00:00	AAPL	Stock	9.1764	9.2336	9.1721	9.2175	97159664.0
2010-06-14 11:00:00	AAPL	Stock	9.2179	9.2554	9.2093	9.2296	62136480.0
2010-06-14 12:00:00	AAPL	Stock	9.2307	9.2475	9.2021	9.2054	41587924.0
2010-06-14 13:00:00	AAPL	Stock	9.2057	9.2171	9.1579	9.1586	68765256.0
2010-06-14 14:00:00	AAPL	Stock	9.1607	9.1761	9.1	9.1471	100812404.0
2010-06-14 15:00:00	AAPL	Stock	9.1464	9.1832	9.0718	9.0779	122204572.0
2010-06-14 16:00:00	AAPL	Stock	9.0782	9.2047	9.0732	9.0868	11990804.0
2010-06-14 17:00:00	AAPL	Stock	9.2452	9.2452	9.0832	9.0971	219128.0
2010-06-14 18:00:00	AAPL	Stock	9.0993	9.1061	9.0814	9.0929	417620.0
2010-06-14 19:00:00	AAPL	Stock	9.1036	9.1071	9.0936	9.1071	472920.0
2010-06-14 06:00:00	MSFT	Stock	25.91	25.91	25.91	25.91	365.0
2010-06-14 07:00:00	MSFT	Stock	25.9	25.9	25.84	25.86	5625.0
2010-06-14 08:00:00	MSFT	Stock	25.86	25.9	25.86	25.88	14974.0
2010-06-14 09:00:00	MSFT	Stock	25.88	25.96	25.54	25.65	8073755.0
2010-06-14 10:00:00	MSFT	Stock	25.65	25.84	25.63	25.815	9135702.0
2010-06-14 11:00:00	MSFT	Stock	25.815	25.84	25.61	25.66	5745572.0
2010-06-14 12:00:00	MSFT	Stock	25.66	25.77	25.65	25.705	4622421.0
2010-06-14 13:00:00	MSFT	Stock	25.7	25.78	25.6	25.61	5545668.0
2010-06-14 14:00:00	MSFT	Stock	25.61	25.7	25.55	25.685	4701630.0
2010-06-14 15:00:00	MSFT	Stock	25.685	25.71	25.47	25.49	9266357.0
2010-06-14 16:00:00	MSFT	Stock	25.5	25.729	25.49	25.59	2201589.0
2010-06-14 17:00:00	MSFT	Stock	25.725	25.725	25.57	25.57	22264.0
2010-06-14 18:00:00	MSFT	Stock	25.5	25.6	25.5	25.6	29938.0
2010-06-14 19:00:00	MSFT	Stock	25.59	25.65	25.57	25.65	11760.0
2010-06-14 08:00:00	NVDA	Stock	0.2962	0.2965	0.2938	0.2955	236000.0
2010-06-14 09:00:00	NVDA	Stock	0.2958	0.2958	0.2895	0.291	67973720.0
2010-06-14 10:00:00	NVDA	Stock	0.2912	0.2925	0.2896	0.2915	63978560.0
2010-06-14 11:00:00	NVDA	Stock	0.2918	0.2935	0.291	0.2935	32989680.0
2010-06-14 12:00:00	NVDA	Stock	0.2932	0.294	0.2888	0.2888	32583120.0
2010-06-14 13:00:00	NVDA	Stock	0.289	0.2895	0.286	0.286	47204280.0
2010-06-14 14:00:00	NVDA	Stock	0.2861	0.2868	0.2845	0.2865	49141360.0
2010-06-14 15:00:00	NVDA	Stock	0.2865	0.2868	0.2832	0.2838	74002360.0
2010-06-14 16:00:00	NVDA	Stock	0.2835	0.2889	0.2835	0.2858	3432160.0
2010-06-14 17:00:00	NVDA	Stock	0.284	0.2852	0.2832	0.2852	120000.0
2010-06-14 18:00:00	NVDA	Stock	0.2852	0.2852	0.2852	0.2852	96000.0
2010-06-14 08:00:00	AMZN	Stock	6.175	6.22	6.175	6.2	81820.0
2010-06-14 09:00:00	AMZN	Stock	6.1945	6.2575	6.175	6.236	11301300.0
2010-06-14 10:00:00	AMZN	Stock	6.235	6.285	6.2115	6.2417	11971280.0
2010-06-14 11:00:00	AMZN	Stock	6.242	6.2745	6.225	6.2325	6918400.0
2010-06-14 12:00:00	AMZN	Stock	6.23	6.2485	6.216	6.2245	7413880.0
2010-06-14 13:00:00	AMZN	Stock	6.224	6.265	6.197	6.197	9917280.0
2010-06-14 14:00:00	AMZN	Stock	6.1975	6.2485	6.1805	6.2375	10226100.0
2010-06-14 15:00:00	AMZN	Stock	6.2346	6.2445	6.181	6.1935	16836640.0
2010-06-14 16:00:00	AMZN	Stock	6.195	6.217	6.1915	6.2125	418840.0

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

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