PREVIEW / stock_30min / 2008-03-03

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-03.parquet
  size:    1.2 MB
  rows:    70,913
  symbols: 3,274

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-03-03 04:00:00	AAPL	Stock	4.4564	4.4564	4.44	4.44	36400.0
2008-03-03 06:00:00	AAPL	Stock	4.4518	4.4657	4.4518	4.4657	44800.0
2008-03-03 06:30:00	AAPL	Stock	4.4536	4.4536	4.4518	4.4518	39424.0
2008-03-03 07:00:00	AAPL	Stock	4.4546	4.455	4.4379	4.4404	59556.0
2008-03-03 07:30:00	AAPL	Stock	4.4532	4.4639	4.4393	4.4393	214368.0
2008-03-03 08:00:00	AAPL	Stock	4.4464	4.4714	4.4461	4.4661	1305528.0
2008-03-03 08:30:00	AAPL	Stock	4.4661	4.4686	4.4436	4.465	1467956.0
2008-03-03 09:00:00	AAPL	Stock	4.4479	4.45	4.4343	4.4443	1788752.0
2008-03-03 09:30:00	AAPL	Stock	4.4439	4.4993	4.3968	4.4068	190720656.0
2008-03-03 10:00:00	AAPL	Stock	4.4068	4.4211	4.3654	4.3896	167152356.0
2008-03-03 10:30:00	AAPL	Stock	4.3907	4.3907	4.3093	4.3175	142775220.0
2008-03-03 11:00:00	AAPL	Stock	4.3179	4.3307	4.3039	4.3079	116733708.0
2008-03-03 11:30:00	AAPL	Stock	4.3081	4.3461	4.2986	4.3436	111015436.0
2008-03-03 12:00:00	AAPL	Stock	4.3436	4.3482	4.3168	4.3286	79251816.0
2008-03-03 12:30:00	AAPL	Stock	4.33	4.3443	4.3089	4.3196	61802328.0
2008-03-03 13:00:00	AAPL	Stock	4.32	4.3243	4.3007	4.3111	53895632.0
2008-03-03 13:30:00	AAPL	Stock	4.3111	4.3389	4.2982	4.3057	75944512.0
2008-03-03 14:00:00	AAPL	Stock	4.3057	4.3071	4.2679	4.2807	113595664.0
2008-03-03 14:30:00	AAPL	Stock	4.2814	4.29	4.2143	4.2279	148656704.0
2008-03-03 15:00:00	AAPL	Stock	4.2279	4.2775	4.2257	4.2757	124427968.0
2008-03-03 15:30:00	AAPL	Stock	4.2761	4.3536	4.2589	4.3493	185597328.0
2008-03-03 16:00:00	AAPL	Stock	4.3496	4.3554	4.2771	4.345	14111692.0
2008-03-03 16:30:00	AAPL	Stock	4.3386	4.3507	4.2982	4.3507	1159200.0
2008-03-03 17:00:00	AAPL	Stock	4.3504	4.355	4.3051	4.3504	376964.0
2008-03-03 17:30:00	AAPL	Stock	4.3504	4.3511	4.345	4.35	743540.0
2008-03-03 18:00:00	AAPL	Stock	4.3504	4.3504	4.3289	4.3289	295148.0
2008-03-03 18:30:00	AAPL	Stock	4.3289	4.3321	4.3214	4.3214	366128.0
2008-03-03 19:00:00	AAPL	Stock	4.325	4.3275	4.325	4.325	126392.0
2008-03-03 19:30:00	AAPL	Stock	4.3296	4.3296	4.3214	4.3279	145432.0
2008-03-03 07:30:00	MSFT	Stock	27.25	27.3	27.25	27.3	3700.0
2008-03-03 08:00:00	MSFT	Stock	27.25	27.3	27.2	27.25	20689.0
2008-03-03 08:30:00	MSFT	Stock	27.25	27.3	27.2	27.2	33199.0
2008-03-03 09:00:00	MSFT	Stock	27.22	27.25	27.2	27.2	29525.0
2008-03-03 09:30:00	MSFT	Stock	27.23	27.32	27.02	27.27	8154819.0
2008-03-03 10:00:00	MSFT	Stock	27.26	27.39	27.24	27.35	7760328.0
2008-03-03 10:30:00	MSFT	Stock	27.35	27.36	27.15	27.19	4900226.0
2008-03-03 11:00:00	MSFT	Stock	27.2	27.28	27.16	27.22	3501798.0
2008-03-03 11:30:00	MSFT	Stock	27.23	27.31	27.11	27.27	4463609.0
2008-03-03 12:00:00	MSFT	Stock	27.27	27.35	27.21	27.34	3521326.0
2008-03-03 12:30:00	MSFT	Stock	27.33	27.372	27.16	27.182	2535167.0
2008-03-03 13:00:00	MSFT	Stock	27.182	27.22	27.07	27.138	2817691.0
2008-03-03 13:30:00	MSFT	Stock	27.13	27.22	27.09	27.15	3530669.0
2008-03-03 14:00:00	MSFT	Stock	27.14	27.26	27.13	27.2	3951314.0
2008-03-03 14:30:00	MSFT	Stock	27.2	27.25	27.07	27.09	3203205.0
2008-03-03 15:00:00	MSFT	Stock	27.09	27.14	27.03	27.04	8281128.0
2008-03-03 15:30:00	MSFT	Stock	27.04	27.04	26.87	26.99	13908612.0
2008-03-03 16:00:00	MSFT	Stock	27.0	27.161	26.96	26.99	2462505.0
2008-03-03 16:30:00	MSFT	Stock	27.116	27.174	26.98	26.99	31361.0
2008-03-03 17:00:00	MSFT	Stock	26.98	27.154	26.97	27.04	3578477.0
2008-03-03 17:30:00	MSFT	Stock	27.0	27.02	27.0	27.02	2730.0

> showing 50 of 70,913 rows — these rows as CSV

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