PREVIEW / stock_1hour / 2010-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-12.parquet
  size:    919 KB
  rows:    43,881
  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-04-12 04:00:00	AAPL	Stock	8.6629	8.6746	8.6629	8.6746	36316.0
2010-04-12 05:00:00	AAPL	Stock	8.6746	8.675	8.6614	8.6614	19628.0
2010-04-12 06:00:00	AAPL	Stock	8.6607	8.6607	8.6607	8.6607	47264.0
2010-04-12 07:00:00	AAPL	Stock	8.6625	8.6629	8.6375	8.6429	191688.0
2010-04-12 08:00:00	AAPL	Stock	8.65	8.6571	8.6396	8.6429	1738268.0
2010-04-12 09:00:00	AAPL	Stock	8.6429	8.675	8.6361	8.6407	58349200.0
2010-04-12 10:00:00	AAPL	Stock	8.64	8.6721	8.6389	8.6679	65523108.0
2010-04-12 11:00:00	AAPL	Stock	8.6668	8.6746	8.6554	8.6679	36529668.0
2010-04-12 12:00:00	AAPL	Stock	8.6679	8.6714	8.6586	8.6636	22116388.0
2010-04-12 13:00:00	AAPL	Stock	8.6636	8.6811	8.6625	8.6629	36438164.0
2010-04-12 14:00:00	AAPL	Stock	8.6632	8.6743	8.6554	8.6718	31682700.0
2010-04-12 15:00:00	AAPL	Stock	8.6721	8.6739	8.6429	8.6539	62617968.0
2010-04-12 16:00:00	AAPL	Stock	8.6532	8.6685	8.6479	8.6525	13170052.0
2010-04-12 17:00:00	AAPL	Stock	8.6511	8.6529	8.6468	8.6529	180740.0
2010-04-12 18:00:00	AAPL	Stock	8.6525	8.6532	8.6486	8.6532	91028.0
2010-04-12 19:00:00	AAPL	Stock	8.65	8.6525	8.6486	8.6486	88648.0
2010-04-12 20:00:00	AAPL	Stock	8.6596	8.6596	8.6596	8.6596	33600.0
2010-04-12 08:00:00	MSFT	Stock	30.37	30.4	30.31	30.31	16467.0
2010-04-12 09:00:00	MSFT	Stock	30.3	30.415	30.205	30.31	4274602.0
2010-04-12 10:00:00	MSFT	Stock	30.31	30.49	30.27	30.32	7110700.0
2010-04-12 11:00:00	MSFT	Stock	30.32	30.4	30.27	30.391	3817579.0
2010-04-12 12:00:00	MSFT	Stock	30.4	30.42	30.32	30.36	2896027.0
2010-04-12 13:00:00	MSFT	Stock	30.36	30.4	30.31	30.322	4684216.0
2010-04-12 14:00:00	MSFT	Stock	30.32	30.44	30.32	30.44	3806903.0
2010-04-12 15:00:00	MSFT	Stock	30.44	30.44	30.31	30.32	7444903.0
2010-04-12 16:00:00	MSFT	Stock	30.32	30.386	30.31	30.32	2196525.0
2010-04-12 17:00:00	MSFT	Stock	30.32	30.35	30.31	30.33	1260.0
2010-04-12 18:00:00	MSFT	Stock	30.32	30.33	30.3	30.33	5946.0
2010-04-12 20:00:00	MSFT	Stock	30.37	30.37	30.37	30.37	400.0
2010-04-12 08:00:00	NVDA	Stock	0.425	0.4288	0.425	0.4288	304000.0
2010-04-12 09:00:00	NVDA	Stock	0.4272	0.4275	0.4245	0.4245	42178360.0
2010-04-12 10:00:00	NVDA	Stock	0.4245	0.4288	0.4245	0.4288	92509280.0
2010-04-12 11:00:00	NVDA	Stock	0.4286	0.431	0.4282	0.4295	65805280.0
2010-04-12 12:00:00	NVDA	Stock	0.4295	0.431	0.4278	0.431	49137360.0
2010-04-12 13:00:00	NVDA	Stock	0.431	0.4332	0.4305	0.4328	68543040.0
2010-04-12 14:00:00	NVDA	Stock	0.4328	0.4332	0.4315	0.4328	49139440.0
2010-04-12 15:00:00	NVDA	Stock	0.4328	0.4342	0.431	0.4324	138202960.0
2010-04-12 16:00:00	NVDA	Stock	0.4325	0.434	0.4277	0.4325	24019280.0
2010-04-12 17:00:00	NVDA	Stock	0.4318	0.4325	0.4318	0.4325	28000.0
2010-04-12 18:00:00	NVDA	Stock	0.4325	0.4325	0.4325	0.4325	32000.0
2010-04-12 19:00:00	NVDA	Stock	0.4318	0.4318	0.4318	0.4318	8000.0
2010-04-12 05:00:00	AMZN	Stock	7.0	7.0	7.0	7.0	3500.0
2010-04-12 07:00:00	AMZN	Stock	7.0	7.0	7.0	7.0	4000.0
2010-04-12 08:00:00	AMZN	Stock	7.0	7.01	6.987	6.987	161500.0
2010-04-12 09:00:00	AMZN	Stock	6.9965	7.1458	6.984	7.0845	26105900.0
2010-04-12 10:00:00	AMZN	Stock	7.0825	7.132	7.055	7.1274	22524840.0
2010-04-12 11:00:00	AMZN	Stock	7.126	7.132	7.075	7.0835	10938640.0
2010-04-12 12:00:00	AMZN	Stock	7.0845	7.1115	7.081	7.101	7718340.0
2010-04-12 13:00:00	AMZN	Stock	7.1025	7.13	7.0995	7.1	8324700.0
2010-04-12 14:00:00	AMZN	Stock	7.1005	7.1165	7.091	7.1075	10746240.0

> showing 50 of 43,881 rows — these rows as CSV

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