PREVIEW / stock_30min / 2008-02-26

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-26.parquet
  size:    1.2 MB
  rows:    68,556
  symbols: 3,256

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-02-26 04:00:00	AAPL	Stock	4.2843	4.2893	4.2843	4.2893	44800.0
2008-02-26 04:30:00	AAPL	Stock	4.2946	4.2946	4.2946	4.2946	4340.0
2008-02-26 05:00:00	AAPL	Stock	4.29	4.2907	4.29	4.2907	16800.0
2008-02-26 05:30:00	AAPL	Stock	4.2854	4.2911	4.2854	4.2911	75712.0
2008-02-26 06:00:00	AAPL	Stock	4.2886	4.2957	4.2821	4.2821	39200.0
2008-02-26 06:30:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	16800.0
2008-02-26 07:00:00	AAPL	Stock	4.2864	4.3	4.2857	4.2929	102088.0
2008-02-26 07:30:00	AAPL	Stock	4.2929	4.2979	4.28	4.2807	412888.0
2008-02-26 08:00:00	AAPL	Stock	4.2764	4.2807	4.2375	4.2411	1393644.0
2008-02-26 08:30:00	AAPL	Stock	4.2411	4.2536	4.2236	4.2436	2856308.0
2008-02-26 09:00:00	AAPL	Stock	4.245	4.2482	4.1968	4.2018	5293820.0
2008-02-26 09:30:00	AAPL	Stock	4.2014	4.24	4.1696	4.1739	156392152.0
2008-02-26 10:00:00	AAPL	Stock	4.1743	4.1964	4.1282	4.1389	154127708.0
2008-02-26 10:30:00	AAPL	Stock	4.1379	4.2064	4.1229	4.1907	158622100.0
2008-02-26 11:00:00	AAPL	Stock	4.1911	4.2	4.1704	4.1843	83162828.0
2008-02-26 11:30:00	AAPL	Stock	4.1839	4.2714	4.1821	4.2589	117472208.0
2008-02-26 12:00:00	AAPL	Stock	4.2589	4.3246	4.25	4.3057	148655360.0
2008-02-26 12:30:00	AAPL	Stock	4.3057	4.3079	4.2611	4.2871	86415532.0
2008-02-26 13:00:00	AAPL	Stock	4.2864	4.3082	4.2714	4.2794	67389420.0
2008-02-26 13:30:00	AAPL	Stock	4.2789	4.2925	4.2625	4.2736	93656416.0
2008-02-26 14:00:00	AAPL	Stock	4.2736	4.2879	4.2629	4.2796	66365236.0
2008-02-26 14:30:00	AAPL	Stock	4.28	4.3157	4.2725	4.3125	84158676.0
2008-02-26 15:00:00	AAPL	Stock	4.3121	4.3136	4.2368	4.2529	121077796.0
2008-02-26 15:30:00	AAPL	Stock	4.2525	4.2661	4.2179	4.2554	120236312.0
2008-02-26 16:00:00	AAPL	Stock	4.255	4.2861	4.2367	4.255	30858044.0
2008-02-26 16:30:00	AAPL	Stock	4.2532	4.2554	4.2389	4.255	1475236.0
2008-02-26 17:00:00	AAPL	Stock	4.2525	4.2536	4.2386	4.2479	406140.0
2008-02-26 17:30:00	AAPL	Stock	4.2461	4.2554	4.2396	4.2504	8681456.0
2008-02-26 18:00:00	AAPL	Stock	4.2464	4.2479	4.2379	4.2379	163660.0
2008-02-26 18:30:00	AAPL	Stock	4.2411	4.2429	4.2382	4.2429	122360.0
2008-02-26 19:00:00	AAPL	Stock	4.2429	4.2429	4.2393	4.2411	103208.0
2008-02-26 19:30:00	AAPL	Stock	4.2411	4.2411	4.2375	4.2393	261772.0
2008-02-26 04:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	100.0
2008-02-26 06:30:00	MSFT	Stock	27.95	28.05	27.95	28.05	2500.0
2008-02-26 07:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	4500.0
2008-02-26 07:30:00	MSFT	Stock	27.82	27.95	27.82	27.95	1600.0
2008-02-26 08:00:00	MSFT	Stock	27.95	27.95	27.84	27.85	10770.0
2008-02-26 08:30:00	MSFT	Stock	27.85	27.85	27.75	27.8	27692.0
2008-02-26 09:00:00	MSFT	Stock	27.84	27.84	27.65	27.73	53784.0
2008-02-26 09:30:00	MSFT	Stock	27.74	27.94	27.67	27.84	7626834.0
2008-02-26 10:00:00	MSFT	Stock	27.85	27.93	27.8	27.9	8154549.0
2008-02-26 10:30:00	MSFT	Stock	27.9	28.2	27.865	28.18	8969870.0
2008-02-26 11:00:00	MSFT	Stock	28.18	28.33	28.12	28.19	7333150.0
2008-02-26 11:30:00	MSFT	Stock	28.18	28.37	28.17	28.35	4337701.0
2008-02-26 12:00:00	MSFT	Stock	28.35	28.5	28.29	28.47	5664502.0
2008-02-26 12:30:00	MSFT	Stock	28.465	28.51	28.4	28.5	4581582.0
2008-02-26 13:00:00	MSFT	Stock	28.49	28.65	28.42	28.47	5676799.0
2008-02-26 13:30:00	MSFT	Stock	28.47	28.69	28.43	28.66	7471914.0
2008-02-26 14:00:00	MSFT	Stock	28.66	28.76	28.59	28.72	7827517.0
2008-02-26 14:30:00	MSFT	Stock	28.71	28.86	28.71	28.81	8721517.0

> showing 50 of 68,556 rows — these rows as CSV

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