PREVIEW / stock_1hour / 2012-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-10.parquet
  size:    948 KB
  rows:    45,025
  symbols: 3,538

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
2012-01-10 04:00:00	AAPL	Stock	15.1264	15.1857	15.1264	15.1821	106400.0
2012-01-10 05:00:00	AAPL	Stock	15.1857	15.2136	15.1857	15.2136	22400.0
2012-01-10 06:00:00	AAPL	Stock	15.2036	15.2036	15.1786	15.1786	5600.0
2012-01-10 07:00:00	AAPL	Stock	15.1786	15.2268	15.1607	15.2	728420.0
2012-01-10 08:00:00	AAPL	Stock	15.2054	15.2229	15.1786	15.2043	1895152.0
2012-01-10 09:00:00	AAPL	Stock	15.2039	15.2275	15.1286	15.1575	48238904.0
2012-01-10 10:00:00	AAPL	Stock	15.1604	15.1993	15.1371	15.1618	48250860.0
2012-01-10 11:00:00	AAPL	Stock	15.162	15.1771	15.1186	15.12	25746224.0
2012-01-10 12:00:00	AAPL	Stock	15.1186	15.1332	15.0536	15.0754	42130536.0
2012-01-10 13:00:00	AAPL	Stock	15.075	15.1389	15.0593	15.1132	26611956.0
2012-01-10 14:00:00	AAPL	Stock	15.1132	15.1382	15.1025	15.1257	18029816.0
2012-01-10 15:00:00	AAPL	Stock	15.1264	15.1418	15.0929	15.1154	34564852.0
2012-01-10 16:00:00	AAPL	Stock	15.1099	15.1729	15.0939	15.1157	9058196.0
2012-01-10 17:00:00	AAPL	Stock	15.1018	15.1018	15.0893	15.0971	116732.0
2012-01-10 18:00:00	AAPL	Stock	15.0929	15.1157	15.0839	15.0971	262108.0
2012-01-10 19:00:00	AAPL	Stock	15.0911	15.0911	15.0686	15.0721	135072.0
2012-01-10 05:00:00	MSFT	Stock	28.02	28.02	28.02	28.02	300.0
2012-01-10 07:00:00	MSFT	Stock	28.0	28.05	27.86	28.0	16358.0
2012-01-10 08:00:00	MSFT	Stock	27.95	28.0	27.9	27.93	115476.0
2012-01-10 09:00:00	MSFT	Stock	27.93	28.0	27.82	27.975	10072029.0
2012-01-10 10:00:00	MSFT	Stock	27.97	28.15	27.93	28.0	12914705.0
2012-01-10 11:00:00	MSFT	Stock	27.99	28.09	27.92	28.06	6486600.0
2012-01-10 12:00:00	MSFT	Stock	28.055	28.06	27.95	27.99	3477669.0
2012-01-10 13:00:00	MSFT	Stock	27.99	27.99	27.9	27.916	3401004.0
2012-01-10 14:00:00	MSFT	Stock	27.913	28.0	27.87	27.98	5429363.0
2012-01-10 15:00:00	MSFT	Stock	27.99	28.0	27.75	27.84	10116370.0
2012-01-10 16:00:00	MSFT	Stock	27.84	27.977	27.33	27.44	2270923.0
2012-01-10 17:00:00	MSFT	Stock	27.44	27.6	27.37	27.49	660946.0
2012-01-10 18:00:00	MSFT	Stock	27.45	27.84	27.45	27.53	27423.0
2012-01-10 19:00:00	MSFT	Stock	27.51	27.56	27.45	27.56	15210.0
2012-01-10 07:00:00	NVDA	Stock	0.371	0.3725	0.371	0.3725	116000.0
2012-01-10 08:00:00	NVDA	Stock	0.3725	0.3725	0.3652	0.37	185600.0
2012-01-10 09:00:00	NVDA	Stock	0.3705	0.3705	0.3638	0.365	67681400.0
2012-01-10 10:00:00	NVDA	Stock	0.365	0.3675	0.3595	0.3612	95054480.0
2012-01-10 11:00:00	NVDA	Stock	0.3612	0.3639	0.3598	0.3602	92592440.0
2012-01-10 12:00:00	NVDA	Stock	0.3605	0.3642	0.3602	0.364	36617880.0
2012-01-10 13:00:00	NVDA	Stock	0.364	0.3642	0.362	0.3639	40437440.0
2012-01-10 14:00:00	NVDA	Stock	0.3638	0.3643	0.3635	0.3638	31402240.0
2012-01-10 15:00:00	NVDA	Stock	0.3636	0.364	0.3612	0.3618	165193080.0
2012-01-10 16:00:00	NVDA	Stock	0.362	0.3638	0.3612	0.3615	3566720.0
2012-01-10 17:00:00	NVDA	Stock	0.3612	0.3612	0.3605	0.3605	904000.0
2012-01-10 18:00:00	NVDA	Stock	0.3605	0.3605	0.3595	0.3595	38040.0
2012-01-10 19:00:00	NVDA	Stock	0.3595	0.3595	0.3595	0.3595	17960.0
2012-01-10 04:00:00	AMZN	Stock	8.928	8.928	8.928	8.928	2000.0
2012-01-10 06:00:00	AMZN	Stock	9.0385	9.0385	9.0385	9.0385	2000.0
2012-01-10 07:00:00	AMZN	Stock	9.075	9.075	9.0545	9.0545	18000.0
2012-01-10 08:00:00	AMZN	Stock	9.039	9.056	9.0285	9.05	200240.0
2012-01-10 09:00:00	AMZN	Stock	9.05	9.12	8.928	8.965	14410400.0
2012-01-10 10:00:00	AMZN	Stock	8.9677	9.047	8.9325	8.936	13934140.0
2012-01-10 11:00:00	AMZN	Stock	8.936	8.955	8.8925	8.924	10098120.0

> showing 50 of 45,025 rows — these rows as CSV

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