PREVIEW / stock_1hour / 2009-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-21.parquet
  size:    868 KB
  rows:    41,861
  symbols: 3,383

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
2009-08-21 07:00:00	AAPL	Stock	5.9643	5.9821	5.9643	5.9714	890092.0
2009-08-21 08:00:00	AAPL	Stock	5.9643	5.975	5.9625	5.9714	788284.0
2009-08-21 09:00:00	AAPL	Stock	5.9714	5.9964	5.9571	5.975	84852348.0
2009-08-21 10:00:00	AAPL	Stock	5.975	6.0286	5.975	6.0139	88200392.0
2009-08-21 11:00:00	AAPL	Stock	6.0136	6.0296	6.0118	6.0196	39571280.0
2009-08-21 12:00:00	AAPL	Stock	6.019	6.0264	6.0136	6.0164	27963516.0
2009-08-21 13:00:00	AAPL	Stock	6.0161	6.0211	6.0061	6.0075	28593320.0
2009-08-21 14:00:00	AAPL	Stock	6.0075	6.0279	6.0057	6.0264	36428280.0
2009-08-21 15:00:00	AAPL	Stock	6.0264	6.0489	6.0246	6.0429	83019496.0
2009-08-21 16:00:00	AAPL	Stock	6.0421	6.065	6.0156	6.0571	18895828.0
2009-08-21 17:00:00	AAPL	Stock	6.0539	6.0539	6.0432	6.0479	308560.0
2009-08-21 18:00:00	AAPL	Stock	6.0464	6.0464	6.0364	6.0375	405272.0
2009-08-21 19:00:00	AAPL	Stock	6.0368	6.0375	6.0357	6.0357	376740.0
2009-08-21 05:00:00	MSFT	Stock	23.74	23.74	23.74	23.74	100.0
2009-08-21 07:00:00	MSFT	Stock	23.75	23.75	23.74	23.74	2100.0
2009-08-21 08:00:00	MSFT	Stock	23.7	23.78	23.7	23.75	12334.0
2009-08-21 09:00:00	MSFT	Stock	23.76	23.93	23.72	23.84	5660222.0
2009-08-21 10:00:00	MSFT	Stock	23.85	24.1	23.848	24.01	10012027.0
2009-08-21 11:00:00	MSFT	Stock	24.01	24.05	24.0	24.01	3754297.0
2009-08-21 12:00:00	MSFT	Stock	24.01	24.06	23.96	24.03	4273550.0
2009-08-21 13:00:00	MSFT	Stock	24.03	24.13	24.025	24.13	4174759.0
2009-08-21 14:00:00	MSFT	Stock	24.125	24.29	24.11	24.28	9074194.0
2009-08-21 15:00:00	MSFT	Stock	24.29	24.42	24.26	24.41	20393828.0
2009-08-21 16:00:00	MSFT	Stock	24.4	24.45	24.11	24.41	3173018.0
2009-08-21 17:00:00	MSFT	Stock	24.39	24.39	24.36	24.37	12483.0
2009-08-21 18:00:00	MSFT	Stock	24.41	24.41	24.37	24.37	8196.0
2009-08-21 19:00:00	MSFT	Stock	24.37	24.38	24.36	24.36	3862.0
2009-08-21 07:00:00	NVDA	Stock	0.3438	0.3438	0.3438	0.3438	20000.0
2009-08-21 08:00:00	NVDA	Stock	0.3438	0.3462	0.3438	0.3462	181600.0
2009-08-21 09:00:00	NVDA	Stock	0.3453	0.347	0.3382	0.341	146420600.0
2009-08-21 10:00:00	NVDA	Stock	0.3413	0.3468	0.3405	0.344	166892800.0
2009-08-21 11:00:00	NVDA	Stock	0.3442	0.346	0.3424	0.3448	56094760.0
2009-08-21 12:00:00	NVDA	Stock	0.3449	0.3453	0.3445	0.3448	26482200.0
2009-08-21 13:00:00	NVDA	Stock	0.3448	0.3451	0.344	0.344	38330960.0
2009-08-21 14:00:00	NVDA	Stock	0.344	0.3465	0.344	0.3465	49651760.0
2009-08-21 15:00:00	NVDA	Stock	0.3465	0.3488	0.3462	0.3482	110158120.0
2009-08-21 16:00:00	NVDA	Stock	0.348	0.3493	0.3442	0.3482	10954760.0
2009-08-21 18:00:00	NVDA	Stock	0.348	0.348	0.348	0.348	44000.0
2009-08-21 19:00:00	NVDA	Stock	0.3478	0.3485	0.3453	0.3485	68000.0
2009-08-21 04:00:00	AMZN	Stock	4.175	4.175	4.175	4.175	20000.0
2009-08-21 06:00:00	AMZN	Stock	4.223	4.223	4.223	4.223	2000.0
2009-08-21 08:00:00	AMZN	Stock	4.217	4.23	4.217	4.2175	91700.0
2009-08-21 09:00:00	AMZN	Stock	4.2245	4.2475	4.177	4.193	21674140.0
2009-08-21 10:00:00	AMZN	Stock	4.1935	4.2495	4.1935	4.2325	23626460.0
2009-08-21 11:00:00	AMZN	Stock	4.231	4.238	4.2225	4.227	8898280.0
2009-08-21 12:00:00	AMZN	Stock	4.2275	4.235	4.225	4.228	5538420.0
2009-08-21 13:00:00	AMZN	Stock	4.228	4.23	4.2085	4.2095	8919240.0
2009-08-21 14:00:00	AMZN	Stock	4.2086	4.226	4.2	4.225	10230180.0
2009-08-21 15:00:00	AMZN	Stock	4.2255	4.253	4.222	4.2455	30570160.0
2009-08-21 16:00:00	AMZN	Stock	4.2495	4.254	4.2288	4.2505	11438960.0

> showing 50 of 41,861 rows — these rows as CSV

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