PREVIEW / stock_1hour / 2012-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-23.parquet
  size:    926 KB
  rows:    44,191
  symbols: 3,476

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-07-23 04:00:00	AAPL	Stock	21.6071	21.6071	21.3429	21.3429	93268.0
2012-07-23 05:00:00	AAPL	Stock	21.3661	21.3818	21.3625	21.3625	11200.0
2012-07-23 06:00:00	AAPL	Stock	21.375	21.3929	21.375	21.3929	55748.0
2012-07-23 07:00:00	AAPL	Stock	21.3929	21.4286	21.3089	21.3214	474488.0
2012-07-23 08:00:00	AAPL	Stock	21.3214	21.395	21.1543	21.2518	4427752.0
2012-07-23 09:00:00	AAPL	Stock	21.25	21.2679	20.9896	21.1221	99468908.0
2012-07-23 10:00:00	AAPL	Stock	21.1161	21.415	21.0593	21.325	122842972.0
2012-07-23 11:00:00	AAPL	Stock	21.3214	21.3896	21.2812	21.3511	46401880.0
2012-07-23 12:00:00	AAPL	Stock	21.3536	21.4943	21.3161	21.4614	38074204.0
2012-07-23 13:00:00	AAPL	Stock	21.4611	21.5332	21.4464	21.5179	35646128.0
2012-07-23 14:00:00	AAPL	Stock	21.52	21.6221	21.5036	21.5564	58801316.0
2012-07-23 15:00:00	AAPL	Stock	21.5539	21.6393	21.5	21.5657	64915032.0
2012-07-23 16:00:00	AAPL	Stock	21.5589	21.6296	21.0152	21.5214	6759144.0
2012-07-23 17:00:00	AAPL	Stock	21.5296	21.5654	21.2966	21.5161	498736.0
2012-07-23 18:00:00	AAPL	Stock	21.5096	21.5218	21.5	21.5	465640.0
2012-07-23 19:00:00	AAPL	Stock	21.4996	21.5096	21.4857	21.4964	458584.0
2012-07-23 06:00:00	MSFT	Stock	29.52	29.54	29.41	29.41	1365.0
2012-07-23 07:00:00	MSFT	Stock	29.54	29.75	29.53	29.75	4833.0
2012-07-23 08:00:00	MSFT	Stock	29.74	30.07	29.54	29.61	67015.0
2012-07-23 09:00:00	MSFT	Stock	29.56	29.64	29.03	29.17	6896113.0
2012-07-23 10:00:00	MSFT	Stock	29.17	29.21	29.05	29.115	10493452.0
2012-07-23 11:00:00	MSFT	Stock	29.115	29.14	29.01	29.1	7406422.0
2012-07-23 12:00:00	MSFT	Stock	29.1	29.25	29.08	29.17	7417878.0
2012-07-23 13:00:00	MSFT	Stock	29.17	29.3	29.14	29.24	4316262.0
2012-07-23 14:00:00	MSFT	Stock	29.235	29.31	29.2	29.23	4832611.0
2012-07-23 15:00:00	MSFT	Stock	29.23	29.33	29.18	29.28	10504964.0
2012-07-23 16:00:00	MSFT	Stock	29.27	29.304	29.084	29.21	2043750.0
2012-07-23 17:00:00	MSFT	Stock	29.22	29.25	29.114	29.25	57577.0
2012-07-23 18:00:00	MSFT	Stock	29.23	29.23	29.19	29.19	5870.0
2012-07-23 19:00:00	MSFT	Stock	29.17	29.2	29.17	29.2	2400.0
2012-07-23 07:00:00	NVDA	Stock	0.314	0.314	0.3065	0.3065	8000.0
2012-07-23 08:00:00	NVDA	Stock	0.319	0.3203	0.3105	0.3123	896440.0
2012-07-23 09:00:00	NVDA	Stock	0.3123	0.3163	0.3083	0.3158	55096760.0
2012-07-23 10:00:00	NVDA	Stock	0.3158	0.3208	0.3155	0.3188	77456360.0
2012-07-23 11:00:00	NVDA	Stock	0.3188	0.3228	0.3183	0.3225	55957680.0
2012-07-23 12:00:00	NVDA	Stock	0.3225	0.3228	0.3183	0.3205	42779320.0
2012-07-23 13:00:00	NVDA	Stock	0.3208	0.3258	0.3203	0.3248	66283400.0
2012-07-23 14:00:00	NVDA	Stock	0.3245	0.3256	0.324	0.324	43737680.0
2012-07-23 15:00:00	NVDA	Stock	0.324	0.3267	0.3235	0.3245	84771240.0
2012-07-23 16:00:00	NVDA	Stock	0.3248	0.3263	0.3123	0.3123	2037360.0
2012-07-23 05:00:00	AMZN	Stock	11.2625	11.2625	11.2625	11.2625	3400.0
2012-07-23 07:00:00	AMZN	Stock	11.2775	11.29	11.2705	11.29	28000.0
2012-07-23 08:00:00	AMZN	Stock	11.276	11.2765	11.2325	11.2325	263260.0
2012-07-23 09:00:00	AMZN	Stock	11.23	11.25	11.085	11.1375	12596720.0
2012-07-23 10:00:00	AMZN	Stock	11.1325	11.195	11.077	11.0895	53656440.0
2012-07-23 11:00:00	AMZN	Stock	11.0895	11.194	11.086	11.1275	7557040.0
2012-07-23 12:00:00	AMZN	Stock	11.1275	11.1773	11.0988	11.1545	6135520.0
2012-07-23 13:00:00	AMZN	Stock	11.1545	11.225	11.1485	11.2075	6661140.0
2012-07-23 14:00:00	AMZN	Stock	11.2115	11.3175	11.1863	11.307	10325020.0
2012-07-23 15:00:00	AMZN	Stock	11.3045	11.329	11.2825	11.3	10706940.0

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

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