PREVIEW / stock_1hour / 2011-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-19.parquet
  size:    975 KB
  rows:    46,383
  symbols: 3,524

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
2011-01-19 04:00:00	AAPL	Stock	12.3314	12.3607	12.3257	12.3489	106400.0
2011-01-19 05:00:00	AAPL	Stock	12.375	12.4104	12.3439	12.3686	150276.0
2011-01-19 06:00:00	AAPL	Stock	12.3929	12.3929	12.2471	12.2964	680260.0
2011-01-19 07:00:00	AAPL	Stock	12.3064	12.4107	12.3064	12.3904	5542180.0
2011-01-19 08:00:00	AAPL	Stock	12.3921	12.5321	12.3205	12.4904	31048864.0
2011-01-19 09:00:00	AAPL	Stock	12.4882	12.5082	12.2639	12.2639	304384976.0
2011-01-19 10:00:00	AAPL	Stock	12.2643	12.2932	12.1429	12.2393	246070776.0
2011-01-19 11:00:00	AAPL	Stock	12.2396	12.315	12.2061	12.2829	110313028.0
2011-01-19 12:00:00	AAPL	Stock	12.2827	12.2907	12.1981	12.2279	60219908.0
2011-01-19 13:00:00	AAPL	Stock	12.2279	12.26	12.1918	12.2179	58792104.0
2011-01-19 14:00:00	AAPL	Stock	12.2189	12.2321	12.0893	12.1228	102999848.0
2011-01-19 15:00:00	AAPL	Stock	12.1209	12.1393	12.0314	12.1014	182298060.0
2011-01-19 16:00:00	AAPL	Stock	12.0947	12.4515	12.0714	12.0818	20569024.0
2011-01-19 17:00:00	AAPL	Stock	12.0811	12.0814	12.0179	12.025	2033136.0
2011-01-19 18:00:00	AAPL	Stock	12.0261	12.1014	12.0075	12.0079	1034432.0
2011-01-19 19:00:00	AAPL	Stock	12.0079	12.0304	12.0071	12.0236	809704.0
2011-01-19 04:00:00	MSFT	Stock	28.67	28.67	28.66	28.66	300.0
2011-01-19 07:00:00	MSFT	Stock	28.78	28.78	28.75	28.75	4100.0
2011-01-19 08:00:00	MSFT	Stock	28.76	28.77	28.64	28.66	60317.0
2011-01-19 09:00:00	MSFT	Stock	28.66	28.68	28.45	28.58	6767922.0
2011-01-19 10:00:00	MSFT	Stock	28.572	28.66	28.495	28.604	7528328.0
2011-01-19 11:00:00	MSFT	Stock	28.605	28.62	28.44	28.455	4906465.0
2011-01-19 12:00:00	MSFT	Stock	28.45	28.49	28.32	28.32	6290169.0
2011-01-19 13:00:00	MSFT	Stock	28.32	28.43	28.29	28.312	5596552.0
2011-01-19 14:00:00	MSFT	Stock	28.32	28.39	28.27	28.31	5300676.0
2011-01-19 15:00:00	MSFT	Stock	28.31	28.47	28.3	28.47	7244405.0
2011-01-19 16:00:00	MSFT	Stock	28.47	28.51	28.361	28.45	1937027.0
2011-01-19 17:00:00	MSFT	Stock	28.46	28.47	28.35	28.37	3855.0
2011-01-19 18:00:00	MSFT	Stock	28.36	28.47	28.35	28.4	18206.0
2011-01-19 19:00:00	MSFT	Stock	28.41	28.41	28.4	28.4	2050.0
2011-01-19 07:00:00	NVDA	Stock	0.587	0.587	0.5815	0.5828	265600.0
2011-01-19 08:00:00	NVDA	Stock	0.5828	0.5883	0.5825	0.5825	2094040.0
2011-01-19 09:00:00	NVDA	Stock	0.5825	0.59	0.5752	0.582	187221600.0
2011-01-19 10:00:00	NVDA	Stock	0.582	0.5858	0.5662	0.5672	280766280.0
2011-01-19 11:00:00	NVDA	Stock	0.5672	0.5688	0.5645	0.5668	119718200.0
2011-01-19 12:00:00	NVDA	Stock	0.5668	0.567	0.5602	0.5618	136768920.0
2011-01-19 13:00:00	NVDA	Stock	0.5618	0.5658	0.5605	0.5628	113320160.0
2011-01-19 14:00:00	NVDA	Stock	0.5628	0.5642	0.5605	0.5622	134250840.0
2011-01-19 15:00:00	NVDA	Stock	0.562	0.5638	0.559	0.56	199082800.0
2011-01-19 16:00:00	NVDA	Stock	0.5608	0.569	0.5558	0.5565	6247120.0
2011-01-19 17:00:00	NVDA	Stock	0.5568	0.5572	0.555	0.5555	661920.0
2011-01-19 18:00:00	NVDA	Stock	0.556	0.5572	0.555	0.5562	448400.0
2011-01-19 19:00:00	NVDA	Stock	0.5542	0.5572	0.5542	0.5565	223760.0
2011-01-19 08:00:00	AMZN	Stock	9.5625	9.5765	9.545	9.5765	59100.0
2011-01-19 09:00:00	AMZN	Stock	9.5475	9.5625	9.451	9.456	10853100.0
2011-01-19 10:00:00	AMZN	Stock	9.456	9.4895	9.3935	9.401	12067940.0
2011-01-19 11:00:00	AMZN	Stock	9.404	9.4155	9.33	9.4052	12330500.0
2011-01-19 12:00:00	AMZN	Stock	9.406	9.419	9.3485	9.3895	5223200.0
2011-01-19 13:00:00	AMZN	Stock	9.391	9.4125	9.3686	9.383	4585540.0
2011-01-19 14:00:00	AMZN	Stock	9.384	9.3865	9.325	9.3459	7346580.0

> showing 50 of 46,383 rows — these rows as CSV

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