PREVIEW / stock_30min / 2008-11-14

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-14.parquet
  size:    1.2 MB
  rows:    68,092
  symbols: 3,296

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-11-14 07:00:00	AAPL	Stock	3.4071	3.4071	3.4071	3.4071	2800.0
2008-11-14 07:30:00	AAPL	Stock	3.3789	3.3789	3.3789	3.3789	2800.0
2008-11-14 08:00:00	AAPL	Stock	3.3954	3.4039	3.3393	3.3554	2881480.0
2008-11-14 08:30:00	AAPL	Stock	3.3536	3.3732	3.3532	3.3718	1453116.0
2008-11-14 09:00:00	AAPL	Stock	3.3707	3.3825	3.3393	3.3486	3277904.0
2008-11-14 09:30:00	AAPL	Stock	3.3479	3.355	3.2618	3.2875	214758320.0
2008-11-14 10:00:00	AAPL	Stock	3.2871	3.3086	3.2411	3.2853	135681224.0
2008-11-14 10:30:00	AAPL	Stock	3.2846	3.2964	3.2593	3.2739	84552272.0
2008-11-14 11:00:00	AAPL	Stock	3.2743	3.2925	3.2504	3.2554	76836452.0
2008-11-14 11:30:00	AAPL	Stock	3.2554	3.2679	3.2357	3.2429	80424120.0
2008-11-14 12:00:00	AAPL	Stock	3.2421	3.2543	3.2289	3.2479	67468380.0
2008-11-14 12:30:00	AAPL	Stock	3.2471	3.2857	3.2454	3.2753	70072156.0
2008-11-14 13:00:00	AAPL	Stock	3.2745	3.2814	3.2475	3.2789	55015016.0
2008-11-14 13:30:00	AAPL	Stock	3.2758	3.2943	3.2607	3.2764	81342744.0
2008-11-14 14:00:00	AAPL	Stock	3.2764	3.3339	3.2687	3.2968	104042484.0
2008-11-14 14:30:00	AAPL	Stock	3.2964	3.3518	3.2804	3.3464	124920320.0
2008-11-14 15:00:00	AAPL	Stock	3.3464	3.3568	3.2857	3.2943	121925272.0
2008-11-14 15:30:00	AAPL	Stock	3.2943	3.3014	3.2143	3.2214	147533624.0
2008-11-14 16:00:00	AAPL	Stock	3.2211	3.2924	3.1943	3.2125	20445208.0
2008-11-14 16:30:00	AAPL	Stock	3.2125	3.2821	3.2075	3.21	1495368.0
2008-11-14 17:00:00	AAPL	Stock	3.2229	3.2229	3.2082	3.2125	495460.0
2008-11-14 17:30:00	AAPL	Stock	3.2161	3.2232	3.2136	3.2232	511224.0
2008-11-14 18:00:00	AAPL	Stock	3.2214	3.2229	3.2196	3.2229	413560.0
2008-11-14 18:30:00	AAPL	Stock	3.2196	3.2196	3.2132	3.2143	160776.0
2008-11-14 19:00:00	AAPL	Stock	3.2143	3.2186	3.2136	3.2143	80276.0
2008-11-14 19:30:00	AAPL	Stock	3.2136	3.2232	3.2125	3.2225	188160.0
2008-11-14 04:00:00	MSFT	Stock	21.0	21.0	21.0	21.0	100.0
2008-11-14 05:00:00	MSFT	Stock	21.01	21.01	21.01	21.01	100.0
2008-11-14 07:00:00	MSFT	Stock	21.0	21.0	21.0	21.0	1500.0
2008-11-14 07:30:00	MSFT	Stock	20.96	21.01	20.96	21.0	2100.0
2008-11-14 08:00:00	MSFT	Stock	21.01	21.1	20.55	20.56	56995.0
2008-11-14 08:30:00	MSFT	Stock	20.65	20.75	20.61	20.75	23307.0
2008-11-14 09:00:00	MSFT	Stock	20.73	20.73	20.5	20.57	73415.0
2008-11-14 09:30:00	MSFT	Stock	20.56	20.82	20.4	20.7	8313159.0
2008-11-14 10:00:00	MSFT	Stock	20.69	20.77	20.37	20.52	5809433.0
2008-11-14 10:30:00	MSFT	Stock	20.52	20.52	20.26	20.27	4498299.0
2008-11-14 11:00:00	MSFT	Stock	20.27	20.29	20.078	20.13	5469299.0
2008-11-14 11:30:00	MSFT	Stock	20.139	20.22	20.08	20.11	3907385.0
2008-11-14 12:00:00	MSFT	Stock	20.11	20.15	19.84	20.04	4478984.0
2008-11-14 12:30:00	MSFT	Stock	20.048	20.24	19.972	20.19	3899730.0
2008-11-14 13:00:00	MSFT	Stock	20.19	20.191	19.91	20.09	4053135.0
2008-11-14 13:30:00	MSFT	Stock	20.09	20.49	20.072	20.36	5344160.0
2008-11-14 14:00:00	MSFT	Stock	20.36	20.83	20.33	20.76	6308519.0
2008-11-14 14:30:00	MSFT	Stock	20.76	21.1	20.57	21.06	7387751.0
2008-11-14 15:00:00	MSFT	Stock	21.06	21.34	20.91	20.99	13098693.0
2008-11-14 15:30:00	MSFT	Stock	20.98	21.03	19.65	19.976	18250363.0
2008-11-14 16:00:00	MSFT	Stock	19.93	20.6	19.81	19.9	4232079.0
2008-11-14 16:30:00	MSFT	Stock	20.06	20.06	19.9	19.96	283594.0
2008-11-14 17:00:00	MSFT	Stock	20.06	20.06	19.95	19.98	27208.0
2008-11-14 17:30:00	MSFT	Stock	19.98	20.06	19.98	20.05	68260.0

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

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