PREVIEW / stock_1hour / 2015-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-09.parquet
  size:    1.0 MB
  rows:    48,815
  symbols: 3,490

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-06-09 04:00:00	AAPL	Stock	32.025	32.045	31.95	31.98	34768.0
2015-06-09 05:00:00	AAPL	Stock	31.94	31.94	31.7825	31.7825	29048.0
2015-06-09 06:00:00	AAPL	Stock	31.8225	31.8875	31.795	31.8875	46572.0
2015-06-09 07:00:00	AAPL	Stock	31.895	31.95	31.8875	31.905	122664.0
2015-06-09 08:00:00	AAPL	Stock	31.91	31.98	31.65	31.6725	2022012.0
2015-06-09 09:00:00	AAPL	Stock	31.6675	31.805	31.5225	31.6325	38571200.0
2015-06-09 10:00:00	AAPL	Stock	31.6312	31.6475	31.405	31.554	47381020.0
2015-06-09 11:00:00	AAPL	Stock	31.5525	31.66	31.5362	31.635	21099496.0
2015-06-09 12:00:00	AAPL	Stock	31.6325	31.885	31.57	31.883	24427004.0
2015-06-09 13:00:00	AAPL	Stock	31.88	32.02	31.855	31.87	25721560.0
2015-06-09 14:00:00	AAPL	Stock	31.87	31.99	31.84	31.9175	16885804.0
2015-06-09 15:00:00	AAPL	Stock	31.915	31.9175	31.7775	31.8525	26109408.0
2015-06-09 16:00:00	AAPL	Stock	31.855	31.875	31.3588	31.855	9201132.0
2015-06-09 17:00:00	AAPL	Stock	31.8675	31.8675	31.85	31.865	48924.0
2015-06-09 18:00:00	AAPL	Stock	31.865	31.8775	31.8625	31.865	30140.0
2015-06-09 19:00:00	AAPL	Stock	31.865	31.8875	31.8625	31.8872	61616.0
2015-06-09 07:00:00	MSFT	Stock	45.65	45.67	45.65	45.67	1490.0
2015-06-09 08:00:00	MSFT	Stock	45.71	45.72	45.56	45.63	11300.0
2015-06-09 09:00:00	MSFT	Stock	45.68	45.83	45.52	45.55	2650986.0
2015-06-09 10:00:00	MSFT	Stock	45.545	45.77	45.46	45.638	4591880.0
2015-06-09 11:00:00	MSFT	Stock	45.63	45.79	45.61	45.65	2454910.0
2015-06-09 12:00:00	MSFT	Stock	45.66	45.89	45.63	45.87	2038981.0
2015-06-09 13:00:00	MSFT	Stock	45.87	45.94	45.75	45.808	1833368.0
2015-06-09 14:00:00	MSFT	Stock	45.8	45.91	45.72	45.82	1772302.0
2015-06-09 15:00:00	MSFT	Stock	45.825	45.855	45.61	45.64	3713612.0
2015-06-09 16:00:00	MSFT	Stock	45.65	45.81	45.556	45.68	4112500.0
2015-06-09 08:00:00	NVDA	Stock	0.5412	0.5412	0.5412	0.5412	4000.0
2015-06-09 09:00:00	NVDA	Stock	0.5438	0.5462	0.5432	0.5452	29122560.0
2015-06-09 10:00:00	NVDA	Stock	0.5452	0.5494	0.5442	0.5494	41325480.0
2015-06-09 11:00:00	NVDA	Stock	0.5492	0.5502	0.5475	0.5482	35021120.0
2015-06-09 12:00:00	NVDA	Stock	0.5484	0.5502	0.548	0.55	25174000.0
2015-06-09 13:00:00	NVDA	Stock	0.5499	0.5505	0.5475	0.5482	25294080.0
2015-06-09 14:00:00	NVDA	Stock	0.5482	0.549	0.5468	0.5468	20818440.0
2015-06-09 15:00:00	NVDA	Stock	0.5468	0.5475	0.546	0.5462	31722960.0
2015-06-09 16:00:00	NVDA	Stock	0.5465	0.548	0.5465	0.548	42026560.0
2015-06-09 17:00:00	NVDA	Stock	0.5462	0.5462	0.5462	0.5462	12000.0
2015-06-09 04:00:00	AMZN	Stock	21.195	21.195	21.186	21.186	7520.0
2015-06-09 08:00:00	AMZN	Stock	21.15	21.15	21.15	21.15	10000.0
2015-06-09 09:00:00	AMZN	Stock	21.15	21.2115	20.957	21.012	5335600.0
2015-06-09 10:00:00	AMZN	Stock	21.015	21.1725	20.983	21.1708	6750220.0
2015-06-09 11:00:00	AMZN	Stock	21.1625	21.2585	21.1495	21.2175	5743780.0
2015-06-09 12:00:00	AMZN	Stock	21.2165	21.219	21.13	21.1815	2971540.0
2015-06-09 13:00:00	AMZN	Stock	21.182	21.2885	21.173	21.1985	4552860.0
2015-06-09 14:00:00	AMZN	Stock	21.199	21.3745	21.1895	21.3075	6000900.0
2015-06-09 15:00:00	AMZN	Stock	21.3055	21.3215	21.25	21.2745	5067440.0
2015-06-09 16:00:00	AMZN	Stock	21.274	21.275	21.0493	21.2615	2221260.0
2015-06-09 19:00:00	AMZN	Stock	21.305	21.305	21.305	21.305	3400.0
2015-06-09 09:00:00	GOOGL	Stock	27.186	27.2205	26.962	26.993	2983100.0
2015-06-09 10:00:00	GOOGL	Stock	26.984	27.184	26.9425	27.184	2568500.0
2015-06-09 11:00:00	GOOGL	Stock	27.184	27.242	27.1315	27.1655	2394180.0

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

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