PREVIEW / stock_30min / 2008-08-19

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-19.parquet
  size:    1.2 MB
  rows:    67,738
  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:30: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	14000.0
2008-08-19 06:30:00	AAPL	Stock	6.2275	6.2275	6.2275	6.2275	13496.0
2008-08-19 07:00:00	AAPL	Stock	6.2857	6.2857	6.25	6.2679	12992.0
2008-08-19 07:30:00	AAPL	Stock	6.25	6.25	6.2321	6.2321	64400.0
2008-08-19 08:00:00	AAPL	Stock	6.2375	6.2511	6.2282	6.2504	443184.0
2008-08-19 08:30:00	AAPL	Stock	6.2504	6.2504	6.21	6.2246	3427872.0
2008-08-19 09:00:00	AAPL	Stock	6.2279	6.2389	6.2107	6.2364	1321516.0
2008-08-19 09:30:00	AAPL	Stock	6.2336	6.3239	6.225	6.3025	100935044.0
2008-08-19 10:00:00	AAPL	Stock	6.3018	6.3025	6.26	6.2775	44835000.0
2008-08-19 10:30:00	AAPL	Stock	6.2779	6.3068	6.2775	6.2886	37693096.0
2008-08-19 11:00:00	AAPL	Stock	6.2886	6.3064	6.2755	6.3036	24288320.0
2008-08-19 11:30:00	AAPL	Stock	6.3026	6.3132	6.2918	6.2986	26276908.0
2008-08-19 12:00:00	AAPL	Stock	6.2986	6.3014	6.2554	6.2671	34873524.0
2008-08-19 12:30:00	AAPL	Stock	6.2668	6.2986	6.2564	6.2832	27364680.0
2008-08-19 13:00:00	AAPL	Stock	6.2829	6.3071	6.2786	6.3039	22934688.0
2008-08-19 13:30:00	AAPL	Stock	6.3036	6.3171	6.2814	6.2825	24451112.0
2008-08-19 14:00:00	AAPL	Stock	6.2821	6.2911	6.2554	6.2554	31820460.0
2008-08-19 14:30:00	AAPL	Stock	6.255	6.2607	6.2143	6.2304	51298744.0
2008-08-19 15:00:00	AAPL	Stock	6.2296	6.2314	6.1361	6.1711	95857412.0
2008-08-19 15:30:00	AAPL	Stock	6.1718	6.2007	6.1454	6.1979	67499768.0
2008-08-19 16:00:00	AAPL	Stock	6.1974	6.2508	6.1834	6.2143	10812228.0
2008-08-19 16:30:00	AAPL	Stock	6.2146	6.2179	6.1975	6.2121	320712.0
2008-08-19 17:00:00	AAPL	Stock	6.2089	6.2196	6.2039	6.2107	763952.0
2008-08-19 17:30:00	AAPL	Stock	6.2125	6.2189	6.2096	6.2096	133056.0
2008-08-19 18:00:00	AAPL	Stock	6.2143	6.246	6.2089	6.2132	128800.0
2008-08-19 18:30:00	AAPL	Stock	6.2129	6.2129	6.2089	6.2125	107660.0
2008-08-19 19:00:00	AAPL	Stock	6.2146	6.2146	6.2111	6.2111	31640.0
2008-08-19 19:30:00	AAPL	Stock	6.2125	6.2168	6.2125	6.2168	149660.0
2008-08-19 08:00:00	MSFT	Stock	27.54	27.54	27.52	27.52	1000.0
2008-08-19 08:30:00	MSFT	Stock	27.57	27.57	27.5	27.5	9800.0
2008-08-19 09:00:00	MSFT	Stock	27.5	27.56	27.47	27.5	50900.0
2008-08-19 09:30:00	MSFT	Stock	27.54	27.75	27.5	27.68	4543821.0
2008-08-19 10:00:00	MSFT	Stock	27.679	27.68	27.45	27.46	2890623.0
2008-08-19 10:30:00	MSFT	Stock	27.46	27.63	27.45	27.52	3037552.0
2008-08-19 11:00:00	MSFT	Stock	27.52	27.53	27.44	27.471	2164750.0
2008-08-19 11:30:00	MSFT	Stock	27.478	27.51	27.41	27.42	2364844.0
2008-08-19 12:00:00	MSFT	Stock	27.42	27.47	27.37	27.445	1811768.0
2008-08-19 12:30:00	MSFT	Stock	27.45	27.5	27.39	27.39	1169018.0
2008-08-19 13:00:00	MSFT	Stock	27.39	27.54	27.39	27.53	1434055.0
2008-08-19 13:30:00	MSFT	Stock	27.53	27.62	27.41	27.429	3485099.0
2008-08-19 14:00:00	MSFT	Stock	27.42	27.44	27.34	27.35	2244379.0
2008-08-19 14:30:00	MSFT	Stock	27.355	27.42	27.35	27.37	1887484.0
2008-08-19 15:00:00	MSFT	Stock	27.37	27.41	27.27	27.368	2475251.0
2008-08-19 15:30:00	MSFT	Stock	27.365	27.4	27.27	27.34	5051680.0
2008-08-19 16:00:00	MSFT	Stock	27.36	27.468	27.311	27.43	4077364.0
2008-08-19 16:30:00	MSFT	Stock	27.47	27.47	27.32	27.32	42171.0
2008-08-19 17:00:00	MSFT	Stock	27.45	27.48	27.45	27.48	1600.0
2008-08-19 17:30:00	MSFT	Stock	27.48	27.48	27.47	27.48	18100.0
2008-08-19 18:00:00	MSFT	Stock	27.49	27.49	27.407	27.407	6850.0

> showing 50 of 67,738 rows — these rows as CSV

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