PREVIEW / stock_1hour / 2010-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-27.parquet
  size:    908 KB
  rows:    43,648
  symbols: 3,520

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-12-27 04:00:00	AAPL	Stock	11.5486	11.5486	11.5343	11.5343	14896.0
2010-12-27 07:00:00	AAPL	Stock	11.5361	11.5657	11.5329	11.5364	89600.0
2010-12-27 08:00:00	AAPL	Stock	11.5329	11.5411	11.5107	11.5236	447776.0
2010-12-27 09:00:00	AAPL	Stock	11.5246	11.58	11.4829	11.5043	67702684.0
2010-12-27 10:00:00	AAPL	Stock	11.5036	11.5282	11.5011	11.5054	37892232.0
2010-12-27 11:00:00	AAPL	Stock	11.5064	11.5214	11.5057	11.5203	21496468.0
2010-12-27 12:00:00	AAPL	Stock	11.52	11.5421	11.5175	11.5354	18428312.0
2010-12-27 13:00:00	AAPL	Stock	11.5343	11.6021	11.5339	11.6007	32271372.0
2010-12-27 14:00:00	AAPL	Stock	11.6014	11.6229	11.5979	11.6143	25844868.0
2010-12-27 15:00:00	AAPL	Stock	11.6139	11.6182	11.5964	11.5964	32387656.0
2010-12-27 16:00:00	AAPL	Stock	11.5957	11.6091	11.5529	11.5964	4649820.0
2010-12-27 17:00:00	AAPL	Stock	11.5989	11.6021	11.595	11.5982	360052.0
2010-12-27 18:00:00	AAPL	Stock	11.6018	11.6032	11.5957	11.6011	229768.0
2010-12-27 19:00:00	AAPL	Stock	11.5982	11.6018	11.5964	11.5964	271516.0
2010-12-27 07:00:00	MSFT	Stock	28.1	28.11	28.08	28.1	2600.0
2010-12-27 08:00:00	MSFT	Stock	28.14	28.17	28.1	28.17	4600.0
2010-12-27 09:00:00	MSFT	Stock	28.17	28.26	27.92	27.99	2587683.0
2010-12-27 10:00:00	MSFT	Stock	27.985	28.07	27.88	27.995	3285203.0
2010-12-27 11:00:00	MSFT	Stock	27.995	28.03	27.98	27.999	2200576.0
2010-12-27 12:00:00	MSFT	Stock	28.0	28.03	27.98	28.03	1994933.0
2010-12-27 13:00:00	MSFT	Stock	28.03	28.17	28.0	28.12	2895621.0
2010-12-27 14:00:00	MSFT	Stock	28.12	28.12	28.05	28.08	1637318.0
2010-12-27 15:00:00	MSFT	Stock	28.08	28.14	28.06	28.07	4062500.0
2010-12-27 16:00:00	MSFT	Stock	28.07	28.14	28.03	28.096	925905.0
2010-12-27 17:00:00	MSFT	Stock	28.1	28.14	28.09	28.1	7226.0
2010-12-27 18:00:00	MSFT	Stock	28.13	28.15	28.07	28.15	8119.0
2010-12-27 19:00:00	MSFT	Stock	28.15	28.15	28.08	28.15	825.0
2010-12-27 08:00:00	NVDA	Stock	0.372	0.372	0.372	0.372	38000.0
2010-12-27 09:00:00	NVDA	Stock	0.372	0.372	0.3652	0.3668	39685240.0
2010-12-27 10:00:00	NVDA	Stock	0.3668	0.3703	0.366	0.3703	49336240.0
2010-12-27 11:00:00	NVDA	Stock	0.37	0.3715	0.37	0.3708	24934960.0
2010-12-27 12:00:00	NVDA	Stock	0.3705	0.3733	0.3705	0.3733	20062560.0
2010-12-27 13:00:00	NVDA	Stock	0.3733	0.3778	0.373	0.3755	46322600.0
2010-12-27 14:00:00	NVDA	Stock	0.3755	0.376	0.3748	0.3759	22573120.0
2010-12-27 15:00:00	NVDA	Stock	0.3758	0.3763	0.3743	0.375	48895760.0
2010-12-27 16:00:00	NVDA	Stock	0.375	0.3763	0.372	0.375	3516160.0
2010-12-27 17:00:00	NVDA	Stock	0.3735	0.3735	0.3735	0.3735	32000.0
2010-12-27 19:00:00	NVDA	Stock	0.3745	0.375	0.3745	0.375	128000.0
2010-12-27 06:00:00	AMZN	Stock	9.133	9.148	9.133	9.133	6000.0
2010-12-27 08:00:00	AMZN	Stock	9.0815	9.0825	9.068	9.075	38100.0
2010-12-27 09:00:00	AMZN	Stock	9.087	9.13	9.05	9.054	8026220.0
2010-12-27 10:00:00	AMZN	Stock	9.0535	9.0995	9.05	9.0505	7154520.0
2010-12-27 11:00:00	AMZN	Stock	9.0535	9.07	9.0225	9.0415	5708500.0
2010-12-27 12:00:00	AMZN	Stock	9.0434	9.0915	9.0375	9.0755	4552840.0
2010-12-27 13:00:00	AMZN	Stock	9.077	9.157	9.077	9.1275	7079680.0
2010-12-27 14:00:00	AMZN	Stock	9.1285	9.1485	9.108	9.1155	4399320.0
2010-12-27 15:00:00	AMZN	Stock	9.1175	9.132	9.105	9.107	6507720.0
2010-12-27 16:00:00	AMZN	Stock	9.1135	9.1265	9.0892	9.0955	496280.0
2010-12-27 17:00:00	AMZN	Stock	9.1	9.1045	9.0965	9.0965	34820.0
2010-12-27 18:00:00	AMZN	Stock	9.107	9.107	9.107	9.107	45640.0

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

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