PREVIEW / stock_1hour / 2008-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-21.parquet
  size:    817 KB
  rows:    40,217
  symbols: 3,293

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
2008-08-21 04:00:00	AAPL	Stock	6.2504	6.2504	6.2504	6.2504	5600.0
2008-08-21 05:00:00	AAPL	Stock	6.2236	6.2236	6.2236	6.2236	19600.0
2008-08-21 07:00:00	AAPL	Stock	6.2711	6.2711	6.2393	6.2396	51800.0
2008-08-21 08:00:00	AAPL	Stock	6.2482	6.2614	6.2364	6.2396	1286852.0
2008-08-21 09:00:00	AAPL	Stock	6.2411	6.2571	6.1704	6.2471	81072600.0
2008-08-21 10:00:00	AAPL	Stock	6.2475	6.2661	6.1493	6.1668	119572684.0
2008-08-21 11:00:00	AAPL	Stock	6.1675	6.1925	6.1389	6.1764	72858660.0
2008-08-21 12:00:00	AAPL	Stock	6.1757	6.1921	6.1464	6.1532	39914700.0
2008-08-21 13:00:00	AAPL	Stock	6.1536	6.2071	6.1514	6.2029	52040212.0
2008-08-21 14:00:00	AAPL	Stock	6.2018	6.2654	6.1929	6.2268	79532208.0
2008-08-21 15:00:00	AAPL	Stock	6.2268	6.2657	6.2111	6.2229	81834004.0
2008-08-21 16:00:00	AAPL	Stock	6.2243	6.2374	6.2064	6.2321	4930660.0
2008-08-21 17:00:00	AAPL	Stock	6.2229	6.2311	6.2161	6.225	278824.0
2008-08-21 18:00:00	AAPL	Stock	6.225	6.2286	6.225	6.2286	91784.0
2008-08-21 19:00:00	AAPL	Stock	6.2282	6.2282	6.2146	6.2161	240660.0
2008-08-21 04:00:00	MSFT	Stock	27.16	27.16	27.16	27.16	100.0
2008-08-21 08:00:00	MSFT	Stock	27.2	27.21	27.08	27.21	2350.0
2008-08-21 09:00:00	MSFT	Stock	27.2	27.2	26.91	27.069	4211288.0
2008-08-21 10:00:00	MSFT	Stock	27.06	27.12	26.86	26.95	10206611.0
2008-08-21 11:00:00	MSFT	Stock	26.95	27.09	26.9	27.01	6843417.0
2008-08-21 12:00:00	MSFT	Stock	27.0	27.05	27.0	27.0	3399354.0
2008-08-21 13:00:00	MSFT	Stock	27.0	27.12	26.99	27.02	6030140.0
2008-08-21 14:00:00	MSFT	Stock	27.01	27.2	27.0	27.1	4157816.0
2008-08-21 15:00:00	MSFT	Stock	27.105	27.23	27.1	27.18	6155057.0
2008-08-21 16:00:00	MSFT	Stock	27.2	27.2	27.035	27.18	1551099.0
2008-08-21 17:00:00	MSFT	Stock	27.14	27.18	27.14	27.18	33326.0
2008-08-21 19:00:00	MSFT	Stock	27.16	27.16	27.16	27.16	300.0
2008-08-21 07:00:00	NVDA	Stock	0.35	0.35	0.35	0.35	64000.0
2008-08-21 08:00:00	NVDA	Stock	0.35	0.35	0.3485	0.3485	122920.0
2008-08-21 09:00:00	NVDA	Stock	0.35	0.35	0.3388	0.343	130975000.0
2008-08-21 10:00:00	NVDA	Stock	0.343	0.3485	0.3425	0.3472	188110760.0
2008-08-21 11:00:00	NVDA	Stock	0.3473	0.3473	0.3395	0.34	110914480.0
2008-08-21 12:00:00	NVDA	Stock	0.34	0.341	0.3335	0.3358	160551800.0
2008-08-21 13:00:00	NVDA	Stock	0.3358	0.3382	0.3355	0.3362	82359360.0
2008-08-21 14:00:00	NVDA	Stock	0.3361	0.3398	0.336	0.3398	109083120.0
2008-08-21 15:00:00	NVDA	Stock	0.3398	0.3422	0.3393	0.3395	189652080.0
2008-08-21 16:00:00	NVDA	Stock	0.3395	0.3408	0.3391	0.3405	16773040.0
2008-08-21 17:00:00	NVDA	Stock	0.3395	0.3405	0.3395	0.3405	91520.0
2008-08-21 18:00:00	NVDA	Stock	0.3405	0.3408	0.3395	0.3408	117080.0
2008-08-21 19:00:00	NVDA	Stock	0.341	0.341	0.3388	0.3388	21080.0
2008-08-21 04:00:00	AMZN	Stock	4.0945	4.0945	4.0945	4.0945	4000.0
2008-08-21 07:00:00	AMZN	Stock	4.1185	4.1185	4.05	4.091	16000.0
2008-08-21 08:00:00	AMZN	Stock	4.1085	4.1085	4.075	4.075	22400.0
2008-08-21 09:00:00	AMZN	Stock	4.0715	4.15	4.049	4.1215	17892760.0
2008-08-21 10:00:00	AMZN	Stock	4.1225	4.145	4.1	4.1155	19082240.0
2008-08-21 11:00:00	AMZN	Stock	4.116	4.174	4.108	4.1285	22808820.0
2008-08-21 12:00:00	AMZN	Stock	4.128	4.1495	4.1105	4.132	10422800.0
2008-08-21 13:00:00	AMZN	Stock	4.1323	4.17	4.1215	4.132	10273760.0
2008-08-21 14:00:00	AMZN	Stock	4.1305	4.1885	4.13	4.1635	15467160.0
2008-08-21 15:00:00	AMZN	Stock	4.164	4.175	4.1555	4.1645	23659760.0

> showing 50 of 40,217 rows — these rows as CSV

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