PREVIEW / stock_30min / 2008-10-09

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-09.parquet
  size:    1.3 MB
  rows:    74,827
  symbols: 3,366

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-10-09 04:00:00	AAPL	Stock	3.3014	3.3064	3.3014	3.3064	25200.0
2008-10-09 05:30:00	AAPL	Stock	3.3364	3.3364	3.3364	3.3364	2800.0
2008-10-09 06:00:00	AAPL	Stock	3.305	3.305	3.305	3.305	2800.0
2008-10-09 07:00:00	AAPL	Stock	3.3107	3.3571	3.3036	3.3036	240100.0
2008-10-09 07:30:00	AAPL	Stock	3.3036	3.3107	3.2857	3.2857	234920.0
2008-10-09 08:00:00	AAPL	Stock	3.2964	3.3071	3.2654	3.2957	2435384.0
2008-10-09 08:30:00	AAPL	Stock	3.2982	3.3143	3.2768	3.2854	3937780.0
2008-10-09 09:00:00	AAPL	Stock	3.2857	3.335	3.2836	3.3304	5989004.0
2008-10-09 09:30:00	AAPL	Stock	3.3329	3.4214	3.3214	3.3271	202737836.0
2008-10-09 10:00:00	AAPL	Stock	3.3267	3.3696	3.2793	3.2807	144204704.0
2008-10-09 10:30:00	AAPL	Stock	3.2818	3.3061	3.2246	3.2546	138921916.0
2008-10-09 11:00:00	AAPL	Stock	3.255	3.2875	3.1814	3.2332	134447572.0
2008-10-09 11:30:00	AAPL	Stock	3.2325	3.3343	3.2143	3.2836	121935604.0
2008-10-09 12:00:00	AAPL	Stock	3.2836	3.3339	3.2614	3.3096	74758964.0
2008-10-09 12:30:00	AAPL	Stock	3.3107	3.3257	3.2714	3.2829	66798872.0
2008-10-09 13:00:00	AAPL	Stock	3.2829	3.3286	3.2768	3.3057	65724316.0
2008-10-09 13:30:00	AAPL	Stock	3.3079	3.3425	3.2646	3.2907	86724736.0
2008-10-09 14:00:00	AAPL	Stock	3.2914	3.3214	3.2489	3.2629	71171408.0
2008-10-09 14:30:00	AAPL	Stock	3.2621	3.2896	3.2229	3.2232	92064000.0
2008-10-09 15:00:00	AAPL	Stock	3.225	3.2589	3.1921	3.2121	152340272.0
2008-10-09 15:30:00	AAPL	Stock	3.2125	3.2579	3.0929	3.1786	207093740.0
2008-10-09 16:00:00	AAPL	Stock	3.1786	3.2719	3.1375	3.1429	32880708.0
2008-10-09 16:30:00	AAPL	Stock	3.1464	3.3003	3.1464	3.1518	1759520.0
2008-10-09 17:00:00	AAPL	Stock	3.1525	3.1679	3.1429	3.1654	528808.0
2008-10-09 17:30:00	AAPL	Stock	3.1643	3.1729	3.1607	3.1643	384440.0
2008-10-09 18:00:00	AAPL	Stock	3.1707	3.2143	3.1607	3.1696	267540.0
2008-10-09 18:30:00	AAPL	Stock	3.1729	3.1921	3.1636	3.1921	359772.0
2008-10-09 19:00:00	AAPL	Stock	3.1857	3.1918	3.1779	3.1839	224140.0
2008-10-09 19:30:00	AAPL	Stock	3.1911	3.2071	3.1875	3.1964	125664.0
2008-10-09 07:00:00	MSFT	Stock	23.77	23.77	23.75	23.75	2000.0
2008-10-09 07:30:00	MSFT	Stock	23.42	23.58	23.42	23.5	18436.0
2008-10-09 08:00:00	MSFT	Stock	23.5	23.6	23.47	23.6	41890.0
2008-10-09 08:30:00	MSFT	Stock	23.59	23.75	23.59	23.7	67143.0
2008-10-09 09:00:00	MSFT	Stock	23.74	23.79	23.65	23.76	89385.0
2008-10-09 09:30:00	MSFT	Stock	23.76	23.91	23.27	23.608	11540350.0
2008-10-09 10:00:00	MSFT	Stock	23.6	23.75	23.42	23.47	8391434.0
2008-10-09 10:30:00	MSFT	Stock	23.47	23.7	23.43	23.58	8140925.0
2008-10-09 11:00:00	MSFT	Stock	23.58	23.69	23.21	23.48	10071928.0
2008-10-09 11:30:00	MSFT	Stock	23.48	23.75	23.35	23.37	7959224.0
2008-10-09 12:00:00	MSFT	Stock	23.37	23.68	23.31	23.57	4181000.0
2008-10-09 12:30:00	MSFT	Stock	23.57	23.61	23.34	23.54	4046588.0
2008-10-09 13:00:00	MSFT	Stock	23.56	23.89	23.56	23.77	6611757.0
2008-10-09 13:30:00	MSFT	Stock	23.79	23.9	23.54	23.66	7077245.0
2008-10-09 14:00:00	MSFT	Stock	23.66	23.73	23.41	23.52	6378869.0
2008-10-09 14:30:00	MSFT	Stock	23.51	23.64	23.27	23.31	7073366.0
2008-10-09 15:00:00	MSFT	Stock	23.31	23.4	22.89	22.97	13750989.0
2008-10-09 15:30:00	MSFT	Stock	22.96	23.11	22.07	22.32	25967241.0
2008-10-09 16:00:00	MSFT	Stock	22.31	24.14	22.128	22.308	8538487.0
2008-10-09 16:30:00	MSFT	Stock	23.008	23.259	22.3	22.32	244760.0
2008-10-09 17:00:00	MSFT	Stock	22.32	22.4	22.31	22.37	13050.0

> showing 50 of 74,827 rows — these rows as CSV

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