PREVIEW / stock_1hour / 2010-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-21.parquet
  size:    928 KB
  rows:    44,265
  symbols: 3,492

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-05-21 04:00:00	AAPL	Stock	8.4182	8.4993	8.4182	8.4993	56644.0
2010-05-21 05:00:00	AAPL	Stock	8.4993	8.5136	8.4607	8.4607	25200.0
2010-05-21 06:00:00	AAPL	Stock	8.4571	8.4571	8.4182	8.4286	22400.0
2010-05-21 07:00:00	AAPL	Stock	8.4179	8.4289	8.2504	8.3479	2516360.0
2010-05-21 08:00:00	AAPL	Stock	8.3671	8.4182	8.3279	8.4143	8899604.0
2010-05-21 09:00:00	AAPL	Stock	8.4111	8.5493	8.2625	8.4775	293885200.0
2010-05-21 10:00:00	AAPL	Stock	8.4743	8.5996	8.4521	8.5804	228730740.0
2010-05-21 11:00:00	AAPL	Stock	8.5789	8.7321	8.4676	8.6732	174247248.0
2010-05-21 12:00:00	AAPL	Stock	8.6746	8.7204	8.6339	8.6464	98605640.0
2010-05-21 13:00:00	AAPL	Stock	8.6464	8.665	8.5964	8.6303	89360180.0
2010-05-21 14:00:00	AAPL	Stock	8.6299	8.6518	8.5232	8.5461	120989344.0
2010-05-21 15:00:00	AAPL	Stock	8.5461	8.6557	8.515	8.6546	180518660.0
2010-05-21 16:00:00	AAPL	Stock	8.6554	8.6561	8.544	8.6329	19214300.0
2010-05-21 17:00:00	AAPL	Stock	8.6232	8.6514	8.6161	8.6507	644392.0
2010-05-21 18:00:00	AAPL	Stock	8.6511	8.66	8.6452	8.6571	265860.0
2010-05-21 19:00:00	AAPL	Stock	8.6571	8.6686	8.6482	8.6686	361592.0
2010-05-21 05:00:00	MSFT	Stock	27.15	27.2	27.08	27.08	5000.0
2010-05-21 06:00:00	MSFT	Stock	27.1	27.16	27.1	27.16	3940.0
2010-05-21 07:00:00	MSFT	Stock	26.97	26.97	26.61	26.8	13073.0
2010-05-21 08:00:00	MSFT	Stock	26.8	26.96	26.8	26.9	75863.0
2010-05-21 09:00:00	MSFT	Stock	26.88	27.0	26.52	26.74	15030774.0
2010-05-21 10:00:00	MSFT	Stock	26.737	26.98	26.66	26.858	18510141.0
2010-05-21 11:00:00	MSFT	Stock	26.86	27.11	26.85	27.035	14946741.0
2010-05-21 12:00:00	MSFT	Stock	27.04	27.05	26.76	26.82	11983079.0
2010-05-21 13:00:00	MSFT	Stock	26.82	26.93	26.66	26.9	7557530.0
2010-05-21 14:00:00	MSFT	Stock	26.9	26.93	26.56	26.64	8887841.0
2010-05-21 15:00:00	MSFT	Stock	26.64	26.87	26.44	26.86	24829806.0
2010-05-21 16:00:00	MSFT	Stock	26.87	27.12	26.664	26.85	3536242.0
2010-05-21 17:00:00	MSFT	Stock	26.85	26.88	26.81	26.88	15066.0
2010-05-21 18:00:00	MSFT	Stock	26.88	26.92	26.82	26.9	7000.0
2010-05-21 19:00:00	MSFT	Stock	26.89	26.9	26.89	26.89	600.0
2010-05-21 07:00:00	NVDA	Stock	0.3075	0.3075	0.3075	0.3075	12000.0
2010-05-21 08:00:00	NVDA	Stock	0.3018	0.304	0.3012	0.3018	128000.0
2010-05-21 09:00:00	NVDA	Stock	0.3055	0.3223	0.3022	0.3193	237162080.0
2010-05-21 10:00:00	NVDA	Stock	0.319	0.3235	0.3128	0.3175	196807080.0
2010-05-21 11:00:00	NVDA	Stock	0.3175	0.3269	0.3175	0.3255	216740360.0
2010-05-21 12:00:00	NVDA	Stock	0.3254	0.3255	0.32	0.321	101455720.0
2010-05-21 13:00:00	NVDA	Stock	0.321	0.3217	0.3183	0.3193	67718600.0
2010-05-21 14:00:00	NVDA	Stock	0.3193	0.32	0.3143	0.316	93305040.0
2010-05-21 15:00:00	NVDA	Stock	0.316	0.3188	0.313	0.3185	138622600.0
2010-05-21 16:00:00	NVDA	Stock	0.3175	0.3205	0.3157	0.3205	8531880.0
2010-05-21 17:00:00	NVDA	Stock	0.3213	0.3213	0.32	0.32	455200.0
2010-05-21 18:00:00	NVDA	Stock	0.3183	0.3203	0.3183	0.3203	84000.0
2010-05-21 19:00:00	NVDA	Stock	0.32	0.32	0.3183	0.3183	46240.0
2010-05-21 08:00:00	AMZN	Stock	5.9505	5.965	5.9325	5.965	94360.0
2010-05-21 09:00:00	AMZN	Stock	5.9505	6.1305	5.876	6.0655	41463080.0
2010-05-21 10:00:00	AMZN	Stock	6.0655	6.159	6.053	6.08	22912340.0
2010-05-21 11:00:00	AMZN	Stock	6.0825	6.2485	6.0705	6.187	23832600.0
2010-05-21 12:00:00	AMZN	Stock	6.1855	6.1865	6.117	6.1415	13484180.0
2010-05-21 13:00:00	AMZN	Stock	6.1415	6.155	6.1085	6.142	9498100.0

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

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