PREVIEW / stock_30min / 2008-02-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-07.parquet
  size:    1.2 MB
  rows:    69,431
  symbols: 3,254

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-07 04:00:00	AAPL	Stock	4.3225	4.3225	4.3225	4.3225	2800.0
2008-02-07 05:00:00	AAPL	Stock	4.3232	4.3232	4.3207	4.3207	58800.0
2008-02-07 05:30:00	AAPL	Stock	4.3104	4.3107	4.3104	4.3107	28000.0
2008-02-07 06:00:00	AAPL	Stock	4.3114	4.3114	4.305	4.305	25200.0
2008-02-07 06:30:00	AAPL	Stock	4.3107	4.3107	4.3107	4.3107	3500.0
2008-02-07 07:00:00	AAPL	Stock	4.3107	4.3136	4.2939	4.2939	74900.0
2008-02-07 07:30:00	AAPL	Stock	4.2946	4.3	4.2743	4.2743	385112.0
2008-02-07 08:00:00	AAPL	Stock	4.3571	4.3571	4.2357	4.2571	3394580.0
2008-02-07 08:30:00	AAPL	Stock	4.25	4.2761	4.2382	4.2668	3538220.0
2008-02-07 09:00:00	AAPL	Stock	4.2657	4.3571	4.2643	4.2857	11022284.0
2008-02-07 09:30:00	AAPL	Stock	4.2846	4.3393	4.1882	4.2107	305088000.0
2008-02-07 10:00:00	AAPL	Stock	4.2118	4.3536	4.2096	4.3114	306139456.0
2008-02-07 10:30:00	AAPL	Stock	4.3125	4.3182	4.2361	4.2811	172218872.0
2008-02-07 11:00:00	AAPL	Stock	4.2818	4.2936	4.2464	4.2761	97781796.0
2008-02-07 11:30:00	AAPL	Stock	4.2764	4.2993	4.2611	4.2872	90242124.0
2008-02-07 12:00:00	AAPL	Stock	4.2868	4.3036	4.2804	4.2861	71453956.0
2008-02-07 12:30:00	AAPL	Stock	4.2864	4.3671	4.2829	4.3489	128228856.0
2008-02-07 13:00:00	AAPL	Stock	4.3486	4.4	4.3196	4.3782	102253900.0
2008-02-07 13:30:00	AAPL	Stock	4.3782	4.4375	4.3711	4.4279	140567728.0
2008-02-07 14:00:00	AAPL	Stock	4.4271	4.4564	4.3789	4.3894	154778288.0
2008-02-07 14:30:00	AAPL	Stock	4.3893	4.3918	4.3011	4.3057	163881480.0
2008-02-07 15:00:00	AAPL	Stock	4.305	4.3314	4.2429	4.3154	177568860.0
2008-02-07 15:30:00	AAPL	Stock	4.3189	4.3439	4.2836	4.3289	138272232.0
2008-02-07 16:00:00	AAPL	Stock	4.33	4.3554	4.2912	4.3339	13300868.0
2008-02-07 16:30:00	AAPL	Stock	4.3343	4.34	4.33	4.3357	383600.0
2008-02-07 17:00:00	AAPL	Stock	4.3357	4.3714	4.2884	4.3625	1432844.0
2008-02-07 17:30:00	AAPL	Stock	4.3607	4.3714	4.33	4.3686	662592.0
2008-02-07 18:00:00	AAPL	Stock	4.3682	4.3857	4.3682	4.3721	681156.0
2008-02-07 18:30:00	AAPL	Stock	4.3754	4.3807	4.3571	4.3579	745724.0
2008-02-07 19:00:00	AAPL	Stock	4.3571	4.3668	4.35	4.3661	183708.0
2008-02-07 19:30:00	AAPL	Stock	4.3664	4.3671	4.3607	4.3671	292908.0
2008-02-07 06:30:00	MSFT	Stock	28.3	28.31	28.3	28.31	1200.0
2008-02-07 07:00:00	MSFT	Stock	28.35	28.35	28.3	28.3	36300.0
2008-02-07 07:30:00	MSFT	Stock	28.25	28.26	28.1	28.12	15348.0
2008-02-07 08:00:00	MSFT	Stock	28.15	28.52	28.15	28.16	85247.0
2008-02-07 08:30:00	MSFT	Stock	28.15	28.25	28.12	28.17	171954.0
2008-02-07 09:00:00	MSFT	Stock	28.17	28.4	28.15	28.38	275159.0
2008-02-07 09:30:00	MSFT	Stock	28.36	28.39	28.0	28.259	22423333.0
2008-02-07 10:00:00	MSFT	Stock	28.25	28.68	28.23	28.52	18865744.0
2008-02-07 10:30:00	MSFT	Stock	28.51	28.52	28.26	28.33	8950452.0
2008-02-07 11:00:00	MSFT	Stock	28.33	28.39	28.18	28.24	6827882.0
2008-02-07 11:30:00	MSFT	Stock	28.24	28.34	28.18	28.322	5082324.0
2008-02-07 12:00:00	MSFT	Stock	28.323	28.37	28.24	28.28	6228545.0
2008-02-07 12:30:00	MSFT	Stock	28.27	28.48	28.2	28.4	8751414.0
2008-02-07 13:00:00	MSFT	Stock	28.4	28.59	28.26	28.49	8521849.0
2008-02-07 13:30:00	MSFT	Stock	28.48	28.74	28.382	28.7	13438127.0
2008-02-07 14:00:00	MSFT	Stock	28.7	28.78	28.42	28.45	12812471.0
2008-02-07 14:30:00	MSFT	Stock	28.46	28.47	28.15	28.16	12003112.0
2008-02-07 15:00:00	MSFT	Stock	28.16	28.23	27.95	28.12	17301424.0
2008-02-07 15:30:00	MSFT	Stock	28.13	28.19	27.9	28.12	19281081.0

> showing 50 of 69,431 rows — these rows as CSV

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