PREVIEW / stock_1hour / 2010-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-26.parquet
  size:    946 KB
  rows:    44,606
  symbols: 3,510

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
2010-04-26 04:00:00	AAPL	Stock	9.7143	9.7143	9.7143	9.7143	11200.0
2010-04-26 05:00:00	AAPL	Stock	9.7143	9.7143	9.7143	9.7143	43148.0
2010-04-26 06:00:00	AAPL	Stock	9.7221	9.7286	9.7179	9.7286	44576.0
2010-04-26 07:00:00	AAPL	Stock	9.7321	9.7429	9.7286	9.7321	316820.0
2010-04-26 08:00:00	AAPL	Stock	9.7321	9.7321	9.6914	9.7136	4012932.0
2010-04-26 09:00:00	AAPL	Stock	9.7107	9.7307	9.5843	9.595	115515204.0
2010-04-26 10:00:00	AAPL	Stock	9.5966	9.6536	9.595	9.647	89331144.0
2010-04-26 11:00:00	AAPL	Stock	9.6471	9.6721	9.6196	9.6225	48659240.0
2010-04-26 12:00:00	AAPL	Stock	9.6225	9.6257	9.6036	9.6246	40898676.0
2010-04-26 13:00:00	AAPL	Stock	9.6244	9.6379	9.6107	9.6211	31968972.0
2010-04-26 14:00:00	AAPL	Stock	9.6221	9.6418	9.6061	9.6093	35291060.0
2010-04-26 15:00:00	AAPL	Stock	9.6093	9.6725	9.5782	9.625	79766120.0
2010-04-26 16:00:00	AAPL	Stock	9.6243	9.6446	9.6073	9.6179	25514300.0
2010-04-26 17:00:00	AAPL	Stock	9.6196	9.625	9.6125	9.6143	390600.0
2010-04-26 18:00:00	AAPL	Stock	9.6143	9.625	9.6086	9.6179	1262268.0
2010-04-26 19:00:00	AAPL	Stock	9.6107	9.6171	9.6107	9.6129	153664.0
2010-04-26 06:00:00	MSFT	Stock	30.83	30.83	30.83	30.83	450.0
2010-04-26 07:00:00	MSFT	Stock	30.99	31.0	30.92	31.0	2180.0
2010-04-26 08:00:00	MSFT	Stock	30.96	31.07	30.95	31.02	85560.0
2010-04-26 09:00:00	MSFT	Stock	31.01	31.1	30.86	31.03	6987268.0
2010-04-26 10:00:00	MSFT	Stock	31.026	31.17	30.95	31.16	9337251.0
2010-04-26 11:00:00	MSFT	Stock	31.15	31.18	31.04	31.052	7607840.0
2010-04-26 12:00:00	MSFT	Stock	31.05	31.15	31.01	31.12	5445539.0
2010-04-26 13:00:00	MSFT	Stock	31.12	31.155	31.08	31.11	5778906.0
2010-04-26 14:00:00	MSFT	Stock	31.105	31.24	31.1	31.15	5982035.0
2010-04-26 15:00:00	MSFT	Stock	31.15	31.275	31.09	31.1	14427108.0
2010-04-26 16:00:00	MSFT	Stock	31.1	31.21	30.99	31.12	5782045.0
2010-04-26 17:00:00	MSFT	Stock	31.13	31.13	31.09	31.09	39664.0
2010-04-26 18:00:00	MSFT	Stock	31.04	31.14	31.04	31.14	2160.0
2010-04-26 19:00:00	MSFT	Stock	31.11	31.12	31.11	31.11	1440.0
2010-04-26 08:00:00	NVDA	Stock	0.4105	0.4108	0.4105	0.4108	34680.0
2010-04-26 09:00:00	NVDA	Stock	0.4118	0.42	0.411	0.414	64279760.0
2010-04-26 10:00:00	NVDA	Stock	0.414	0.4162	0.4108	0.4152	63196400.0
2010-04-26 11:00:00	NVDA	Stock	0.415	0.4175	0.4138	0.4151	73614640.0
2010-04-26 12:00:00	NVDA	Stock	0.4151	0.4168	0.413	0.4168	92716440.0
2010-04-26 13:00:00	NVDA	Stock	0.4168	0.417	0.4148	0.4158	43291040.0
2010-04-26 14:00:00	NVDA	Stock	0.4158	0.4185	0.4148	0.415	61121680.0
2010-04-26 15:00:00	NVDA	Stock	0.4148	0.416	0.4133	0.415	81736800.0
2010-04-26 16:00:00	NVDA	Stock	0.415	0.4152	0.411	0.415	9615200.0
2010-04-26 17:00:00	NVDA	Stock	0.415	0.415	0.415	0.415	96240.0
2010-04-26 19:00:00	NVDA	Stock	0.415	0.415	0.415	0.415	40000.0
2010-04-26 04:00:00	AMZN	Stock	7.199	7.244	7.199	7.244	20000.0
2010-04-26 07:00:00	AMZN	Stock	7.22	7.22	7.22	7.22	13000.0
2010-04-26 08:00:00	AMZN	Stock	7.2	7.2	7.1555	7.165	155480.0
2010-04-26 09:00:00	AMZN	Stock	7.1625	7.2475	7.145	7.225	32393960.0
2010-04-26 10:00:00	AMZN	Stock	7.2234	7.2825	7.19	7.276	31522560.0
2010-04-26 11:00:00	AMZN	Stock	7.2772	7.3475	7.2615	7.3035	37162640.0
2010-04-26 12:00:00	AMZN	Stock	7.3015	7.33	7.285	7.3265	13271160.0
2010-04-26 13:00:00	AMZN	Stock	7.328	7.3295	7.299	7.315	11370680.0
2010-04-26 14:00:00	AMZN	Stock	7.3142	7.3865	7.3055	7.35	27634040.0

> showing 50 of 44,606 rows — these rows as CSV

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