PREVIEW / stock_1hour / 2008-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-02.parquet
  size:    800 KB
  rows:    39,268
  symbols: 3,279

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-04-02 04:00:00	AAPL	Stock	5.3614	5.3614	5.3546	5.3546	19600.0
2008-04-02 07:00:00	AAPL	Stock	5.3493	5.3661	5.3143	5.3282	1641920.0
2008-04-02 08:00:00	AAPL	Stock	5.3282	5.3404	5.3036	5.3214	9268560.0
2008-04-02 09:00:00	AAPL	Stock	5.3196	5.35	5.2832	5.3229	148757448.0
2008-04-02 10:00:00	AAPL	Stock	5.3221	5.4	5.3011	5.3782	208406828.0
2008-04-02 11:00:00	AAPL	Stock	5.3782	5.3821	5.3457	5.3489	105081900.0
2008-04-02 12:00:00	AAPL	Stock	5.3496	5.3657	5.2732	5.2811	130507860.0
2008-04-02 13:00:00	AAPL	Stock	5.2821	5.3061	5.2536	5.2825	117572756.0
2008-04-02 14:00:00	AAPL	Stock	5.2822	5.3189	5.2293	5.2396	123589172.0
2008-04-02 15:00:00	AAPL	Stock	5.24	5.2679	5.2089	5.2668	155722392.0
2008-04-02 16:00:00	AAPL	Stock	5.2668	5.3393	5.2143	5.3161	17613820.0
2008-04-02 17:00:00	AAPL	Stock	5.3107	5.3411	5.3071	5.325	5620860.0
2008-04-02 18:00:00	AAPL	Stock	5.3232	5.33	5.3036	5.3171	1137808.0
2008-04-02 19:00:00	AAPL	Stock	5.3164	5.3171	5.3107	5.3171	471212.0
2008-04-02 07:00:00	MSFT	Stock	29.49	29.49	29.49	29.49	100.0
2008-04-02 08:00:00	MSFT	Stock	29.5	29.64	29.49	29.64	52489.0
2008-04-02 09:00:00	MSFT	Stock	29.65	29.67	29.082	29.19	9738916.0
2008-04-02 10:00:00	MSFT	Stock	29.19	29.34	29.14	29.27	8631212.0
2008-04-02 11:00:00	MSFT	Stock	29.28	29.3	29.2	29.29	5319546.0
2008-04-02 12:00:00	MSFT	Stock	29.283	29.32	29.2	29.24	4037611.0
2008-04-02 13:00:00	MSFT	Stock	29.24	29.25	29.13	29.15	4003742.0
2008-04-02 14:00:00	MSFT	Stock	29.16	29.23	29.0	29.079	5907417.0
2008-04-02 15:00:00	MSFT	Stock	29.08	29.17	29.0	29.15	8635337.0
2008-04-02 16:00:00	MSFT	Stock	29.16	29.24	29.099	29.21	1470493.0
2008-04-02 17:00:00	MSFT	Stock	29.21	29.23	29.2	29.22	9129.0
2008-04-02 18:00:00	MSFT	Stock	29.2	29.2	29.18	29.2	6100.0
2008-04-02 19:00:00	MSFT	Stock	29.2	29.2	29.18	29.2	861.0
2008-04-02 08:00:00	NVDA	Stock	0.5287	0.5298	0.5262	0.5275	251200.0
2008-04-02 09:00:00	NVDA	Stock	0.527	0.527	0.5086	0.5128	76910720.0
2008-04-02 10:00:00	NVDA	Stock	0.5125	0.5242	0.508	0.5188	159850120.0
2008-04-02 11:00:00	NVDA	Stock	0.5185	0.519	0.5128	0.5178	60173800.0
2008-04-02 12:00:00	NVDA	Stock	0.5178	0.5188	0.514	0.5165	38620480.0
2008-04-02 13:00:00	NVDA	Stock	0.5165	0.5173	0.51	0.5155	57415840.0
2008-04-02 14:00:00	NVDA	Stock	0.5155	0.5175	0.5053	0.5072	93284080.0
2008-04-02 15:00:00	NVDA	Stock	0.5075	0.511	0.505	0.509	107888640.0
2008-04-02 16:00:00	NVDA	Stock	0.5098	0.514	0.508	0.508	11041600.0
2008-04-02 17:00:00	NVDA	Stock	0.5112	0.5112	0.5112	0.5112	64000.0
2008-04-02 18:00:00	NVDA	Stock	0.5115	0.5115	0.5115	0.5115	60000.0
2008-04-02 19:00:00	NVDA	Stock	0.5112	0.5112	0.5112	0.5112	4000.0
2008-04-02 08:00:00	AMZN	Stock	3.857	3.92	3.857	3.87	479000.0
2008-04-02 09:00:00	AMZN	Stock	3.87	3.8955	3.806	3.852	19343420.0
2008-04-02 10:00:00	AMZN	Stock	3.855	3.95	3.829	3.94	37847400.0
2008-04-02 11:00:00	AMZN	Stock	3.939	3.947	3.8865	3.898	21270540.0
2008-04-02 12:00:00	AMZN	Stock	3.899	3.9045	3.834	3.857	18155720.0
2008-04-02 13:00:00	AMZN	Stock	3.8565	3.8755	3.82	3.861	11204280.0
2008-04-02 14:00:00	AMZN	Stock	3.862	3.883	3.824	3.852	15616360.0
2008-04-02 15:00:00	AMZN	Stock	3.853	3.876	3.839	3.869	41930920.0
2008-04-02 16:00:00	AMZN	Stock	3.869	3.885	3.8587	3.885	5255460.0
2008-04-02 17:00:00	AMZN	Stock	3.886	3.886	3.88	3.88	34000.0
2008-04-02 18:00:00	AMZN	Stock	3.88	3.88	3.88	3.88	4000.0

> showing 50 of 39,268 rows — these rows as CSV

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