PREVIEW / stock_1hour / 2008-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-07.parquet
  size:    857 KB
  rows:    41,928
  symbols: 3,343

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
2008-07-07 05:00:00	AAPL	Stock	6.1136	6.1136	6.1136	6.1136	2800.0
2008-07-07 06:00:00	AAPL	Stock	6.1125	6.1125	6.1125	6.1125	24724.0
2008-07-07 07:00:00	AAPL	Stock	6.1107	6.15	6.1057	6.1357	494620.0
2008-07-07 08:00:00	AAPL	Stock	6.1361	6.1796	6.1246	6.1707	3318448.0
2008-07-07 09:00:00	AAPL	Stock	6.1679	6.3261	6.1625	6.2775	109867800.0
2008-07-07 10:00:00	AAPL	Stock	6.2771	6.3132	6.2432	6.2871	129713976.0
2008-07-07 11:00:00	AAPL	Stock	6.2864	6.3104	6.2536	6.2779	84365680.0
2008-07-07 12:00:00	AAPL	Stock	6.2779	6.2929	6.1711	6.1768	120535128.0
2008-07-07 13:00:00	AAPL	Stock	6.1775	6.2271	6.1393	6.2179	93265004.0
2008-07-07 14:00:00	AAPL	Stock	6.2189	6.2396	6.1746	6.1893	90411916.0
2008-07-07 15:00:00	AAPL	Stock	6.1865	6.3139	6.1865	6.2539	167107416.0
2008-07-07 16:00:00	AAPL	Stock	6.2526	6.2697	6.2438	6.2536	9949604.0
2008-07-07 17:00:00	AAPL	Stock	6.2536	6.2664	6.2529	6.2607	368564.0
2008-07-07 18:00:00	AAPL	Stock	6.2589	6.3039	6.1511	6.2826	2940924.0
2008-07-07 19:00:00	AAPL	Stock	6.2593	6.2636	6.2557	6.2575	177912.0
2008-07-07 07:00:00	MSFT	Stock	26.04	26.17	26.04	26.17	1200.0
2008-07-07 08:00:00	MSFT	Stock	26.13	26.24	26.1	26.24	46627.0
2008-07-07 09:00:00	MSFT	Stock	26.25	26.39	26.02	26.3	7376746.0
2008-07-07 10:00:00	MSFT	Stock	26.29	26.35	26.12	26.16	8494587.0
2008-07-07 11:00:00	MSFT	Stock	26.17	26.2	25.9	26.01	9981816.0
2008-07-07 12:00:00	MSFT	Stock	26.01	26.05	25.63	25.64	8007266.0
2008-07-07 13:00:00	MSFT	Stock	25.64	25.7	25.5	25.552	7021210.0
2008-07-07 14:00:00	MSFT	Stock	25.55	25.81	25.45	25.792	8962469.0
2008-07-07 15:00:00	MSFT	Stock	25.8	26.28	25.8	26.018	16348467.0
2008-07-07 16:00:00	MSFT	Stock	26.03	26.179	25.93	25.93	3180592.0
2008-07-07 17:00:00	MSFT	Stock	25.92	26.03	25.91	25.98	24829.0
2008-07-07 18:00:00	MSFT	Stock	26.0	26.34	25.47	26.09	344263.0
2008-07-07 19:00:00	MSFT	Stock	26.05	26.11	26.03	26.11	7450.0
2008-07-07 07:00:00	NVDA	Stock	0.3185	0.3188	0.3175	0.3175	100000.0
2008-07-07 08:00:00	NVDA	Stock	0.3183	0.3183	0.3123	0.315	6336120.0
2008-07-07 09:00:00	NVDA	Stock	0.314	0.32	0.308	0.3175	301712080.0
2008-07-07 10:00:00	NVDA	Stock	0.3175	0.3185	0.31	0.3113	373609400.0
2008-07-07 11:00:00	NVDA	Stock	0.3113	0.3113	0.3028	0.3042	294781240.0
2008-07-07 12:00:00	NVDA	Stock	0.304	0.3046	0.2948	0.2955	293371800.0
2008-07-07 13:00:00	NVDA	Stock	0.2952	0.3008	0.294	0.2979	214033600.0
2008-07-07 14:00:00	NVDA	Stock	0.2978	0.3022	0.297	0.2995	253099200.0
2008-07-07 15:00:00	NVDA	Stock	0.2992	0.309	0.2992	0.3025	399108480.0
2008-07-07 16:00:00	NVDA	Stock	0.3025	0.3062	0.301	0.302	20042920.0
2008-07-07 17:00:00	NVDA	Stock	0.3025	0.3025	0.3012	0.3012	124720.0
2008-07-07 18:00:00	NVDA	Stock	0.3012	0.3175	0.295	0.3012	5722080.0
2008-07-07 19:00:00	NVDA	Stock	0.3025	0.3035	0.3025	0.3035	24000.0
2008-07-07 09:00:00	AMZN	Stock	3.6195	3.72	3.6185	3.708	16209780.0
2008-07-07 10:00:00	AMZN	Stock	3.7085	3.719	3.6575	3.684	23769100.0
2008-07-07 11:00:00	AMZN	Stock	3.684	3.6935	3.6435	3.6535	9737820.0
2008-07-07 12:00:00	AMZN	Stock	3.653	3.673	3.575	3.576	17446780.0
2008-07-07 13:00:00	AMZN	Stock	3.5765	3.5785	3.538	3.5615	18218220.0
2008-07-07 14:00:00	AMZN	Stock	3.562	3.6005	3.548	3.5785	14057540.0
2008-07-07 15:00:00	AMZN	Stock	3.5765	3.664	3.576	3.6245	40082720.0
2008-07-07 16:00:00	AMZN	Stock	3.625	3.6316	3.6164	3.6165	2299360.0
2008-07-07 17:00:00	AMZN	Stock	3.6245	3.6245	3.6165	3.6165	16020.0

> showing 50 of 41,928 rows — these rows as CSV

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