PREVIEW / stock_1hour / 2015-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-04.parquet
  size:    1.0 MB
  rows:    48,661
  symbols: 3,499

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
2015-03-04 04:00:00	AAPL	Stock	32.34	32.34	32.205	32.225	9676.0
2015-03-04 05:00:00	AAPL	Stock	32.27	32.3375	32.2675	32.28	48468.0
2015-03-04 06:00:00	AAPL	Stock	32.28	32.28	32.2275	32.25	43000.0
2015-03-04 07:00:00	AAPL	Stock	32.25	32.25	32.2	32.2425	61468.0
2015-03-04 08:00:00	AAPL	Stock	32.2425	32.34	32.2	32.285	405964.0
2015-03-04 09:00:00	AAPL	Stock	32.2825	32.39	32.0975	32.1678	22599708.0
2015-03-04 10:00:00	AAPL	Stock	32.17	32.28	32.1475	32.255	18790776.0
2015-03-04 11:00:00	AAPL	Stock	32.255	32.335	32.1625	32.2358	17383724.0
2015-03-04 12:00:00	AAPL	Stock	32.2362	32.2875	32.205	32.245	7916400.0
2015-03-04 13:00:00	AAPL	Stock	32.245	32.295	32.185	32.2112	6732296.0
2015-03-04 14:00:00	AAPL	Stock	32.21	32.25	32.1625	32.2065	7795948.0
2015-03-04 15:00:00	AAPL	Stock	32.2062	32.2275	32.08	32.14	23971040.0
2015-03-04 16:00:00	AAPL	Stock	32.135	32.2245	32.0975	32.12	12876184.0
2015-03-04 17:00:00	AAPL	Stock	32.12	32.1625	32.0525	32.1325	402200.0
2015-03-04 18:00:00	AAPL	Stock	32.1278	32.135	32.105	32.1075	102936.0
2015-03-04 19:00:00	AAPL	Stock	32.11	32.1225	32.11	32.11	49752.0
2015-03-04 04:00:00	MSFT	Stock	43.64	43.64	43.64	43.64	2107.0
2015-03-04 06:00:00	MSFT	Stock	43.21	43.21	43.21	43.21	200.0
2015-03-04 08:00:00	MSFT	Stock	43.34	43.34	43.11	43.15	15576.0
2015-03-04 09:00:00	MSFT	Stock	43.28	43.28	42.88	42.99	4355110.0
2015-03-04 10:00:00	MSFT	Stock	42.99	43.17	42.91	43.11	4555743.0
2015-03-04 11:00:00	MSFT	Stock	43.11	43.21	43.05	43.07	2612603.0
2015-03-04 12:00:00	MSFT	Stock	43.07	43.21	43.045	43.09	1726756.0
2015-03-04 13:00:00	MSFT	Stock	43.09	43.14	43.0	43.01	1930883.0
2015-03-04 14:00:00	MSFT	Stock	43.01	43.11	42.95	43.05	2258600.0
2015-03-04 15:00:00	MSFT	Stock	43.055	43.11	42.99	43.06	4301366.0
2015-03-04 16:00:00	MSFT	Stock	43.055	43.401	42.98	43.055	3015434.0
2015-03-04 17:00:00	MSFT	Stock	43.0	43.06	43.0	43.06	1700.0
2015-03-04 18:00:00	MSFT	Stock	43.099	43.099	43.099	43.099	187.0
2015-03-04 07:00:00	NVDA	Stock	0.5545	0.5545	0.5545	0.5545	24000.0
2015-03-04 08:00:00	NVDA	Stock	0.5575	0.5645	0.555	0.555	82000.0
2015-03-04 09:00:00	NVDA	Stock	0.5525	0.557	0.5502	0.5515	24523520.0
2015-03-04 10:00:00	NVDA	Stock	0.5515	0.5545	0.5512	0.553	30492240.0
2015-03-04 11:00:00	NVDA	Stock	0.553	0.558	0.5528	0.558	21031720.0
2015-03-04 12:00:00	NVDA	Stock	0.5579	0.56	0.5575	0.5582	19849280.0
2015-03-04 13:00:00	NVDA	Stock	0.5584	0.5588	0.556	0.5566	11466600.0
2015-03-04 14:00:00	NVDA	Stock	0.5568	0.56	0.5564	0.56	21066520.0
2015-03-04 15:00:00	NVDA	Stock	0.56	0.562	0.5596	0.5611	68780720.0
2015-03-04 16:00:00	NVDA	Stock	0.5612	0.5615	0.5572	0.5608	15830040.0
2015-03-04 05:00:00	AMZN	Stock	19.161	19.161	19.161	19.161	2000.0
2015-03-04 06:00:00	AMZN	Stock	19.161	19.161	19.161	19.161	2000.0
2015-03-04 08:00:00	AMZN	Stock	19.21	19.21	19.189	19.1905	66160.0
2015-03-04 09:00:00	AMZN	Stock	19.1705	19.3975	19.1705	19.25	11310660.0
2015-03-04 10:00:00	AMZN	Stock	19.2403	19.278	19.1485	19.1945	8360420.0
2015-03-04 11:00:00	AMZN	Stock	19.193	19.2545	19.1778	19.2145	3776320.0
2015-03-04 12:00:00	AMZN	Stock	19.2145	19.2695	19.1885	19.2375	2625840.0
2015-03-04 13:00:00	AMZN	Stock	19.2335	19.2725	19.2045	19.2045	2691000.0
2015-03-04 14:00:00	AMZN	Stock	19.208	19.24	19.17	19.2387	4017840.0
2015-03-04 15:00:00	AMZN	Stock	19.24	19.248	19.1095	19.127	6989220.0
2015-03-04 16:00:00	AMZN	Stock	19.136	19.229	19.1291	19.136	2062540.0

> showing 50 of 48,661 rows — these rows as CSV

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