PREVIEW / stock_1hour / 2016-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-20.parquet
  size:    1.0 MB
  rows:    48,169
  symbols: 3,314

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
2016-04-20 04:00:00	AAPL	Stock	26.71	26.71	26.625	26.625	7040.0
2016-04-20 05:00:00	AAPL	Stock	26.6625	26.6625	26.6625	26.6625	400.0
2016-04-20 07:00:00	AAPL	Stock	26.69	26.72	26.65	26.72	56632.0
2016-04-20 08:00:00	AAPL	Stock	26.7175	26.725	26.675	26.695	282380.0
2016-04-20 09:00:00	AAPL	Stock	26.69	26.81	26.515	26.7962	19145196.0
2016-04-20 10:00:00	AAPL	Stock	26.7975	26.91	26.765	26.8675	20452888.0
2016-04-20 11:00:00	AAPL	Stock	26.8675	26.9925	26.84	26.9225	13509520.0
2016-04-20 12:00:00	AAPL	Stock	26.9225	27.0225	26.9178	26.94	10418900.0
2016-04-20 13:00:00	AAPL	Stock	26.9398	26.95	26.8925	26.9225	7447408.0
2016-04-20 14:00:00	AAPL	Stock	26.925	26.94	26.9	26.91	8068548.0
2016-04-20 15:00:00	AAPL	Stock	26.9125	26.935	26.7775	26.7825	18090856.0
2016-04-20 16:00:00	AAPL	Stock	26.7825	26.9658	26.75	26.7825	7616700.0
2016-04-20 17:00:00	AAPL	Stock	26.77	26.825	26.75	26.775	352444.0
2016-04-20 18:00:00	AAPL	Stock	26.765	26.775	26.7575	26.76	11600.0
2016-04-20 19:00:00	AAPL	Stock	26.7625	26.7875	26.7625	26.7625	14724.0
2016-04-20 04:00:00	MSFT	Stock	56.25	56.45	56.02	56.15	42600.0
2016-04-20 05:00:00	MSFT	Stock	56.05	56.05	56.03	56.03	2041.0
2016-04-20 06:00:00	MSFT	Stock	56.04	56.09	55.91	56.09	13054.0
2016-04-20 07:00:00	MSFT	Stock	56.1	56.1	56.05	56.05	1320.0
2016-04-20 08:00:00	MSFT	Stock	56.1	56.25	56.03	56.19	35716.0
2016-04-20 09:00:00	MSFT	Stock	56.19	56.5	56.05	56.255	3218870.0
2016-04-20 10:00:00	MSFT	Stock	56.255	56.26	55.935	56.03	4456280.0
2016-04-20 11:00:00	MSFT	Stock	56.035	56.17	55.96	56.1	3542947.0
2016-04-20 12:00:00	MSFT	Stock	56.1	56.16	56.0	56.09	1952357.0
2016-04-20 13:00:00	MSFT	Stock	56.086	56.12	55.98	56.0	3278229.0
2016-04-20 14:00:00	MSFT	Stock	56.0	56.11	55.87	55.93	4482802.0
2016-04-20 15:00:00	MSFT	Stock	55.93	56.03	55.485	55.6	9720322.0
2016-04-20 16:00:00	MSFT	Stock	55.6	56.078	55.5	55.56	1633923.0
2016-04-20 17:00:00	MSFT	Stock	55.59	55.61	55.56	55.6	159100.0
2016-04-20 18:00:00	MSFT	Stock	55.6	55.6	55.52	55.55	14160.0
2016-04-20 19:00:00	MSFT	Stock	55.58	55.65	55.58	55.65	3500.0
2016-04-20 08:00:00	NVDA	Stock	0.9002	0.9008	0.9002	0.9008	21600.0
2016-04-20 09:00:00	NVDA	Stock	0.9025	0.916	0.9025	0.9156	17899720.0
2016-04-20 10:00:00	NVDA	Stock	0.9155	0.9158	0.9053	0.9088	38785200.0
2016-04-20 11:00:00	NVDA	Stock	0.9085	0.9155	0.9062	0.9142	32523960.0
2016-04-20 12:00:00	NVDA	Stock	0.9142	0.9165	0.9118	0.9138	16639760.0
2016-04-20 13:00:00	NVDA	Stock	0.914	0.9158	0.9123	0.9145	22511920.0
2016-04-20 14:00:00	NVDA	Stock	0.9145	0.9168	0.9138	0.9158	19581680.0
2016-04-20 15:00:00	NVDA	Stock	0.9158	0.9168	0.9108	0.9113	41433040.0
2016-04-20 16:00:00	NVDA	Stock	0.9113	0.9133	0.9113	0.9113	1623120.0
2016-04-20 06:00:00	AMZN	Stock	31.395	31.395	31.395	31.395	2000.0
2016-04-20 07:00:00	AMZN	Stock	31.4745	31.4845	31.4745	31.4845	13000.0
2016-04-20 08:00:00	AMZN	Stock	31.467	31.49	31.45	31.464	28240.0
2016-04-20 09:00:00	AMZN	Stock	31.418	31.55	31.15	31.3624	7983080.0
2016-04-20 10:00:00	AMZN	Stock	31.3665	31.536	31.2966	31.5185	7813040.0
2016-04-20 11:00:00	AMZN	Stock	31.5215	31.7899	31.4556	31.712	7974780.0
2016-04-20 12:00:00	AMZN	Stock	31.7078	31.784	31.6695	31.7068	3633620.0
2016-04-20 13:00:00	AMZN	Stock	31.6875	31.824	31.663	31.7685	3863500.0
2016-04-20 14:00:00	AMZN	Stock	31.7665	31.8275	31.7295	31.7515	3832400.0
2016-04-20 15:00:00	AMZN	Stock	31.7568	31.775	31.6	31.6495	7409140.0

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

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