PREVIEW / stock_1hour / 2014-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-03.parquet
  size:    1.0 MB
  rows:    47,618
  symbols: 3,512

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
2014-01-03 04:00:00	AAPL	Stock	19.7607	19.7607	19.7607	19.7607	2800.0
2014-01-03 05:00:00	AAPL	Stock	19.7607	19.7607	19.7607	19.7607	14000.0
2014-01-03 06:00:00	AAPL	Stock	19.7732	19.8	19.7732	19.8	19432.0
2014-01-03 07:00:00	AAPL	Stock	19.8	19.8279	19.7864	19.8139	186592.0
2014-01-03 08:00:00	AAPL	Stock	19.8111	19.8214	19.7786	19.7786	1123024.0
2014-01-03 09:00:00	AAPL	Stock	19.7786	19.7814	19.5464	19.5825	57328404.0
2014-01-03 10:00:00	AAPL	Stock	19.5839	19.5975	19.4868	19.5171	56168532.0
2014-01-03 11:00:00	AAPL	Stock	19.5161	19.5611	19.4532	19.4719	39032280.0
2014-01-03 12:00:00	AAPL	Stock	19.4707	19.4739	19.3729	19.3993	38620484.0
2014-01-03 13:00:00	AAPL	Stock	19.3993	19.4529	19.3761	19.4493	24608276.0
2014-01-03 14:00:00	AAPL	Stock	19.4518	19.4811	19.4118	19.4593	22331344.0
2014-01-03 15:00:00	AAPL	Stock	19.4571	19.4743	19.3011	19.3229	66575880.0
2014-01-03 16:00:00	AAPL	Stock	19.3229	19.4812	19.2986	19.3196	16215780.0
2014-01-03 17:00:00	AAPL	Stock	19.3089	19.3268	19.3046	19.3179	1908452.0
2014-01-03 18:00:00	AAPL	Stock	19.3214	19.3254	19.3036	19.3204	143388.0
2014-01-03 19:00:00	AAPL	Stock	19.3139	19.3214	19.3036	19.3079	225820.0
2014-01-03 04:00:00	MSFT	Stock	37.16	37.16	37.16	37.16	100.0
2014-01-03 08:00:00	MSFT	Stock	37.19	37.25	37.19	37.25	560.0
2014-01-03 09:00:00	MSFT	Stock	37.2	37.289	37.0	37.037	2769811.0
2014-01-03 10:00:00	MSFT	Stock	37.04	37.09	36.74	36.81	4443688.0
2014-01-03 11:00:00	MSFT	Stock	36.81	36.885	36.6	36.759	4381153.0
2014-01-03 12:00:00	MSFT	Stock	36.76	36.89	36.75	36.809	2080991.0
2014-01-03 13:00:00	MSFT	Stock	36.805	36.85	36.76	36.8	2116433.0
2014-01-03 14:00:00	MSFT	Stock	36.8	36.94	36.75	36.905	2529685.0
2014-01-03 15:00:00	MSFT	Stock	36.9	36.99	36.9	36.92	7301122.0
2014-01-03 16:00:00	MSFT	Stock	36.9	37.21	36.808	36.86	4342500.0
2014-01-03 17:00:00	MSFT	Stock	36.86	36.97	36.86	36.91	35739.0
2014-01-03 09:00:00	NVDA	Stock	0.3973	0.398	0.3958	0.3962	26777520.0
2014-01-03 10:00:00	NVDA	Stock	0.3964	0.3973	0.3938	0.394	28370680.0
2014-01-03 11:00:00	NVDA	Stock	0.3941	0.3942	0.391	0.3915	24817000.0
2014-01-03 12:00:00	NVDA	Stock	0.3915	0.3933	0.3913	0.3914	31871080.0
2014-01-03 13:00:00	NVDA	Stock	0.3914	0.3926	0.3913	0.3913	17890720.0
2014-01-03 14:00:00	NVDA	Stock	0.3913	0.392	0.3905	0.3918	25333480.0
2014-01-03 15:00:00	NVDA	Stock	0.3919	0.3922	0.391	0.3914	59053800.0
2014-01-03 16:00:00	NVDA	Stock	0.3915	0.3928	0.3915	0.3918	38780240.0
2014-01-03 06:00:00	AMZN	Stock	19.925	19.925	19.925	19.925	6440.0
2014-01-03 07:00:00	AMZN	Stock	19.925	19.958	19.915	19.951	81560.0
2014-01-03 08:00:00	AMZN	Stock	19.975	19.9755	19.936	19.95	140380.0
2014-01-03 09:00:00	AMZN	Stock	19.936	20.075	19.875	20.047	5881020.0
2014-01-03 10:00:00	AMZN	Stock	20.0335	20.1355	20.008	20.057	7679240.0
2014-01-03 11:00:00	AMZN	Stock	20.058	20.062	19.8945	19.8965	4734720.0
2014-01-03 12:00:00	AMZN	Stock	19.8955	19.9875	19.85	19.9408	4239280.0
2014-01-03 13:00:00	AMZN	Stock	19.942	19.961	19.8665	19.9396	2512320.0
2014-01-03 14:00:00	AMZN	Stock	19.939	19.9675	19.9025	19.9285	2017280.0
2014-01-03 15:00:00	AMZN	Stock	19.923	19.925	19.811	19.819	8922860.0
2014-01-03 16:00:00	AMZN	Stock	19.822	19.9502	19.7605	19.8165	2767240.0
2014-01-03 17:00:00	AMZN	Stock	19.785	19.8055	19.775	19.8055	12660.0
2014-01-03 18:00:00	AMZN	Stock	19.779	19.82	19.762	19.762	39420.0
2014-01-03 19:00:00	AMZN	Stock	19.8	19.8	19.8	19.8	8000.0
2014-01-03 04:00:00	META	Stock	54.27	54.61	54.27	54.51	1332.0

> showing 50 of 47,618 rows — these rows as CSV

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