PREVIEW / stock_1hour / 2010-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-29.parquet
  size:    912 KB
  rows:    43,476
  symbols: 3,508

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-11-29 04:00:00	AAPL	Stock	11.2964	11.3529	11.2964	11.3304	45360.0
2010-11-29 05:00:00	AAPL	Stock	11.31	11.31	11.28	11.28	22400.0
2010-11-29 06:00:00	AAPL	Stock	11.28	11.2964	11.2768	11.2964	36400.0
2010-11-29 07:00:00	AAPL	Stock	11.2857	11.3018	11.2507	11.2839	897260.0
2010-11-29 08:00:00	AAPL	Stock	11.2839	11.3243	11.2836	11.3036	4094580.0
2010-11-29 09:00:00	AAPL	Stock	11.3021	11.3064	11.1736	11.2057	80792712.0
2010-11-29 10:00:00	AAPL	Stock	11.2032	11.2271	11.1207	11.1868	88596200.0
2010-11-29 11:00:00	AAPL	Stock	11.1881	11.2136	11.1661	11.1775	44054556.0
2010-11-29 12:00:00	AAPL	Stock	11.1764	11.2064	11.1568	11.1882	34901832.0
2010-11-29 13:00:00	AAPL	Stock	11.1879	11.1893	11.1643	11.1757	22726704.0
2010-11-29 14:00:00	AAPL	Stock	11.1773	11.2857	11.1707	11.2771	60333364.0
2010-11-29 15:00:00	AAPL	Stock	11.2761	11.3386	11.2643	11.3154	91371896.0
2010-11-29 16:00:00	AAPL	Stock	11.3161	11.3271	11.2302	11.3054	6028680.0
2010-11-29 17:00:00	AAPL	Stock	11.3061	11.3075	11.3	11.3007	315364.0
2010-11-29 18:00:00	AAPL	Stock	11.3014	11.3168	11.2982	11.3014	3127964.0
2010-11-29 19:00:00	AAPL	Stock	11.2975	11.3161	11.2971	11.315	491988.0
2010-11-29 08:00:00	MSFT	Stock	25.28	25.29	25.18	25.25	165068.0
2010-11-29 09:00:00	MSFT	Stock	25.21	25.28	25.0	25.04	7485397.0
2010-11-29 10:00:00	MSFT	Stock	25.04	25.14	24.93	25.01	11869759.0
2010-11-29 11:00:00	MSFT	Stock	25.02	25.13	25.005	25.11	6542285.0
2010-11-29 12:00:00	MSFT	Stock	25.11	25.15	25.09	25.125	3901360.0
2010-11-29 13:00:00	MSFT	Stock	25.13	25.14	25.052	25.087	3846502.0
2010-11-29 14:00:00	MSFT	Stock	25.08	25.315	25.07	25.3	5603051.0
2010-11-29 15:00:00	MSFT	Stock	25.31	25.42	25.29	25.31	10135306.0
2010-11-29 16:00:00	MSFT	Stock	25.31	25.415	25.147	25.35	3723876.0
2010-11-29 17:00:00	MSFT	Stock	25.33	25.36	25.33	25.34	7075.0
2010-11-29 18:00:00	MSFT	Stock	25.32	25.36	25.31	25.36	51380.0
2010-11-29 19:00:00	MSFT	Stock	25.36	25.38	25.36	25.37	2400.0
2010-11-29 08:00:00	NVDA	Stock	0.34	0.341	0.34	0.34	161200.0
2010-11-29 09:00:00	NVDA	Stock	0.34	0.344	0.3373	0.3385	82884880.0
2010-11-29 10:00:00	NVDA	Stock	0.3388	0.3405	0.337	0.338	76096120.0
2010-11-29 11:00:00	NVDA	Stock	0.338	0.3413	0.3378	0.3385	59778520.0
2010-11-29 12:00:00	NVDA	Stock	0.3384	0.341	0.3382	0.3398	39060480.0
2010-11-29 13:00:00	NVDA	Stock	0.3396	0.3408	0.3385	0.3398	27770440.0
2010-11-29 14:00:00	NVDA	Stock	0.3398	0.3438	0.3395	0.3438	79622040.0
2010-11-29 15:00:00	NVDA	Stock	0.3438	0.345	0.3433	0.344	66510240.0
2010-11-29 16:00:00	NVDA	Stock	0.3438	0.3448	0.341	0.3448	29656000.0
2010-11-29 17:00:00	NVDA	Stock	0.344	0.345	0.344	0.345	80000.0
2010-11-29 18:00:00	NVDA	Stock	0.344	0.3442	0.344	0.344	160000.0
2010-11-29 04:00:00	AMZN	Stock	8.9325	8.9325	8.9325	8.9325	8000.0
2010-11-29 05:00:00	AMZN	Stock	8.8815	8.8815	8.8815	8.8815	2000.0
2010-11-29 06:00:00	AMZN	Stock	8.925	8.925	8.925	8.925	22000.0
2010-11-29 07:00:00	AMZN	Stock	8.925	8.936	8.8805	8.9295	293200.0
2010-11-29 08:00:00	AMZN	Stock	8.9175	9.02	8.9175	8.9915	3184880.0
2010-11-29 09:00:00	AMZN	Stock	8.9895	9.0921	8.9	8.9238	54685660.0
2010-11-29 10:00:00	AMZN	Stock	8.9248	9.0115	8.8785	8.952	40127280.0
2010-11-29 11:00:00	AMZN	Stock	8.951	8.9975	8.901	8.91	17021200.0
2010-11-29 12:00:00	AMZN	Stock	8.9125	8.9785	8.8955	8.94	15163600.0
2010-11-29 13:00:00	AMZN	Stock	8.939	8.954	8.8965	8.9246	12795840.0
2010-11-29 14:00:00	AMZN	Stock	8.921	9.0375	8.921	9.0305	21077600.0

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

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