PREVIEW / stock_1hour / 2011-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-21.parquet
  size:    926 KB
  rows:    44,352
  symbols: 3,562

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-12-21 04:00:00	AAPL	Stock	14.1771	14.2071	14.1771	14.1829	15400.0
2011-12-21 05:00:00	AAPL	Stock	14.2036	14.2036	14.2032	14.2032	18200.0
2011-12-21 06:00:00	AAPL	Stock	14.2032	14.2032	14.0786	14.0786	30800.0
2011-12-21 07:00:00	AAPL	Stock	14.1289	14.1596	14.0982	14.1196	406140.0
2011-12-21 08:00:00	AAPL	Stock	14.135	14.1504	14.0689	14.1371	1912484.0
2011-12-21 09:00:00	AAPL	Stock	14.1411	14.1893	14.025	14.0957	56395836.0
2011-12-21 10:00:00	AAPL	Stock	14.095	14.1571	14.0454	14.0879	52596012.0
2011-12-21 11:00:00	AAPL	Stock	14.0857	14.0893	14.0293	14.0434	26803924.0
2011-12-21 12:00:00	AAPL	Stock	14.0446	14.0662	14.0004	14.0539	26572728.0
2011-12-21 13:00:00	AAPL	Stock	14.0573	14.0842	14.0339	14.079	20838776.0
2011-12-21 14:00:00	AAPL	Stock	14.0789	14.1	14.0436	14.08	19154212.0
2011-12-21 15:00:00	AAPL	Stock	14.0796	14.1679	14.0696	14.1586	44540692.0
2011-12-21 16:00:00	AAPL	Stock	14.1586	14.1679	14.0888	14.1486	10342724.0
2011-12-21 17:00:00	AAPL	Stock	14.1493	14.1839	14.1482	14.1786	738136.0
2011-12-21 18:00:00	AAPL	Stock	14.1793	14.1814	14.1586	14.1786	168924.0
2011-12-21 19:00:00	AAPL	Stock	14.175	14.2093	14.1739	14.1932	590520.0
2011-12-21 04:00:00	MSFT	Stock	26.11	26.11	26.11	26.11	500.0
2011-12-21 05:00:00	MSFT	Stock	26.09	26.09	26.09	26.09	500.0
2011-12-21 07:00:00	MSFT	Stock	26.07	26.07	25.91	25.95	15272.0
2011-12-21 08:00:00	MSFT	Stock	25.95	25.95	25.82	25.91	74490.0
2011-12-21 09:00:00	MSFT	Stock	25.93	26.19	25.84	25.9	8375693.0
2011-12-21 10:00:00	MSFT	Stock	25.89	26.02	25.84	25.895	7830936.0
2011-12-21 11:00:00	MSFT	Stock	25.9	25.905	25.57	25.64	9744959.0
2011-12-21 12:00:00	MSFT	Stock	25.64	25.65	25.46	25.61	6995838.0
2011-12-21 13:00:00	MSFT	Stock	25.615	25.66	25.44	25.59	6626595.0
2011-12-21 14:00:00	MSFT	Stock	25.59	25.67	25.56	25.64	7195405.0
2011-12-21 15:00:00	MSFT	Stock	25.632	25.77	25.6	25.75	11664556.0
2011-12-21 16:00:00	MSFT	Stock	25.751	25.78	25.641	25.75	4578627.0
2011-12-21 17:00:00	MSFT	Stock	25.76	25.76	25.71	25.73	2738.0
2011-12-21 18:00:00	MSFT	Stock	25.76	25.76	25.73	25.74	8100.0
2011-12-21 19:00:00	MSFT	Stock	25.73	25.74	25.73	25.74	1550.0
2011-12-21 07:00:00	NVDA	Stock	0.3475	0.3475	0.3475	0.3475	374000.0
2011-12-21 08:00:00	NVDA	Stock	0.3425	0.3458	0.3425	0.3455	76000.0
2011-12-21 09:00:00	NVDA	Stock	0.3465	0.3493	0.3413	0.3431	39072920.0
2011-12-21 10:00:00	NVDA	Stock	0.3433	0.3453	0.338	0.3384	79838840.0
2011-12-21 11:00:00	NVDA	Stock	0.3385	0.3388	0.3362	0.3382	57856320.0
2011-12-21 12:00:00	NVDA	Stock	0.3384	0.3395	0.3362	0.3393	63956520.0
2011-12-21 13:00:00	NVDA	Stock	0.3393	0.3415	0.3382	0.3405	111655880.0
2011-12-21 14:00:00	NVDA	Stock	0.3408	0.342	0.3388	0.3415	98661480.0
2011-12-21 15:00:00	NVDA	Stock	0.3415	0.3438	0.3408	0.343	81327560.0
2011-12-21 16:00:00	NVDA	Stock	0.3425	0.3431	0.3402	0.343	4716160.0
2011-12-21 17:00:00	NVDA	Stock	0.3438	0.3438	0.3438	0.3438	20000.0
2011-12-21 18:00:00	NVDA	Stock	0.342	0.343	0.342	0.343	64000.0
2011-12-21 07:00:00	AMZN	Stock	9.1325	9.145	9.125	9.125	38200.0
2011-12-21 08:00:00	AMZN	Stock	9.1195	9.1275	9.095	9.125	154200.0
2011-12-21 09:00:00	AMZN	Stock	9.1175	9.175	9.0114	9.051	12493940.0
2011-12-21 10:00:00	AMZN	Stock	9.05	9.05	8.894	8.9073	17001780.0
2011-12-21 11:00:00	AMZN	Stock	8.909	8.9175	8.802	8.8176	16408120.0
2011-12-21 12:00:00	AMZN	Stock	8.818	8.8275	8.731	8.7649	24097620.0
2011-12-21 13:00:00	AMZN	Stock	8.765	8.8055	8.7035	8.7268	17889360.0

> showing 50 of 44,352 rows — these rows as CSV

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