PREVIEW / stock_1hour / 2016-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-22.parquet
  size:    1.0 MB
  rows:    48,086
  symbols: 3,323

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-22 04:00:00	AAPL	Stock	26.32	26.32	26.32	26.32	400.0
2016-04-22 05:00:00	AAPL	Stock	26.3075	26.3625	26.3075	26.3625	816.0
2016-04-22 06:00:00	AAPL	Stock	26.3	26.325	26.3	26.3175	82852.0
2016-04-22 07:00:00	AAPL	Stock	26.3375	26.3725	26.3125	26.315	73428.0
2016-04-22 08:00:00	AAPL	Stock	26.3275	26.3725	26.3125	26.34	219700.0
2016-04-22 09:00:00	AAPL	Stock	26.345	26.6025	26.25	26.6	18662696.0
2016-04-22 10:00:00	AAPL	Stock	26.6025	26.62	26.2525	26.2788	22912620.0
2016-04-22 11:00:00	AAPL	Stock	26.2805	26.3495	26.2	26.3425	15087580.0
2016-04-22 12:00:00	AAPL	Stock	26.3425	26.345	26.19	26.2045	9839364.0
2016-04-22 13:00:00	AAPL	Stock	26.2057	26.2925	26.155	26.2685	14199264.0
2016-04-22 14:00:00	AAPL	Stock	26.2675	26.3975	26.2525	26.3862	12819504.0
2016-04-22 15:00:00	AAPL	Stock	26.3862	26.425	26.3352	26.42	17060860.0
2016-04-22 16:00:00	AAPL	Stock	26.42	26.42	26.3745	26.4175	12754092.0
2016-04-22 17:00:00	AAPL	Stock	26.4175	26.4325	26.405	26.4125	97636.0
2016-04-22 18:00:00	AAPL	Stock	26.41	26.435	26.41	26.415	22680.0
2016-04-22 19:00:00	AAPL	Stock	26.4125	26.425	26.395	26.4025	50260.0
2016-04-22 04:00:00	MSFT	Stock	53.0	53.16	53.0	53.1	3910.0
2016-04-22 05:00:00	MSFT	Stock	53.15	53.16	53.08	53.12	9220.0
2016-04-22 06:00:00	MSFT	Stock	53.1	53.32	53.0	53.3	31434.0
2016-04-22 07:00:00	MSFT	Stock	53.35	53.44	53.05	53.16	116518.0
2016-04-22 08:00:00	MSFT	Stock	53.14	53.4	52.62	52.68	1184549.0
2016-04-22 09:00:00	MSFT	Stock	52.66	52.75	51.6	51.73	24586792.0
2016-04-22 10:00:00	MSFT	Stock	51.725	51.75	50.77	51.56	27991013.0
2016-04-22 11:00:00	MSFT	Stock	51.57	52.225	51.42	52.1	17991278.0
2016-04-22 12:00:00	MSFT	Stock	52.1	52.15	51.56	51.71	9499802.0
2016-04-22 13:00:00	MSFT	Stock	51.7	52.11	51.65	51.9	8192354.0
2016-04-22 14:00:00	MSFT	Stock	51.899	52.09	51.79	51.995	7170715.0
2016-04-22 15:00:00	MSFT	Stock	52.0	52.005	51.61	51.77	16090901.0
2016-04-22 16:00:00	MSFT	Stock	51.76	51.85	51.65	51.77	8731455.0
2016-04-22 17:00:00	MSFT	Stock	51.75	51.85	51.75	51.83	20528.0
2016-04-22 18:00:00	MSFT	Stock	51.85	51.89	51.85	51.85	7119.0
2016-04-22 19:00:00	MSFT	Stock	51.87	51.93	51.85	51.93	14767.0
2016-04-22 06:00:00	NVDA	Stock	0.906	0.906	0.906	0.906	4000.0
2016-04-22 08:00:00	NVDA	Stock	0.905	0.905	0.905	0.905	40000.0
2016-04-22 09:00:00	NVDA	Stock	0.91	0.9195	0.91	0.9178	19395360.0
2016-04-22 10:00:00	NVDA	Stock	0.9178	0.9185	0.9036	0.9043	33882720.0
2016-04-22 11:00:00	NVDA	Stock	0.9042	0.9082	0.9036	0.9068	28017760.0
2016-04-22 12:00:00	NVDA	Stock	0.907	0.907	0.9043	0.9055	13044360.0
2016-04-22 13:00:00	NVDA	Stock	0.9055	0.9105	0.9055	0.909	14175840.0
2016-04-22 14:00:00	NVDA	Stock	0.9089	0.9123	0.907	0.9109	14478360.0
2016-04-22 15:00:00	NVDA	Stock	0.911	0.911	0.9058	0.907	71634800.0
2016-04-22 16:00:00	NVDA	Stock	0.9068	0.9091	0.9068	0.9085	6862480.0
2016-04-22 17:00:00	NVDA	Stock	0.9075	0.9075	0.9075	0.9075	12000.0
2016-04-22 18:00:00	NVDA	Stock	0.9065	0.9075	0.9065	0.9075	48000.0
2016-04-22 06:00:00	AMZN	Stock	31.1985	31.2	31.1985	31.2	11820.0
2016-04-22 07:00:00	AMZN	Stock	31.2525	31.3105	31.2525	31.305	66000.0
2016-04-22 08:00:00	AMZN	Stock	31.3	31.31	31.175	31.3	180480.0
2016-04-22 09:00:00	AMZN	Stock	31.3	31.4125	31.1255	31.1902	10892320.0
2016-04-22 10:00:00	AMZN	Stock	31.1845	31.275	30.578	30.7135	21414360.0
2016-04-22 11:00:00	AMZN	Stock	30.717	30.8195	30.6275	30.797	10165040.0

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

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