PREVIEW / stock_1hour / 2008-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-19.parquet
  size:    812 KB
  rows:    39,641
  symbols: 3,306

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-19 05:00:00	AAPL	Stock	6.2414	6.2414	6.2275	6.2275	15400.0
2008-08-19 06:00:00	AAPL	Stock	6.2275	6.2275	6.2275	6.2275	27496.0
2008-08-19 07:00:00	AAPL	Stock	6.2857	6.2857	6.2321	6.2321	77392.0
2008-08-19 08:00:00	AAPL	Stock	6.2375	6.2511	6.21	6.2246	3871056.0
2008-08-19 09:00:00	AAPL	Stock	6.2279	6.3239	6.2107	6.3025	102256560.0
2008-08-19 10:00:00	AAPL	Stock	6.3018	6.3068	6.26	6.2886	82528096.0
2008-08-19 11:00:00	AAPL	Stock	6.2886	6.3132	6.2755	6.2986	50565228.0
2008-08-19 12:00:00	AAPL	Stock	6.2986	6.3014	6.2554	6.2832	62238204.0
2008-08-19 13:00:00	AAPL	Stock	6.2829	6.3171	6.2786	6.2825	47385800.0
2008-08-19 14:00:00	AAPL	Stock	6.2821	6.2911	6.2143	6.2304	83119204.0
2008-08-19 15:00:00	AAPL	Stock	6.2296	6.2314	6.1361	6.1979	163357180.0
2008-08-19 16:00:00	AAPL	Stock	6.1974	6.2508	6.1834	6.2121	11132940.0
2008-08-19 17:00:00	AAPL	Stock	6.2089	6.2196	6.2039	6.2096	897008.0
2008-08-19 18:00:00	AAPL	Stock	6.2143	6.246	6.2089	6.2125	236460.0
2008-08-19 19:00:00	AAPL	Stock	6.2146	6.2168	6.2111	6.2168	181300.0
2008-08-19 08:00:00	MSFT	Stock	27.54	27.57	27.5	27.5	10800.0
2008-08-19 09:00:00	MSFT	Stock	27.5	27.75	27.47	27.68	4594721.0
2008-08-19 10:00:00	MSFT	Stock	27.679	27.68	27.45	27.52	5928175.0
2008-08-19 11:00:00	MSFT	Stock	27.52	27.53	27.41	27.42	4529594.0
2008-08-19 12:00:00	MSFT	Stock	27.42	27.5	27.37	27.39	2980786.0
2008-08-19 13:00:00	MSFT	Stock	27.39	27.62	27.39	27.429	4919154.0
2008-08-19 14:00:00	MSFT	Stock	27.42	27.44	27.34	27.37	4131863.0
2008-08-19 15:00:00	MSFT	Stock	27.37	27.41	27.27	27.34	7526931.0
2008-08-19 16:00:00	MSFT	Stock	27.36	27.47	27.311	27.32	4119535.0
2008-08-19 17:00:00	MSFT	Stock	27.45	27.48	27.45	27.48	19700.0
2008-08-19 18:00:00	MSFT	Stock	27.49	27.49	27.407	27.46	9352.0
2008-08-19 19:00:00	MSFT	Stock	27.48	27.48	27.45	27.45	3500.0
2008-08-19 08:00:00	NVDA	Stock	0.3313	0.3313	0.3248	0.325	981520.0
2008-08-19 09:00:00	NVDA	Stock	0.325	0.3375	0.323	0.337	128807320.0
2008-08-19 10:00:00	NVDA	Stock	0.337	0.337	0.3328	0.335	138218280.0
2008-08-19 11:00:00	NVDA	Stock	0.3353	0.3353	0.3285	0.3288	130580360.0
2008-08-19 12:00:00	NVDA	Stock	0.3288	0.3338	0.3283	0.3335	94960920.0
2008-08-19 13:00:00	NVDA	Stock	0.3333	0.3368	0.3332	0.3333	141436400.0
2008-08-19 14:00:00	NVDA	Stock	0.3333	0.336	0.3328	0.335	109288600.0
2008-08-19 15:00:00	NVDA	Stock	0.335	0.3369	0.333	0.3355	229298360.0
2008-08-19 16:00:00	NVDA	Stock	0.3358	0.3373	0.3334	0.337	24425720.0
2008-08-19 17:00:00	NVDA	Stock	0.3362	0.3382	0.3362	0.3382	219360.0
2008-08-19 18:00:00	NVDA	Stock	0.3375	0.339	0.3375	0.339	110800.0
2008-08-19 19:00:00	NVDA	Stock	0.339	0.339	0.3385	0.339	149040.0
2008-08-19 08:00:00	AMZN	Stock	4.15	4.15	4.129	4.129	108900.0
2008-08-19 09:00:00	AMZN	Stock	4.13	4.1755	4.101	4.146	16700580.0
2008-08-19 10:00:00	AMZN	Stock	4.1465	4.1745	4.1225	4.1505	20070880.0
2008-08-19 11:00:00	AMZN	Stock	4.1505	4.1595	4.128	4.132	10773040.0
2008-08-19 12:00:00	AMZN	Stock	4.132	4.145	4.116	4.122	11431700.0
2008-08-19 13:00:00	AMZN	Stock	4.123	4.174	4.114	4.147	12236780.0
2008-08-19 14:00:00	AMZN	Stock	4.1465	4.1605	4.0945	4.099	23115660.0
2008-08-19 15:00:00	AMZN	Stock	4.099	4.1	4.053	4.0645	31037600.0
2008-08-19 16:00:00	AMZN	Stock	4.0645	4.1218	4.0641	4.0825	5063000.0
2008-08-19 18:00:00	AMZN	Stock	4.1038	4.1038	4.0875	4.0875	6000.0
2008-08-19 19:00:00	AMZN	Stock	4.085	4.085	4.085	4.085	6420.0

> showing 50 of 39,641 rows — these rows as CSV

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