PREVIEW / stock_1hour / 2012-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-27.parquet
  size:    988 KB
  rows:    47,981
  symbols: 3,531

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
2012-04-27 04:00:00	AAPL	Stock	21.6136	21.675	21.6136	21.675	39368.0
2012-04-27 05:00:00	AAPL	Stock	21.6768	21.6786	21.6436	21.6607	27300.0
2012-04-27 06:00:00	AAPL	Stock	21.6782	21.7036	21.6671	21.7036	21196.0
2012-04-27 07:00:00	AAPL	Stock	21.6964	21.7321	21.6679	21.7043	306152.0
2012-04-27 08:00:00	AAPL	Stock	21.6911	21.7357	21.5696	21.6246	2548840.0
2012-04-27 09:00:00	AAPL	Stock	21.6257	21.6493	21.4464	21.5079	90027336.0
2012-04-27 10:00:00	AAPL	Stock	21.505	21.5886	21.4582	21.5654	79710736.0
2012-04-27 11:00:00	AAPL	Stock	21.5618	21.6493	21.5429	21.61	53177740.0
2012-04-27 12:00:00	AAPL	Stock	21.6104	21.6161	21.5357	21.5607	32005428.0
2012-04-27 13:00:00	AAPL	Stock	21.5621	21.6071	21.5536	21.5743	23033808.0
2012-04-27 14:00:00	AAPL	Stock	21.5725	21.5746	21.4793	21.5371	41956516.0
2012-04-27 15:00:00	AAPL	Stock	21.5389	21.5446	21.4932	21.5357	68923624.0
2012-04-27 16:00:00	AAPL	Stock	21.5357	21.5671	21.5161	21.5393	9713088.0
2012-04-27 17:00:00	AAPL	Stock	21.5361	21.5518	21.5261	21.5286	378980.0
2012-04-27 18:00:00	AAPL	Stock	21.5257	21.53	21.5189	21.5264	58044.0
2012-04-27 19:00:00	AAPL	Stock	21.5268	21.5311	21.5186	21.5311	144508.0
2012-04-27 07:00:00	MSFT	Stock	32.07	32.1	32.05	32.1	7700.0
2012-04-27 08:00:00	MSFT	Stock	32.05	32.7	32.05	32.21	38351.0
2012-04-27 09:00:00	MSFT	Stock	32.25	32.29	31.93	31.99	4320038.0
2012-04-27 10:00:00	MSFT	Stock	31.99	32.06	31.91	32.04	6067453.0
2012-04-27 11:00:00	MSFT	Stock	32.04	32.09	31.97	32.0	4705538.0
2012-04-27 12:00:00	MSFT	Stock	32.0	32.015	31.97	31.999	2585958.0
2012-04-27 13:00:00	MSFT	Stock	32.0	32.07	31.98	32.04	4369180.0
2012-04-27 14:00:00	MSFT	Stock	32.036	32.08	32.01	32.025	5347660.0
2012-04-27 15:00:00	MSFT	Stock	32.025	32.025	31.88	31.98	7440848.0
2012-04-27 16:00:00	MSFT	Stock	31.98	32.128	31.91	31.97	5529553.0
2012-04-27 17:00:00	MSFT	Stock	31.99	32.03	31.97	32.02	16726.0
2012-04-27 18:00:00	MSFT	Stock	32.02	32.03	32.01	32.02	3613.0
2012-04-27 19:00:00	MSFT	Stock	32.01	32.02	31.99	31.99	3200.0
2012-04-27 08:00:00	NVDA	Stock	0.3253	0.3253	0.3253	0.3253	20000.0
2012-04-27 09:00:00	NVDA	Stock	0.3265	0.3283	0.3223	0.3235	59739880.0
2012-04-27 10:00:00	NVDA	Stock	0.3235	0.324	0.321	0.3233	87318440.0
2012-04-27 11:00:00	NVDA	Stock	0.3233	0.324	0.3218	0.323	50470240.0
2012-04-27 12:00:00	NVDA	Stock	0.3231	0.3268	0.323	0.325	57452920.0
2012-04-27 13:00:00	NVDA	Stock	0.3248	0.3286	0.3248	0.3265	46139640.0
2012-04-27 14:00:00	NVDA	Stock	0.3265	0.3268	0.3243	0.3245	27371480.0
2012-04-27 15:00:00	NVDA	Stock	0.3245	0.3253	0.3238	0.3243	110289200.0
2012-04-27 16:00:00	NVDA	Stock	0.3243	0.3271	0.3242	0.3243	19413240.0
2012-04-27 17:00:00	NVDA	Stock	0.3273	0.3273	0.3238	0.3238	242000.0
2012-04-27 18:00:00	NVDA	Stock	0.3243	0.3243	0.3243	0.3243	4000.0
2012-04-27 04:00:00	AMZN	Stock	11.075	11.075	10.9	10.975	135440.0
2012-04-27 05:00:00	AMZN	Stock	10.99	11.015	10.96	11.0	65800.0
2012-04-27 06:00:00	AMZN	Stock	11.025	11.1885	11.0	11.1885	801900.0
2012-04-27 07:00:00	AMZN	Stock	11.19	11.415	11.18	11.3655	4469220.0
2012-04-27 08:00:00	AMZN	Stock	11.3655	11.514	11.205	11.4935	19052900.0
2012-04-27 09:00:00	AMZN	Stock	11.494	11.5715	11.09	11.185	128660640.0
2012-04-27 10:00:00	AMZN	Stock	11.1882	11.197	11.011	11.0335	71494120.0
2012-04-27 11:00:00	AMZN	Stock	11.0338	11.2815	11.0335	11.252	47191300.0
2012-04-27 12:00:00	AMZN	Stock	11.2516	11.3735	11.2045	11.3705	29598820.0
2012-04-27 13:00:00	AMZN	Stock	11.3705	11.4345	11.333	11.3375	37146160.0

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

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