PREVIEW / stock_1hour / 2010-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-01.parquet
  size:    934 KB
  rows:    45,617
  symbols: 3,446

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-06-01 04:00:00	AAPL	Stock	9.1714	9.1771	9.1214	9.1571	195720.0
2010-06-01 05:00:00	AAPL	Stock	9.1211	9.1304	9.1211	9.125	18928.0
2010-06-01 06:00:00	AAPL	Stock	9.1321	9.175	9.1321	9.1464	70224.0
2010-06-01 07:00:00	AAPL	Stock	9.175	9.2393	9.1743	9.2357	1083600.0
2010-06-01 08:00:00	AAPL	Stock	9.2296	9.2657	9.1743	9.2539	5915000.0
2010-06-01 09:00:00	AAPL	Stock	9.2536	9.3643	9.1743	9.3332	126289856.0
2010-06-01 10:00:00	AAPL	Stock	9.3354	9.4711	9.3321	9.4171	178710840.0
2010-06-01 11:00:00	AAPL	Stock	9.4179	9.4286	9.3643	9.3754	88721416.0
2010-06-01 12:00:00	AAPL	Stock	9.3764	9.4464	9.3686	9.4189	70726264.0
2010-06-01 13:00:00	AAPL	Stock	9.4161	9.4979	9.4161	9.4357	100461172.0
2010-06-01 14:00:00	AAPL	Stock	9.4332	9.4643	9.3929	9.4389	93899316.0
2010-06-01 15:00:00	AAPL	Stock	9.4393	9.4475	9.2957	9.3143	183104796.0
2010-06-01 16:00:00	AAPL	Stock	9.3143	9.3282	9.2746	9.3282	14889364.0
2010-06-01 17:00:00	AAPL	Stock	9.3286	9.3375	9.3054	9.3275	2566396.0
2010-06-01 18:00:00	AAPL	Stock	9.3268	9.3375	9.3154	9.3321	905408.0
2010-06-01 19:00:00	AAPL	Stock	9.3304	9.3482	9.3304	9.3479	900676.0
2010-06-01 04:00:00	MSFT	Stock	25.68	25.68	25.66	25.66	1200.0
2010-06-01 06:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	115.0
2010-06-01 07:00:00	MSFT	Stock	25.54	25.55	25.5	25.5	5765.0
2010-06-01 08:00:00	MSFT	Stock	25.57	25.8	25.49	25.53	38240.0
2010-06-01 09:00:00	MSFT	Stock	25.52	25.89	25.52	25.81	7104902.0
2010-06-01 10:00:00	MSFT	Stock	25.81	26.19	25.802	26.032	10907643.0
2010-06-01 11:00:00	MSFT	Stock	26.03	26.08	25.87	25.93	6702587.0
2010-06-01 12:00:00	MSFT	Stock	25.92	26.15	25.9	26.115	6397384.0
2010-06-01 13:00:00	MSFT	Stock	26.11	26.26	26.11	26.2	5677522.0
2010-06-01 14:00:00	MSFT	Stock	26.2	26.31	26.14	26.3	13309546.0
2010-06-01 15:00:00	MSFT	Stock	26.295	26.305	25.82	25.89	21093272.0
2010-06-01 16:00:00	MSFT	Stock	25.87	26.201	25.787	25.88	3281214.0
2010-06-01 17:00:00	MSFT	Stock	25.88	25.92	25.85	25.91	200144.0
2010-06-01 18:00:00	MSFT	Stock	25.91	25.91	25.89	25.91	25681.0
2010-06-01 19:00:00	MSFT	Stock	25.92	25.92	25.85	25.92	2960.0
2010-06-01 08:00:00	NVDA	Stock	0.325	0.325	0.322	0.3223	122400.0
2010-06-01 09:00:00	NVDA	Stock	0.3228	0.326	0.319	0.3215	60396560.0
2010-06-01 10:00:00	NVDA	Stock	0.3213	0.3278	0.3213	0.323	98848680.0
2010-06-01 11:00:00	NVDA	Stock	0.323	0.3238	0.3198	0.32	65675880.0
2010-06-01 12:00:00	NVDA	Stock	0.3201	0.3225	0.3198	0.321	42646960.0
2010-06-01 13:00:00	NVDA	Stock	0.3208	0.3238	0.3205	0.3215	39801760.0
2010-06-01 14:00:00	NVDA	Stock	0.3213	0.3225	0.3203	0.3205	64535400.0
2010-06-01 15:00:00	NVDA	Stock	0.3205	0.3206	0.3143	0.3143	125660760.0
2010-06-01 16:00:00	NVDA	Stock	0.3143	0.3282	0.3138	0.3145	15743160.0
2010-06-01 17:00:00	NVDA	Stock	0.3145	0.3145	0.3135	0.3135	1254600.0
2010-06-01 18:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	12000.0
2010-06-01 19:00:00	NVDA	Stock	0.3153	0.3153	0.3153	0.3153	83200.0
2010-06-01 07:00:00	AMZN	Stock	6.18	6.18	6.18	6.18	4000.0
2010-06-01 08:00:00	AMZN	Stock	6.1505	6.2325	6.15	6.2205	61880.0
2010-06-01 09:00:00	AMZN	Stock	6.273	6.3	6.2	6.251	9952780.0
2010-06-01 10:00:00	AMZN	Stock	6.2535	6.3286	6.2508	6.302	12049900.0
2010-06-01 11:00:00	AMZN	Stock	6.3035	6.313	6.245	6.247	6784360.0
2010-06-01 12:00:00	AMZN	Stock	6.2485	6.2625	6.2245	6.2405	7689340.0
2010-06-01 13:00:00	AMZN	Stock	6.24	6.3085	6.24	6.2735	5895700.0

> showing 50 of 45,617 rows — these rows as CSV

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