PREVIEW / stock_1hour / 2015-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-02.parquet
  size:    1.0 MB
  rows:    48,811
  symbols: 3,432

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-11-02 04:00:00	AAPL	Stock	29.815	29.905	29.8125	29.8825	23372.0
2015-11-02 05:00:00	AAPL	Stock	29.8775	29.9025	29.87	29.9025	4800.0
2015-11-02 06:00:00	AAPL	Stock	29.89	29.91	29.875	29.875	72820.0
2015-11-02 07:00:00	AAPL	Stock	29.875	29.935	29.8475	29.935	112156.0
2015-11-02 08:00:00	AAPL	Stock	29.92	29.965	29.8625	29.9575	423724.0
2015-11-02 09:00:00	AAPL	Stock	29.9575	30.0875	29.875	30.05	19804424.0
2015-11-02 10:00:00	AAPL	Stock	30.0675	30.2375	30.02	30.2338	24116928.0
2015-11-02 11:00:00	AAPL	Stock	30.235	30.2625	30.16	30.2262	17544544.0
2015-11-02 12:00:00	AAPL	Stock	30.225	30.25	30.175	30.2212	9845836.0
2015-11-02 13:00:00	AAPL	Stock	30.2225	30.24	30.1925	30.235	8091680.0
2015-11-02 14:00:00	AAPL	Stock	30.235	30.245	30.185	30.2275	11127644.0
2015-11-02 15:00:00	AAPL	Stock	30.2275	30.34	30.2025	30.2975	22408980.0
2015-11-02 16:00:00	AAPL	Stock	30.29	30.315	30.2625	30.2625	4264348.0
2015-11-02 17:00:00	AAPL	Stock	30.265	30.295	30.265	30.285	372464.0
2015-11-02 18:00:00	AAPL	Stock	30.2825	30.2825	30.2625	30.265	53556.0
2015-11-02 19:00:00	AAPL	Stock	30.265	30.3125	30.2625	30.3125	78604.0
2015-11-02 05:00:00	MSFT	Stock	52.65	52.74	52.65	52.74	300.0
2015-11-02 06:00:00	MSFT	Stock	52.66	52.66	52.66	52.66	100.0
2015-11-02 07:00:00	MSFT	Stock	52.7	52.85	52.7	52.8	2845.0
2015-11-02 08:00:00	MSFT	Stock	52.8	52.85	52.75	52.82	9290.0
2015-11-02 09:00:00	MSFT	Stock	52.64	52.98	52.62	52.96	2553040.0
2015-11-02 10:00:00	MSFT	Stock	52.97	53.15	52.89	52.946	4133823.0
2015-11-02 11:00:00	MSFT	Stock	52.945	53.01	52.87	52.98	3583408.0
2015-11-02 12:00:00	MSFT	Stock	52.975	53.31	52.92	53.224	3813217.0
2015-11-02 13:00:00	MSFT	Stock	53.23	53.265	53.08	53.12	2481055.0
2015-11-02 14:00:00	MSFT	Stock	53.12	53.27	53.11	53.26	2696797.0
2015-11-02 15:00:00	MSFT	Stock	53.265	53.36	53.09	53.23	6026899.0
2015-11-02 16:00:00	MSFT	Stock	53.24	53.25	53.112	53.2	3209418.0
2015-11-02 17:00:00	MSFT	Stock	53.14	53.16	53.14	53.16	4945.0
2015-11-02 18:00:00	MSFT	Stock	53.22	53.22	53.2	53.2	300.0
2015-11-02 19:00:00	MSFT	Stock	53.16	53.23	53.16	53.17	862.0
2015-11-02 08:00:00	NVDA	Stock	0.7165	0.7188	0.7165	0.7188	100000.0
2015-11-02 09:00:00	NVDA	Stock	0.7173	0.7173	0.7072	0.715	23672600.0
2015-11-02 10:00:00	NVDA	Stock	0.715	0.7173	0.7123	0.7143	31432040.0
2015-11-02 11:00:00	NVDA	Stock	0.7141	0.717	0.713	0.7135	21384240.0
2015-11-02 12:00:00	NVDA	Stock	0.7135	0.7148	0.7114	0.7145	11663800.0
2015-11-02 13:00:00	NVDA	Stock	0.7145	0.718	0.7145	0.717	15351080.0
2015-11-02 14:00:00	NVDA	Stock	0.7168	0.7183	0.7159	0.718	13085920.0
2015-11-02 15:00:00	NVDA	Stock	0.7178	0.718	0.7158	0.7175	40946120.0
2015-11-02 16:00:00	NVDA	Stock	0.7175	0.7178	0.7155	0.7178	17377680.0
2015-11-02 17:00:00	NVDA	Stock	0.7176	0.7176	0.7175	0.7175	443560.0
2015-11-02 04:00:00	AMZN	Stock	31.2995	31.2995	31.2995	31.2995	2000.0
2015-11-02 06:00:00	AMZN	Stock	31.325	31.325	31.325	31.325	4000.0
2015-11-02 07:00:00	AMZN	Stock	31.3065	31.309	31.3065	31.309	7540.0
2015-11-02 08:00:00	AMZN	Stock	31.3255	31.3675	31.295	31.35	208440.0
2015-11-02 09:00:00	AMZN	Stock	31.35	31.3701	31.0275	31.14	13651240.0
2015-11-02 10:00:00	AMZN	Stock	31.142	31.2	31.0205	31.1262	9652920.0
2015-11-02 11:00:00	AMZN	Stock	31.1278	31.294	31.1005	31.2808	6433700.0
2015-11-02 12:00:00	AMZN	Stock	31.2855	31.2895	31.2285	31.263	5021720.0
2015-11-02 13:00:00	AMZN	Stock	31.26	31.3395	31.2185	31.3395	4296060.0

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

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